Skip to main content

Hello,

Is there a possibility of doing a "Google Search" type text search when reading? So who looks for all the words written in the filter and not just a simple "like" with the complet string.


Thank you,


Sam

Hello,

Is there a possibility of doing a "Google Search" type text search when reading? So who looks for all the words written in the filter and not just a simple "like" with the complet string.


Thank you,


Sam

Hi Sam,

As in - "I have a field with text in it, and I'd like to search for match(es) in the db?"

Is this a CLOB - or a VC200 (or similar)?

Is there any upper/lower/mixed case requirements?

Regards,

Knut

Hello,

Is there a possibility of doing a "Google Search" type text search when reading? So who looks for all the words written in the filter and not just a simple "like" with the complet string.


Thank you,


Sam

Hi Sam

Should this search happen interactive?
I.e. the user inputs a text-line with the words to search for and then press a button "search" (or on leave field&Co)
In this case, it is possible to create a u_condition with the wanted words

;°* is GOLD-*

v_COND = ""
v_COND =$concat(v_COND," |  TXT_FLD=%%"°*",v_WORD1,"°*%%"")
v_COND =$concat(v_COND," |  TXT_FLD=%%"°*",v_WORD2,"°*%%"")
....

v_COND = v_COND[3]
read u_condition(v_COND)


Or you can create a SQL-statement with this information

v_SQL = ""
v_SQL =$concat(v_SQL," OR  TXT_FLD LIKE '%",v_WORD1,"%'")
v_SQL =$concat(v_SQL," OR  TXT_FLD LIKE '%",v_WORD2,"%'")
v_SQL = v_SQL[5]
sql\\data v_SQL,v_DATA

Ingo

Terms & ConditionsAccessibility statement