Partial search on object with multiple values

[#1]

Hi all,

Please help me on the requirement...

I need to create a query filter in which user wants to search with multiple objects and with partial data for ex:- i have data like

1. This report belongs to Australia.

2. Happy christmas

3. Have a lovely day

4.Good evening chennai

5. American express

Like this  i may contain vast data,here user needs to search in the prompt as "Hap,repo. Then we need to get output as

1.Thia report belongs to Australia

2.Happy Christmas

Is this search is possible in BO or any other process to acheive the same.

Thanks,

Madhavi.G

[Former Member]

HI,

hope this would help.

The following steps should be done in SP. pass the prompt value to SP and do following steps

1. break the search srting into different different srtings (using , as the seperator)

2. store the the string parts in varibles

3.write the in where condition saying

select * from tables

table. column1 like '%var1%' or

table.column1 like '%var2%'

union

select * from tables

table. column 2 like '%var1%' or

table.column 2 like '%var2%'

... etc

- SRI