Christian_Boeck_57

sorting method in static VARA objects

Discussion created by Christian_Boeck_57 on Nov 28, 2017
There are some tickets where customers wanted to know how the sorting method for VARA objects work and if there is any pssibility to change the sorting order.

The only way you can change the sorting is descending or ascending in the attributes tab of the VARA object:
jfg1q50s8r3l.png

On DB side we execute the following selects, depending if it is asc or desc:

SELECT * FROM OVW WHERE OVW_OH_Idnr = ? ORDER BY OVW_VValue DESC SELECT * FROM OVW WHERE OVW_OH_Idnr = ? ORDER BY OVW_VValue ASC

Outcomes