We need this for sorting purposes. Some numbers like invoice numbers, file numbers or other reference numbers have both numbers and characters. Internally in database there is a unique number. In the Grid we want to hide this unique number because it is not interesting for the customer. But customer wants to sort ascending/descending according to this "unique key".
Reference numbers are composed of a current number and the year. Every year the current number starts at 1.
In the database we have the unique numbers and the reference number:
It is not possible to sort the reference number in the right chronologically way without making the unique number visible. With a message SAM_ColHeaderClick we could handle this cases programmatically. Knowing that customer clicks the column header of the (visible) reference number we could sort the grid by the (not visible) unique number.
Uwe van der Horst
- Founder/Site Admin
- Posts: 2946
- Joined: 24 Feb 2017, 09:12
- Location: Gouda, The Netherlands
Who is online
Users browsing this forum: [Ccbot] and 0 guests