OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » apex full text custom search

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

apex full text custom search [message #592754]

Mon, 12 August 2013 02:27

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: apex full text custom search [message #593510 is a reply to message #593492]

Sat, 17 August 2013 14:29

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.

Report message to a moderator

Previous Topic:	apex.oracle.com Few page types missing in new sample app
Next Topic:	APEX workspace import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 12:54:48 CST 2024