I am getting moving on learning Execute SQL in my solution, and would like to pass an array to a graph in a web viewer.
An example of the array that I am trying to create is essentially this:
Client A, 250 records (counted by sql?)
Client B, 220 records
Client C, 190 records
We would typically have something like 20 companies to track with 1000 or so records to count and assign to clients.
When I wrote the ExecuteSQL function, I used:
"SELECT COUNT ( ClientID), ClientID
FROM \"Event Records\"
WHERE \"Date of Event\" > '12/1/2017'
GROUP BY ClientID HAVING COUNT (*)>5
ORDER BY COUNT ( clientid ) ASC
" ; "" ; "" ; "")
The return data is a number of records, a comma, and the ID of the client
I'd like the list to be flipped as above. What have I missed? As always, your help is appreciated.