In a test environment (CS 6.7 SP1 圆4, MS SQL), this outputs: IDfCollection coll = query.execute(session, IDfQuery.DF_READ_QUERY) + 'FROM dm_document(all) WHERE FOLDER('/System', DESCEND)') Using IDfCollection in the following way will surely return everything: IDfQuery query = new DfQuery('SELECT r_object_id, object_name ' The reason you get only 100 results must have something to do with the way you're using DFC (or whichever other client you are using). There is no built-in limit in DQL itself. Well, the hint is being used incorrectly. You have to configure this by using the parameter return_top_results_row_based in the server.ini file.Īll of these changes for the documentum server side, not for your DFC/DQL client. If you use ENABLE (RETURN_TOP) hint with DFC, there are 2 ways to fetch the results from the ContentServer. # Maximum number of results to retrieve per source by a query search.ĭfc.properties.full or similar file is there and you can verify these values according to your system.Īnd I'm talking about the ContentServer side, not the client side dfc.properties file. # Maximum number of results to retrieve by a query search. Go to your DFC application(webtop or da or anything) and check the dfc.properties file. If you are using DFS, you have to aware about the number of concurrent sessions that you can consume with DFS.Īctually there is a limit that you can fetch via DFC (I'm not sure with DFS). Since your are playing with DFC, these information might help you. You have already accepted an answer which is using DFS. To clarify, my question is: how can I get all the files from a cabinet? I have also tried using the hint ENABLE(FETCH_ALL_RESULTS 0) but this still only returns a maximum of 100 results. I think I am using the RETURN_RANGE hint correctly, but maybe I'm not. 'RETURN_RANGE is an unknown hint or is being used incorrectly.' The error says this: .: 'QUERY' action failed. With the intention of getting results in 100 file increments, but this query gives me an error when I try to execute it. Where folder('/Wombat Insurance Co', descend)ĮNABLE (RETURN_RANGE 0 100 'r_object_id DESC') I have tried this query: select r_object_id, object_name from dm_document(all) Is there a way to use pagination to get all the results? If there are 5000 files in the cabinet I want to get all 5000 results. This is ok except it only returns a maximum of 100 results.

Where folder('/Wombat Insurance Co', descend) Currently I am using this DQL query: select r_object_id, object_name from dm_document(all) I want to retrieve all the files from a cabinet (called 'Wombat Insurance Co').

Q connect document folder