Hello,
The select dql query reslut is having more than 2000 objects count.if i am trying to print that value using dfs code snippet it's giving only 100 objects are printing.
In the below code i can able to print only 100 object information,the remaining value is not printing.I have tried diffrent query CacheStrategyType too.
Give me some sugesstion to solve the issue.query.setQueryString(
"select distinct s.r_object_id as docid,s.object_name as docname,s.title as document_title,s.owner_name as document_owner_name,s.subject as document_subject,fr.r_object_id as folderid,fr.r_folder_path as folder_location from dm_sysobject (all) s,dm_sysobject_r sr,dm_folder_r fr where sr.i_position = -1 and sr.r_object_id = s.r_object_id and fr.r_object_id = sr.i_folder_id and fr.i_position = -1 and fr.r_folder_path like '"+ folderName + "%' order by fr.r_folder_path,s.object_name"); query.addRepository(params[0]); QueryExecution queryEx =
new QueryExecution(); queryEx.setCacheStrategyType(CacheStrategyType.
DEFAULT_CACHE_STRATEGY);
OperationOptions operationOptions =
null; QueryResult queryResult = querySvc.execute(query, queryEx, operationOptions);
DataPackage resultDp = queryResult.getDataPackage();
Iterator iterator = resultDp.getDataObjects().iterator();
PropertySet properties;
java.util.List<DataObject> dataObjects = resultDp.getDataObjects();
int numberOfObjects = dataObjects.size(); System.
out.println("Total objects returned is:" + numberOfObjects); //Here i am getting only 100 objetcs even result is having more than 100
if(numberOfObjects > 0 ) System.
out.println("Total objects returned is: " + numberOfObjects);
while(iterator.hasNext()){
DataObject thisDataObjectfd = (DataObject) iterator.next();
properties = thisDataObjectfd.getProperties();
System.
out.println("folder_location Name: " +properties.get("folder_location").getValueAsString()); System.
out.println("Object ID: " +properties.get("docid").getValueAsString()); System.
out.println("docname : " +properties.get("docname").getValueAsString()); System.
out.println("Owner_name: " +properties.get("document_owner_name").getValueAsString()); System.
out.println("title: " +properties.get("document_title").getValueAsString()); System.
out.println("Subject: " +properties.get("document_subject").getValueAsString()); }
Regards
Senthil
