Question about full text search

I am working on a project to integrate our product with documentum. The documentum we are using is version 6.5. I am using the .NET productivity layer of the DFS sdk 6.5 for my development. I have a question about the full text search functionality. I have a DQL query like the following:

select r_object_id, object_name from dm_document search document contains 'searchword' where folder('/cabinet1');

This query does not work because it does not return any document even though there are documents in that folder that matches the search word. But if I remove the WHERE condition, it searchs the whole repository and returns the correct results. My question is, how do I use full text search to search only a certain cabinet or folder instead of the whole repository? Is my DQL query correct? (Look like it is not since it does not return the correct results). If not, how should I write the DQL query? Thanks a lot.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

bacham2

Your query is correct but it will only return documents which are directly in the cabinet. It won't return documents which are in sub-folders of the cabinet. If that's what you want, you need to add the DESCEND clause:

where folder('/cabinet1', descend)

All comments

bacham2

where folder('/cabinet1', descend)

Developer01

Thank you very much. Just figured this out too. You are right. The document I am expecting is in a sub folder of that cabinet. It worked with the "descend" keyword. Thanks.

DCTM_Guru

Are you sure that your user acct has READ permissions on documents located cabinet/folder path?

To verify DQL syntax (and search results), I would run the query from within Documentum Administrator

Developer01

Thank you, Johnny. I do have 'READ' permission on the cabinet. The problem is that I didn't use the "descend' keyword. I was searching in that cabinet recursively. But I didn't use the 'descend' key word' So it didn't search any subfolders. That is why I didn't get the results I expected. Thank you for your help.