Reference Field : How to sort the results in descending order using reference qualifier?

[kutvaram]

Hi All,

I have a variable of reference field type with simple condition in it.

I need to sort the results by a column in descending order.

I used variable attributes section where ref_ac_order_by=columnname.

This is doing ascending order sorting.

How to do it descending order sorting by a column name?

I have referred many community links and also got to know , have to write query business rule. But I am not happy with that.

Kindly advise using variable attributes sorting by descending or a better way.

Thanks,

Ram Prakash K R

[Thom8]

To my knowledge, it is only achievable with the query business rule... 😕

[kutvaram]

Hi Thom,

If I write the query business rule, it will affect the results wherever that table has been referenced.

Am I correct?

Thanks,

Ram Prakash K R

[Thom8]

Yep, you are correct.

[Ankur Bawiskar]

Hi,

Sorting the list with ascending or descending is based on User preference

Reference qualifier don't support sorting.

Regards
Ankur