How to implement a sorting the grid based on combined multiple columns

(0) Share

Report

Posted on by Siddanagouda

In form we can sort the grid records by single column. but how to achive multiple column grid sorting
we need to sort the records by multiple columns in order wise as follows
first records should sort basaed on
"Warehouse" then by site then by Location

warehouse Site Location

A AB AX

A B2 ZA

B Z A

B Z B

C AS DE

C AX DE

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

You can do that by x++ development by adding many sort fields in the form data source query.

Was this reply helpful? Yes No
Verified answer

Evaldas 1,800 on at

Like (2)

Report

Ctrl+Shift+F3 when on a grid

Go to Tab Sorting and do whatever you like

Was this reply helpful? Yes No
Siddanagouda 20 on at

Like (1)

Report

Ctrl + Shift + F3 its open "option" window. i added sorting fields in Sort Tab as mentioned. its worked fine as expected .

Thanks Evaldas

regards,
Siddanagouda

Was this reply helpful? Yes No
Ascalab 30 on at

Like (0)

Report

Is it possible to have this sorting applied by default, so that the client doesn't have to go to the options in GUI and change the sorting?

Was this reply helpful? Yes No