Alphabetize Selections under "Access Needed" on a Request

DeIvory Gordon · ‎10-23-2024

Hello, I updated a form titled "Who On Location Access Request". See screen shot below, under "Access Needed" I added two new locations " Who On Location-Australia/New Zealand - Heathwood AU" and "Who On Location-Australia/New Zealand - Malaga AU". As you can see there are five locations and I want to put them in alphabetical order. The "Who On Location Access Request" is an order guide, I clicked on the "Rule Based" tab and added the two additional locations by creating a catalog item for each one.

I don't understand why I cannot order the locations under "Access Needed" the same way I order question choices under variables. Do you know how to order the locations? Thanks!

Brad Bowman · ‎10-23-2024

I'm trying a mockup in my PDI, and the records are always listed alphabetically by the Display field (Name). I don't know if you can change the order other than maybe changing the qualifier to call a Script Include that does the same filtering, then adds the sys_ids to an array in the order you want, but even that might get overwritten.

D'OH - looking at your first screenshot again, I see that they actually ARE in alphabetical order with the two Catalog Items named ...AAustralia... coming before those named ...Australia...

View solution in original post

Brad Bowman · ‎10-23-2024

You need to look at the Access Needed variable on the Order Guide Setup. Is it a lookup select box or what type of variable?

DeIvory Gordon · ‎10-23-2024

Hello, Please see the screen shot below, it's a list collector.

Brad Bowman · ‎10-23-2024

Got it. What is the List table and Reference qualifier? If it is calling a Script Include, what does that look like?

DeIvory Gordon · ‎10-23-2024