Order the data in a drop down control type variable

Hello,

In my runbook process i use a prompted variable who happens to be a Drop down control type.
I would like to order these data in certain way. In fact my strings contain date and i want a date order as descending.

Drop down is filled with :
EXP_XXX_030621_0145_remap.dmp.gz|EXP_XXX_030621_0145_remap.dmp.gz
EXP_XXX_020621_0145_remap.dmp.gz|EXP_XXX_020621_0145_remap.dmp.gz
EXP_XXX_010621_0145_remap.dmp.gz|EXP_XXX_010621_0145_remap.dmp.gz
EXP_XXX_310521_0145_remap.dmp.gz|EXP_XXX_310521_0145_remap.dmp.gz
EXP_XXX_280521_0145_remap.dmp.gz|EXP_XXX_280521_0145_remap.dmp.gz
EXP_XXX_060521_0145_remap.dmp.gz|EXP_XXX_060521_0145_remap.dmp.gz
EXP_XXX_030521_0145_remap.dmp.gz|EXP_XXX_030521_0145_remap.dmp.gz
EXP_XXX_110321_0145_remap.dmp.gz|EXP_XXX_110321_0145_remap.dmp.gz
EXP_XXX_020321_0145_remap.dmp.gz|EXP_XXX_020321_0145_remap.dmp.gz
EXP_XXX_160221_0145_remap.dmp.gz|EXP_XXX_160221_0145_remap.dmp.gz

When the prompted variable is triggered in Octopus portal, drop show data reordered :
EXP_XXX_010621_0145_remap.dmp.gz|EXP_XXX_010621_0145_remap.dmp.gz
EXP_XXX_020321_0145_remap.dmp.gz|EXP_XXX_020321_0145_remap.dmp.gz
EXP_XXX_020621_0145_remap.dmp.gz|EXP_XXX_020621_0145_remap.dmp.gz
EXP_XXX_030521_0145_remap.dmp.gz|EXP_XXX_030521_0145_remap.dmp.gz
EXP_XXX_030621_0145_remap.dmp.gz|EXP_XXX_030621_0145_remap.dmp.gz
EXP_XXX_060521_0145_remap.dmp.gz|EXP_XXX_060521_0145_remap.dmp.gz
EXP_XXX_110321_0145_remap.dmp.gz|EXP_XXX_110321_0145_remap.dmp.gz
EXP_XXX_160221_0145_remap.dmp.gz|EXP_XXX_160221_0145_remap.dmp.gz
EXP_XXX_280521_0145_remap.dmp.gz|EXP_XXX_280521_0145_remap.dmp.gz
EXP_XXX_310521_0145_remap.dmp.gz|EXP_XXX_310521_0145_remap.dmp.gz

A sort seems to be done in portal application. How would it be possible to dictate an order for the display of data ?

Hi @FMM

Unfortunately, it’s not possible to add a sort order to the Drop down control type.

The sort order is determined by the items in the list, specifically from my testing it looks like the Display values are alphabetically sorted. See my example below:

The only way to dictate an order that I can see would be to introduce an alphabetic sort in your display value.

Best regards,
Mark

That’s what i dreaded, anyway thank you.