FTDQL does not work on one document type

Lakshminarayanan

Hello All -

We need to gather some statistics based on 2 FTDQL results.

The following query works on one document type and returns required results

select  r_object_id, object_name,authors,owner_name, a_status ,title,r_version_label,TEXT 
from xx_document(all) SEARCH  DOCUMENT  CONTAINS 'string1 string2'   enable (FTDQL)

but the same does not return any results (and no error too) when I run it on another document type (say yy_document).

Both the document types reside in the same repository. I run both the DQLs with  superuser account

Both the document types are indexed an full text searchable (returns results from D2).

Also tried explicitly using FTindex name, still no luck

select  r_object_id, object_name,authors,owner_name, a_status ,title,r_version_label,TEXT 
from yy_document(all) SEARCH  DOCUMENT  CONTAINS 'string1 string2' IN FTINDEX 'xyz_ftindex_01'  enable (FTDQL)

IN FTINDEX

Any suggestions on why the 2nd document type does not return any results with FTDQL would be appreciated!

Best Regards

christopher.imes

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility.  Questions written to the users' own "Discussions" space don't get the same amount of attention and can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right.  Then search for and select: "Documentum Support Forum".

For further guidance on engaging with the communities for Documentum and related products, please refer to the IIG Communities Getting Started Guide.