AnsweredAssumed Answered

alternative to simple execute SQL

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


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..