Hello
We would like to sort with multiple columns in our grid.
Is this possible?
Thanks
Multiple sort in database.
-
- Profound User
- Posts: 49
- Joined: Wed Jan 08, 2014 11:49 am
- First Name: Michael
- Last Name: Pilote
- Company Name: Oceanex
- Phone: (514) 875-8558
- State / Province: Quebec
- Country: Canada
- Contact:
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Multiple sort in database.
The grid widget has a property called "column sort response". You can use this to send control to your RPG program when the user clicks a column at the top. You can then load the subfile in any sort sequence you desire.
Will that work for you?
Will that work for you?
-
- Profound User
- Posts: 49
- Joined: Wed Jan 08, 2014 11:49 am
- First Name: Michael
- Last Name: Pilote
- Company Name: Oceanex
- Phone: (514) 875-8558
- State / Province: Quebec
- Country: Canada
- Contact:
Re: Multiple sort in database.
That was our backup solution, we just were wondering if this would be a feature that would be possible in version 5. We wouldn't have to change anything in our code if it were the case. However, if this isn't the case we will just manage it server side.
Thanks for the answer.
Thanks for the answer.
-
- Profound User
- Posts: 49
- Joined: Wed Jan 08, 2014 11:49 am
- First Name: Michael
- Last Name: Pilote
- Company Name: Oceanex
- Phone: (514) 875-8558
- State / Province: Quebec
- Country: Canada
- Contact:
Re: Multiple sort in database.
I just tried to use the sort response indicator, however i've noticed that the column number that is sent back to RPG is the number after the column has been moved. How am i to know in my RPG code by which column to sort if the user has already moved the columns around on me?
-
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Multiple sort in database.
This sounds like a bug... I would expect the column sort response to be the original column number. Please file this as a bug with our support team (support@profoundlogic.com)
-
- Profound User
- Posts: 49
- Joined: Wed Jan 08, 2014 11:49 am
- First Name: Michael
- Last Name: Pilote
- Company Name: Oceanex
- Phone: (514) 875-8558
- State / Province: Quebec
- Country: Canada
- Contact:
Re: Multiple sort in database.
Ok Thanks Scott, I Sent them an email Thanks for your help!
Who is online
Users browsing this forum: No registered users and 7 guests