Order By clause on Chart

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Order By clause on Chart

Post by Wendy »

I have a database driven chart that is counting the occurrences of problems for a machine ID. I only want the top 10 machines with highest incident number. I could use, and have used, a custom SQL so the Order By property is utilized. However, why won't the order by property, which is available on a database driven chart, override the default order by for that chart?

Widget Type = chart
database file = MNCSTWRK
name field=MNREF
value field=MNWO
summary option = count
record limit = 10
order by = count(MNWO) desc

If the 'order by' property is not going to be used, it shouldn't be available.

The sql in the PUISSNVP file looks like this: SELECT MNREF, count(MNWO) FROM MNCSTWRK GROUP BY MNREF ORDER BY MNREF

Thank you!
Wendy
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: Order By clause on Chart

Post by Scott Klement »

If you suspect that there's a bug in Profound UI, then please report it as a bug to Profound Logic. You can do that by e-mailing support@profoundlogic.com
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Re: Order By clause on Chart

Post by Wendy »

I actually didn't really think about it being a bug. I just thought it wasn't intended to work. But thank you so much, I will report it.

Wendy
Wendy
Profound User
Posts: 37
Joined: Mon Aug 06, 2018 4:00 pm
First Name: Wendy
Last Name: Sauers
Company Name: Conestoga Wood Specialties
Phone: 5706589663
Address 1: 441 West Market St.
City: Beavertown
State / Province: Pennsylvania
Zip / Postal Code: 17812
Country: United States
Contact:

Re: Order By clause on Chart

Post by Wendy »

Just to follow up for people reviewing this post.....

Profound support said this:
Thank you for your patience with this support ticket. Looking into this further, it seems that the behavior that you are experiencing with your chart is expected. When using the 'summary option' property with your database-driven grid, the 'order by' property will be ignored. In this case, the grid will automatically sort on the 'name field' property. So, if you want to use the 'order by' property for your database-driven chart, you will need to remove the 'summary option' property, first.

I then asked for a request for enhancement so that the summary options would work in the order by clause.

Regards,
Wendy
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests