Google like search with CE_function

[former_member290321]

I want to use fuzzy search in scripted calculation view (ce_function)

I have created a attributed view and have added fuzzy search on "A", "B".

I have one input parameter in my calculation view.

I want to use those fields in my search in calculation view.

ce_view = CE_JOIN_VIEW("_SYS_BIC"."ATTRIBUTE_VIEW_NAME", [ "A", "B" ]) 
out = CE_PROJECTION( :ce_view,  [ "A", "B", 0 AS "C" ],  'CONTAINS("A",:v_par) OR CONTAINS("B",:v_par)');

I am getting syntax error.

Please help...

Message was edited by: Tom Flanagan

[Former Member · Accepted solution]

Just write this in SQL. CE Functions don't help you here. Here is an interesting thread if you are desperate to use them.

[former_member290321 · Accepted solution]

I am already using SQL Script but i have performance issues... I want to try CE_Funiction may be i can get better performance. Right now I am getting result set in 2 sec, I want to bring it down below 1 sec mark.

[Former Member · Accepted solution]

That won't help you, you need to look elsewhere for a performance improvement.