Page 1 of 1

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

Posted: Fri May 09, 2014 7:23 am
by 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


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

Posted: Fri May 09, 2014 7:47 am
by Serhii Kulibaba

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

Posted: Fri May 09, 2014 4:03 pm
by casey palmer

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


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

Posted: Fri May 09, 2014 4:38 pm
by 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);