0

Search for a name in several fields

 Hi

 Could someone  tell me way to search for words in multiple fields (multiple columns)

Example :

in a database I have the same name "John Miles" which is in column 2, 4, 6, 8, 10

I would like them to display all five of them.

What should I do ?

Thank you

3 replies

null
    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    if you are talking about columns being those shown on a table view and you typeing in that search box at the top.

    then make sure all the coluns you want to be search are invluded in the table view

    then the the search will return records with John Miles in any of the columns

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Thanks Mel

    My question was what script should I create to find the same word in differents columns.

    And it is possible to write it in the search box at the top ?

    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    You don't need a script as long all the columns you want to search on are included in the grid then

    typing a name etc in the top search box will find them no matter what column you have the data in !

    if you have say set names that you always want to find then you could creat a new table view and pr filter it.

    Scripts etc would go onto a button/fields etc but in form view not table view!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 456Views