Geek Answers Handbook

DQL query to return all files to the cabinet in Documentum?

I want to get all the files from the cabinet ("Wombat Insurance Co"). I am currently using this DQL query:

select r_object_id, object_name from dm_document(all) 
where folder('/Wombat Insurance Co', descend);

This is normal, but only returns no more than 100 results. If there are 5,000 files in the case, I want to get all 5,000 results. Is there a way to use pagination to get all the results?

I tried this query:

select r_object_id, object_name from dm_document(all) 
where folder('/Wombat Insurance Co', descend) 
ENABLE (RETURN_RANGE 0 100 'r_object_id DESC');

in order to get results in increments of 100 files, but this request gives me an error when trying to execute it. The error says this:

com.emc.documentum.fs.services.core.CoreServiceException: "QUERY" action failed.

java.lang.Exception: [DM_QUERY2_E_UNRECOGNIZED_HINT]error:  
"RETURN_RANGE is an unknown hint or is being used incorrectly."

I think I'm using the RETURN_RANGE hint correctly, but maybe not. Any help would be appreciated!

I also tried using a hint ENABLE(FETCH_ALL_RESULTS 0), but this still returns a maximum of 100 results.

, : ?

+4
4
, . DFS Java ( DFC), :
String queryStr = "select r_object_id, object_name from dm_document(all) 
                   where folder('/Wombat Insurance Co', descend);"

PassthroughQuery query = new PassthroughQuery();
query.setQueryString(queryStr);
query.addRepository(repositoryStr);

QueryExecution queryEx = new QueryExecution();
queryEx.setCacheStrategyType(CacheStrategyType.DEFAULT_CACHE_STRATEGY);
queryEx.setStartingIndex(currentIndex);      // set start index here

OperationOptions operationOptions = null;

// will return 100 results starting from currentIndex
QueryResult queryResult = queryService.execute(query, queryEx, operationOptions);

currentIndex, .

+2

, . 1, 0.

DQL . . , 100 , - , DFC ( ). IDfCollection :

IDfQuery query = new DfQuery("SELECT r_object_id, object_name "
        + "FROM dm_document(all) WHERE FOLDER('/System', DESCEND)");
IDfCollection coll = query.execute(session, IDfQuery.DF_READ_QUERY);
int i = 0;
while (coll.next()) i++;
System.out.println("Number of results: " + i);

(CS 6.7 SP1 x64, MS SQL) :

: 37162

. - , . , 1:

ENABLE(RETURN_RANGE 1 100 'r_object_id DESC')

, , DQL. , , 100 , :

ENABLE(RETURN_TOP 100)

ORDER BY , .

, , () , , . , .

+2

, DFS.

DFC, .

:

DFS, , DFS. , 100 150.

DFC:

, DFC ( DFS).

DFC (webtop da - ) dfc.properties.

# Maximum number of results to retrieve by a query search.                      
# min value:  1, max value: 10000000
# 
dfc.search.max_results = 100

# Maximum number of results to retrieve per source by a query search.           
# min value:  1, max value: 10000000
# 
dfc.search.max_results_per_source = 400

dfc.properties.full , .

ContentServer, dfc.properties .

ENABLE (RETURN_TOP) DFC, ContentServer.

, return_top_results_row_based server.ini.

Documentum, DFC/DQL.

+2
source

I worked with the DFC API (with Java) for a while, but I don’t remember the default restriction on requests, IIRC always had all the documents, there were no restrictions. In fact (according to my notes), we must set a limit clearly, for example enable (return_top 2000). (As far as I know, the syntax may depend on the DBMS for EMC Documentum.)

Just guess: check the file dfc.properties.

0
source

More articles:


All Articles