Documentum FT DQL
How to get full text DQL working with only wildcards like -
SELECT r_object_id,score,text,r_version_label,object_name,r_object_type,a_content_type,a_application_type,r_is_virtual_doc,r_link_cnt,r_lock_owner,r_policy_id,r_assembled_from_id,r_immutable_flag,r_frozen_flag,i_is_reference,title,a_status,r_modify_date,r_modifier FROM edas_document(all) WHERE (object_name LIKE '%%') ENABLE(FTDQL, ft_contain_fragment)
The above query fails if there is no keywords between the Like '%%'. Is there a way to get this working without the keywords between like '%%'.
Best Answer
Answers
-
Maybe I'm not understanding your question, but it sounds like your query is failing if the user does not provide a value for object_name to search against. If that's the case, why dont you just check for the existence of a value before you run your DQL. If the user doesnt provide search value, then either prompt them for a value or run your query without search criterion.
0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management