At 07:31 PM 10/31/2015, Manuel de Aguiar wrote:
Is there a way to capture the user selected sort order? The user
is able to change the sort order by clicking on the colums' header.
I need to capture it so the generated report can have the user's
selected sort order. I thank you for any help you may give.
Manuel,
Yes, there is a way to capture the user selected sort order.
For Variable Lookup ListView control, you can use the "CURRENTSORT"
property to capture the current sort.
Here's how:
01. Assign a component ID to Variable Lookup ListView control,
such as "VarLookupListView".
02. Make sure that the user is allowed to sort the column
Variable Lookup ListView Control > Properties ...
[x] Column Sort
03. Place a button control to get the property of current sort
Use the following command as "On-Click EEP":
SET VAR vCurrentSort TEXT = NULL
GETPROPERTY VarLookupListView CURRENTSORT 'vCurrentSort'
RECALC VARIABLES
RETURN
You may also use the same code prior to printing the report.
Resulting variable "vCurrentSort" will return the currently
clicked column name and the sort order, such as:
columnname ASC
columnname DESC
For example:
If the column CustID header was clicked once, the resulting
variable would be:
CustID ASC
If the column CustID header was clicked again, the resulting
variable would be:
CustID DESC
That's all there is to it!
Feel free to reach out to me if you need a sample form that illustrates
the use of such feature.
Very Best R:egards,
Razzak.
