Hello,
I have a question. What is the best way to do a sort of "select count" from ondemand?
Backstory: we want to know how many of a certain type of document we have in a folder. We have a folder, lets call it LETTERS, with about 25.000.000 documents. we want to know how many type 1 and how many type 2 documents are in that folder.
What I have tried so far:
I have tried using the ARSDOC QUERY command to do this, se example below, but is there a better way to do this?
command i have used:
arsdoc query -v -h <SERVER> -u <USER> -p <PASSWORD> -f "<FOLDER NAME WITH SPACES>" -i "where id LIKE '%' and type= 'one'" | wc -1
Any hints or tips would be greatly appreciated.
Regards,
Johan Dahlgren