Enforce Custom Sorting

[#1]

Hey,

I have to enforce custom sorting to a table how can I do it. I want the table to be always in that sort order and it is not in alphabetical order. For example, I have fields in a table 'businessA', 'businessB', 'businessC', 'businessD' and 'businessE'. Now I need to sort in order as BusinessB,D,E,A,C . I want these fileds be sorted via loadscript. I did load them via inline load like

Tablename:

Load * inline

[businessType, sortorder

'businessA', 4

businessB', 1

businessC', 5

businessD', 2

businessE', 3];

and used =only(sortorder) while sorting but this doesnot get sorted once I used the table for cyclic group. How can I do this.

Regards,

Abha

[jonathandienst]

Abha

The dual values do work - I said that Qv will consider the value to be a numeric, so you need to the sort order to numeric for them to work.

That creates a permanent sort order for the field, so you don't need hidden sort fields or sort expressions.

Regards

Jonathan