AnsweredAssumed Answered

alternative to simple execute SQL

Question asked by malachydevlin on Jan 20, 2016
Latest reply on Jan 20, 2016 by malachydevlin

Hi,

i have a customers table and i want to display a total count of all this customers projects that are "open".

so a execute sql works well as it lets me specify a criteria for the projects.

e.g select count(id) from projects where status='open' and customer_id=?thiscustomer.

 

However i wondered is there a FM function that achieves the same thing, without making relationships etc.

 

The only reason i ask is that i like to avoid execute sql if its easy to do so for the only reason that if field names change then its hard to remember to change it everywhere..

 

thanks

Outcomes