As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
Hi All,
Is there a possible way to get all data using the CMIS Workbench QUERY?
based on my testing I've just get only 100 data instead of 100,000+ data in our production.
How?
Thanks,
Cyrus Nhiel
any ideas?
Simple answer is: NO
Alternatives: https://angelborroy.wordpress.com/2018/05/30/alfresco-counting-more-than-1000-elements/
Angel Borroy Hi borry I've already found a solution for this and I've gather more than 100,000 data from my query. Thanks for the response
And can you share your findings with us?
Angel Borroy Sure, First before entering the WORKBENCH , in the url http://localhost:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom?maxItems=100000 add the maxItems you want , then in the groovy script
just add
String cql = "SELECT * FROM cmis:document"
OperationContext opCon = session.createOperationContext();opCon.setLoadSecondaryTypeProperties(true);opCon.setMaxItemsPerPage(100000);
ItemIterable<QueryResult> results = session.query(cql, false, opCon)
Then u can get the data you want
No more configurations?
This does not work for me.