Page 1 of 1

Multiple sort in database.

Posted: Mon Jun 09, 2014 1:37 pm
by mpilo0
Hello
We would like to sort with multiple columns in our grid.

Is this possible?

Thanks

Re: Multiple sort in database.

Posted: Mon Jun 09, 2014 3:42 pm
by Scott Klement
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?

Re: Multiple sort in database.

Posted: Tue Jun 10, 2014 7:48 am
by mpilo0
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.

Re: Multiple sort in database.

Posted: Wed Jun 11, 2014 9:01 am
by mpilo0
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?

Re: Multiple sort in database.

Posted: Wed Jun 11, 2014 4:49 pm
by Scott Klement
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)

Re: Multiple sort in database.

Posted: Thu Jun 12, 2014 11:31 am
by mpilo0
Ok Thanks Scott, I Sent them an email Thanks for your help!