I know I can get the number of rows from a query action
But how do I get the number of rows that are available in a query template
I have a complex query in a template action that can take several seconds. I am using pagination and need to know the number of rows that will be returned.
Currently I am performing the query twice, once in a query and later in a query template but that can take too long
I know I could amend my code to just use the query action but that means a complete rewrite so I'm hoping I can access the Template to get the number of rows
Anyone have a clue