Sorting of portal variable in descending order using variable attribute

[Saraswathi Devi]

Hi ,

I have a Reference Variable which should show the data in descending order while filling a request form through portal.

I have tried the below code in the variable attribute.

1) ref_ac_order_by = number

2) ref_sequence = sys_created_on

3) ref_ac_order_by_desc = number

But nothing helped. Can anyone help me with this issue.

[Ankur Bawiskar]

@Saraswathi Devi 

try to use query BR on that table but it would impact other places in instance as well

[Saraswathi Devi]

Hi @Ankur Bawiskar 

If we write the Query Business rule, does it will reflect in the portal?

Cause we want to display the numbers in descending order before submitting the request from the portal.

[Ankur Bawiskar · Accepted solution]

@Saraswathi Devi 

yes it will work not only in portal but entire instance wherever this table is being referred in reference field or glide list etc