Formatting of Current Selections

[#1]

Please see attached. Using a trigger on document open, I'm selecting all the (completed) months to date. The problem is how it appears in the Current Selections box. The parentheses-contained, pipe-delimited, alphabetized list doesn't look as clean as the default.

To be specific, when the document opens, I see this in Current Selections:

MonthName: (Apr|Aug|Feb|Jan|Jul|Jun|Mar|May|Sep)

I'd like to see the default that appears when I select those months manually -- that is, a chronological, comma-separated list (with or without NOT consistent with the default behavior).

If I'm stuck with that formatting, I'd like to at least see the months in chronological order.

Thanks.

[antoniotiman]

Hi Brian,

in your action in open, in expression Concat add MonthNo after '|'

Concat(......... distinct MonthName,'|',MonthNo)

MonthNo in Concat is field sort

Regards,

Antonio

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#4]

Two good answers. Thank you both.

[mikecrengland]

You actually solved a problem that I was struggling with! I wanted to use a variable to select less than some amount in one of my fields and used your suggestion to do it on the variable update...  ='<'&$(vFinalMPH)

I tried just about everything except what you suggested... Thanks!

mike

[brian554xx]

This is magnificent. Thank you!

Thought I would suggest my preferred sort order:

• State Ascending (not auto ascending)
• Expression Only({1} MonthNo)