I need a way to get the first value in a filter to be selected. The value will be a standard sort in asc, however, in my case the field sits in a fact table. The value can be any text.
The only way i can see this being done is to create a load of the field list in the script and load that in ascending order. Do this part at the beginning of the script snd then drop the table used.
I can then use a trigger to select the field, however, I need to do a firstsortedvalue with the sort order being the load.
