6 Replies Latest reply: Jun 8, 2012 12:44 PM by Rob Wunderlich RSS

    Macro to loop on a field order by another field

      Hello,

       

      I need to do a macro which loop on a list on field value in a certain order as example below:

       

      MyFieldMySortField
      A1gA1
      fefz2
      adfgh3
      1sdz4


      I want to select in the order of MySortField the value in the field MyField.

       

      Is it possible to do in macro with getPossibleValues with others functions without use a list box?

       

      If not, how can I do the same thing in looping on a list box object containing field Value of MyField order by MysortField ? What macro function use to do this in using directly this graphic object.

       

      In the second case, I have seen a little problem : sort by expression in my list box don't work on "gray" value (exclude of possible values list). they are all at the end of the available values which are correctly sorted.

       

      Could you help me?

       

      Thanks.