SELECT COUNT() possible?

[AndrewCHughes]

Is it possible to use COUNT(some_column) in the select field of a table query? I am unable to get it to work. Is there some other way to get a count of results without having to return all the results and count them?

Andrew

[GoCubbies]

You can use the SELECT COUNT in a calculated field in reports or details pages, but sub-queries are not allowed in formula fields (table based calculations).  What is the overall workflow you are looking to achieve and maybe I can help guide you to some other solutions?

Take a look at these links for some additional information as well:
https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

 

[AndrewCHughes]

I was asking about it's use in the REST API as part of a select criteria in a table query: https://howto.caspio.com/web-services-api/rest-api/older-rest-api-versions/criteria/

[Vitalikssssss]

Hi @AndrewCHughes,

It is possible to specify COUNT function in REST API query which will return a count of matched records.

Here is a simple example:

Hope this helps.

Regards,

vitalikssssss

[AndrewCHughes]

Thanks. Yeah, that's what I was trying, but I'm getting an error. 

[Vitalikssssss]

@AndrewCHughes,

Can you show me your query expression? 

Does this issue appear on any table?

 

 

[BaySunshine]

Hi @AndrewCHughes,

The query provided by @Vitalikssssss works when a integer field . For example, ID=5. No need of adding quotes on either side.  What were you using for your where condition?

Regards,