(private) sorry...!! contact@ecmnotes.com

Full-Text

Return all indexed documents that contain the word “”:

SELECT object_name, owner_name, r_creation_date FROM type
SEARCH DOCUMENT CONTAINS ''

Return all indexed documents that contain “” or “” or both:

SELECT object_name, owner_name, r_creation_date  FROM type
SEARCH DOCUMENT CONTAINS ''

 Return all indexed documents that contain the phrase “”:

SELECT object_name, owner_name, r_creation_date FROM type
SEARCH DOCUMENT CONTAINS '""'

Return all indexed documents that contain the word “” or the phrase “” or both:

SELECT object_name, owner_name, r_creation_date FROM type
SEARCH DOCUMENT CONTAINS ' ""'

 Return all indexed documents that contain the word “” but not “”:

SELECT object_name, owner_name, r_creation_date FROM type
SEARCH DOCUMENT CONTAINS '' AND NOT ''

Return all indexed documents that contain the word “” and are owned by ”:

SELECT object_name, subject, title, r_creation_date FROM type
SEARCH DOCUMENT CONTAINS '' WHERE owner_name = ''

Return a summary of attribute values and content from the selected objects:

SELECT SUMMARY FROM type WHERE object_name = ''

Return the list of documents in docbase which are full text indexed:

select count(*) from type where a_full_text =TRUE

Leave a Reply