how work fulltext search
My query search is :
SELECT cust_field1, cust_field_2, cust_field_2 FROM custom_object SEARCH DOCUMENT CONTAINS 'abrakadabra' enable (RETURN_RANGE 1 101 , object_BASED)
return exception:
[DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor ('ORA-00933: SQL command not properly ended')
Does fulltext search work with hint RETURN_RANGE?
Comments
-
Hi,
For that old style way (FTDQL), CS gets that FTDQL query and transforms it to xQuery, then sends xQuery to xPlore. Then it receives response from xPlore and loads it to temp db table, then CS returns records from that temp table to client. Not sure at which stage RETURN_RANGE involved. To find out it, I would suggest looking at dsearch.log to find xquery executed on xPlore, also enable DQL+SQL trace on Content Server to find what sql query failed.
Does it work without RETURN_RANGE hint?MEOW
0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 Services
- 40 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 901 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 127 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax