Search multiple values in text field

Applications Grid / Reports
#1

greetings all,

Is there a way to search multiple values in grid text field ?

i.e. search across the table for or A & B in text field ABTEXT.

cheers

#2

Re: Search multiple values in text field

Here is a post about creating a custom search:
http://www.scriptcase.net/forum_en_us/index.php?topic=1483.0

You can make changes and define how your search will work base on your criteria using any SQL commands.

Regards,
Scott.

#3

Re: Search multiple values in text field

Hi Scott

This code works if you have multiple fields ! no ?

What about multiple values in single field ?

cheers

#4

Re: Search multiple values in text field

The point of my post is that you can create a custom SQL function to perform any type of search that you need. You will have to research the SQL engine that you use to create the search the you want.

Try looking at the function find_in_set() or similar.

Regards,
Scott.