OrderOptionRequest Class

Definition

Namespace:

Microsoft.Xrm.Sdk.Messages

Assembly:

Microsoft.Xrm.Sdk.dll

Package:

Microsoft.PowerPlatform.Dataverse.Client v1.1.17

Contains the data that is needed to set the order for an option set.

public ref class OrderOptionRequest sealed : Microsoft::Xrm::Sdk::OrganizationRequest

[System.Runtime.Serialization.DataContract(Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")]
public sealed class OrderOptionRequest : Microsoft.Xrm.Sdk.OrganizationRequest

[<System.Runtime.Serialization.DataContract(Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")>]
type OrderOptionRequest = class
    inherit OrganizationRequest

Public NotInheritable Class OrderOptionRequest
Inherits OrganizationRequest

Inheritance

Object

OrganizationRequest

OrderOptionRequest

Attributes

DataContractAttribute

Examples

The following example shows how to use this message. For this sample to work correctly, you must be connected to the server to get an IOrganizationService interface instance.

This sample shows how to change the order of options in a local option set. The following sample retrieves a PicklistAttributeMetadata column and orders the options by label rather than by value.

/// <summary>
/// Demonstrates OrderOptions message
/// </summary>
/// <param name="service">Authenticated IOrganizationService instance</param>
static void OrderOptionsExample(IOrganizationService service) {

      string tableLogicalName = "account";
      string columnLogicalName = "customertypecode";
      string solutionUniqueName = "SolutionName";
      var columnDefinition = GetLocalChoiceColumn(tableLogicalName, columnLogicalName);

      // Output original order by value
      Console.WriteLine("Original order:");
      OutputOptions(columnDefinition.OptionSet);

      // Order the options by the Label value
      var orderedOptions = columnDefinition.OptionSet.Options
         .OrderBy(x => x.Label.UserLocalizedLabel.Label);

      List<int> newOrder = new();

      foreach (OptionMetadata option in orderedOptions)
      {
         newOrder.Add((int)option.Value);
      }

      // Prepare the request
      OrderOptionRequest request = new() {
         EntityLogicalName = tableLogicalName, // For local choice only
         AttributeLogicalName = columnLogicalName, // For local choice only
         SolutionUniqueName = solutionUniqueName,
         Values = newOrder.ToArray(),
         //OptionSetName = "globalChoiceName" //For global choice only
      };

      // Send the request
      service.Execute(request);

      // Retrieve the column definition again
      columnDefinition = GetLocalChoiceColumn(tableLogicalName, columnLogicalName);

      // Now ordered by Label
      Console.WriteLine("New order:");
      OutputOptions(columnDefinition.OptionSet);


      // Writes the order of the options
      void OutputOptions(OptionSetMetadata options) {
         foreach (OptionMetadata option in options.Options)
         {
            Console.WriteLine($"\t Value:{option.Value} Label:{option.Label.UserLocalizedLabel.Label}");
         }            
      }

      // Retrieves a local Choice column
      PicklistAttributeMetadata GetLocalChoiceColumn(string tableLogicalName, string columnLogicalName) {

         RetrieveAttributeRequest retrieveAttributeRequest = new()
         {
            EntityLogicalName = tableLogicalName,
            LogicalName = columnLogicalName
         };

         var retrieveAttributeResponse = (RetrieveAttributeResponse)service.Execute(retrieveAttributeRequest);

         return (PicklistAttributeMetadata)retrieveAttributeResponse.AttributeMetadata;
      }
}

Output:

Original order:
   Value:1 Label:Competitor
   Value:2 Label:Consultant
   Value:3 Label:Customer
   Value:4 Label:Investor
   Value:5 Label:Partner
   Value:6 Label:Influencer
   Value:7 Label:Press
   Value:8 Label:Prospect
   Value:9 Label:Reseller
   Value:10 Label:Supplier
   Value:11 Label:Vendor
   Value:12 Label:Other
New order:
   Value:1 Label:Competitor
   Value:2 Label:Consultant
   Value:3 Label:Customer
   Value:6 Label:Influencer
   Value:4 Label:Investor
   Value:12 Label:Other
   Value:5 Label:Partner
   Value:7 Label:Press
   Value:8 Label:Prospect
   Value:9 Label:Reseller
   Value:10 Label:Supplier
   Value:11 Label:Vendor

Sample code on GitHub

Work with choice columns

Remarks

For the Web API use the OrderOption action.

Usage

Pass an instance of this class to the Execute(OrganizationRequest) method, which returns an instance of OrderOptionResponse.

Privileges and Access Rights

To perform this action, the caller must have the System administrator or System customizer security roles.

Notes for Callers

You can use this message to edit options for global option sets or local option sets inside a PicklistAttributeMetadata attribute. For global option sets use the OptionSetName property. For local option sets specify the EntityLogicalName and the AttributeLogicalName.

Constructors

OrderOptionRequest()

Initializes a new instance of the OrderOptionRequest class.

Properties

AttributeLogicalName	Gets or sets the logical name of the PicklistAttributeMetadata local choice column. Optional.
EntityLogicalName	Gets or sets the logical name of the table that contains the local choice column. Optional.
ExtensionData	Gets or sets the structure that contains extra data. Optional. (Inherited from OrganizationRequest)
Item[String]	Gets or sets the indexer for the Parameters collection. (Inherited from OrganizationRequest)
OptionSetName	Gets or sets the name of the global choice you want to edit options for. Optional.
Parameters	Gets or sets the collection of parameters for the request. Required, but is supplied by derived classes. (Inherited from OrganizationRequest)
RequestId	Gets or sets the ID of the request. Optional. (Inherited from OrganizationRequest)
RequestName	Gets or sets the name of the request. Required, but is supplied by derived classes. (Inherited from OrganizationRequest)
SolutionUniqueName	Gets or sets the name of the solution you want to add the changes to. Optional.
Values	Gets or sets the array of option values in the wanted order. Required.