Home » Developer & Programmer » Application Express & MOD_PLSQL » apex full text custom search
apex full text custom search [message #592754] Mon, 12 August 2013 02:27 Go to next message
anil001
Messages: 17
Registered: August 2013
Location: United States
Junior Member
I have a table which has CLOB column and I have requirement to support not just contains search but following requirements as well:

- User should be able specify AND / OR operators. For example: searching on 'Word1 OR Word2' should do search as: Where column contains Word1 or column contains Word2.
- Need to support wild characters.
- Allowing search using NEAR operator (http://docs.oracle.com/cd/B19306_01/text.102/b14218/cqoper.htm#i997808).
- Return results only when whole word matches. For example, searching on rent should not return parent.

Would a standard report work or do I need to build a custom search page. Also, do I need to use oracle text search.

Appreciate any feedback/examples on how best to handle this.

[Updated on: Mon, 12 August 2013 02:28]

Report message to a moderator

Re: apex full text custom search [message #593492 is a reply to message #592754] Sat, 17 August 2013 11:07 Go to previous messageGo to next message
Littlefoot
Messages: 19882
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, Oracle Text was my first thought. I don't know whether you can do that some other way or not (probably yes).
Re: apex full text custom search [message #593510 is a reply to message #593492] Sat, 17 August 2013 14:29 Go to previous message
anil001
Messages: 17
Registered: August 2013
Location: United States
Junior Member
Thanks Littlefoot. I was able to accomplish full text search by building Oracle Text index as described here: http://www.laureston.ca/2011/12/29/oracle-apex-and-oracle-text-integration/
and then built apex report using this pdf:
http://docs.tpu.ru/docs/oracle/apex/pdf/apex_text_application_v1.6.pdf

PDF above is from 2006, but it worked fine for me to build the report in Apex 4.1. Not sure if there is any updated document published since then or not.
Previous Topic: apex.oracle.com Few page types missing in new sample app
Next Topic: APEX workspace import
Goto Forum:
  


Current Time: Wed Dec 17 19:13:37 CST 2014

Total time taken to generate the page: 0.53008 seconds