Sorting the result of the List() function

[MorFologist]

The result of List(field) comes out in record creation order.

Is there any trick to control that?

I'm populating a single calculated text field in the main file with a list of field data from a 'many' relationship (thru a join table), and would like to allow the user to control the sort order of the result by modifying a field within the table the list is pulled from.

Looking into "create a value list based on values of the field in question, make it a conditional value list based on the relationship ID... then use ValueListItems() to return only the unique values. Works best in a script."

That worked.

As the target field to make a list from was a calculated text block, itself with a list from yet another field, : , I had to replace all ¶ with # so I could sort the field as a single item, then subbed them back after using VLI().

Edited August 29, 2010 by Guest
Solved.

[Raybaudi]

The result of List(field) comes out in record creation order.

This is true only if the relationship isn't sorted.

[MorFologist]

LOL! Your English was perfect. Where were you an hour ago? (and why did I not think to try that). Thanks!

I still needed to sub out the ¶ for # to maintain my text blocks, so not truly a waste of time.

[Raybaudi]

There is even to say that the relationship's sort could be modified programmatically by changing the value of a summary field and sorting that relationship by the summary field.

Sort_the_rel.zip

[comment]

Any difference?

NoSummary.zip

[Raybaudi]

What did you aspect from a ChindoguMaker ? :

[comment]

:funnypost: