Multiple sort in database.

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
mpilo0
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:

Multiple sort in database.

Post by mpilo0 »

Hello
We would like to sort with multiple columns in our grid.

Is this possible?

Thanks
Scott Klement
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.

Post 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?
mpilo0
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.

Post 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.
mpilo0
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.

Post 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?
Scott Klement
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.

Post 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)
mpilo0
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.

Post by mpilo0 »

Ok Thanks Scott, I Sent them an email Thanks for your help!
Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests