Ordering on 2nd Lookup select box not working (Service Portal error only)

[Deborah Hill]

Hi

I have a portal page that the user makes a choice of country on the Describe Needs page and this is cascaded through to Choose Options and successfully limits options in Lookup select box 1. This lookup is also in the correct order.

There is a 2nd Lookup select box on the Choose Options page which is successfully limited by the choice in box 1 BUT this box does not display results in the correct order.

I've checked the SQL. The order is done by ref qual including + '^ORDERBYorder'; and Var attributes including ref_ac_order_by=order (I've checked the table definition that it is order not u_order). Additionally if I replace order with something else to order by that does not work either. It is always ordered by name.

Anyone any ideas? Or is there a PRB open for this?

[EDIT] Also it's worth noting that if I do the order guide within the platform the order on my second variable is correct.

[EDIT2] Attached the full explanation and screenshots from my PDI (see docx) showing the order working on platform view but not in portal view. I have approached our instance admin to open a HI Ticket. Will update if this is raised and any fixes.

thanks

Debbie

[Deborah Hill]

I decided to spend a bit of time recreating this in my PDI and in doing so I noticed that the error only occurs when viewing in the portal page but is working fine in the platform view of the order guide (I amended my question to reflect this). This also means I can share better screenshots.