count the number of rows in a table that contain a specific string

[casey palmer]

is there an easy way to return the number of rows from a query that have a particular value in a column.. Ie. if I have a "status" column and have 10 rows in the table and only 5 are marked "open", how can I return a value of 5

[Serhii Kulibaba]

Hello Casey,

Look here: https://getsatisfaction.com/apperyio/...

[casey palmer]

I had just found this after I submitted the post.. will try, thank you...!!!

[casey palmer]

this worked like a charm.. Thank you for the reference and help !!!

put it in the Service Success like it said..

var count = data.length;
Appery('mOpenCritical_label').text(count);