Order By clause on Chart
Posted: Thu Jan 30, 2020 5:12 pm
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
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