This function allows, from a formula, to obtain the number of documents of any Docuo category. It is not necessary that the category indicated is related to the one that contains the formula.
The categoryCount function is only available in Docuo Enterprise.
For example, if we have a category of countries (PAI – Country) and we want to count them from any formula, we must use this function:
Where:
Category : is the code, the name or the code – name of the category from which we want to extract the data:
Condition : This is an optional parameter with a T-SQL condition text string of the same type used in dropdown lists. It allows us to filter the documents. For example, to filter Countries in Europe or Asia:
Finally, the final formula would look like:
The function would return the total number of countries in Europe and Asia.