- Posts: 8
- Thank you received: 0
My Table View called "votes" has a "count"
SELECT `FieldValue`, count(*)
FROM `ottb5_rsform_submission_values` WHERE `FieldName`='vote'
GROUP BY `FieldValue` ORDER BY count(*) DESC;
Displays in PHPmyAdmin fine, but when i create a tools jx grid, it will not let me display the count(*) column This is the key piece I need, how can i get it to work?
Thank you.
Please Log in or Create an account to join the conversation.
Hi,
try giving count(*) a name. And do not use order in view definition. You can handle order by later on at select (with Table JX)
SELECT `FieldValue`, count(*) as CountValue
FROM `ottb5_rsform_submission_values` WHERE `FieldName`='vote'
GROUP BY `FieldValue`
Please Log in or Create an account to join the conversation.
This is all working now, thanks!!
Please Log in or Create an account to join the conversation.