Radicore Forum: How To » How to search all searchable fields of a table at the same time

Home » RADICORE » How To » How to search all searchable fields of a table at the same time (Concatenated fields in search screen or QuickSearch Bar)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to search all searchable fields of a table at the same time [message #3106]

Wed, 17 October 2012 14:55

jjtoranzo2004
Messages: 261
Registered: September 2012

Senior Member

Tony,

How can I have a "field" in the search screen (input field) and in the QuickSearch Bar (listed field) to search
all searchable fields of the task's table at the same time (concatenated with a space between them)?
This field is only intended for search purposes and not for display in any other screen (list, enquire, delete, etc.)
The preferable method for doing searches in it would be a regular pattern match. In most cases the desired behaviour would
be to do one of this searches:
%needle%
%needle1%needle2%

Thanks of answering the previous question, and thanks in advance for this one.

Report message to a moderator

Re: How to search all searchable fields of a table at the same time [message #3112 is a reply to message #3106]

Thu, 18 October 2012 01:54

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

The simple answer is that you can't. If you want to do such a thing then you will have to do it manually.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: How to search all searchable fields of a table at the same time [message #3118 is a reply to message #3112]

Thu, 18 October 2012 19:20

jjtoranzo2004
Messages: 261
Registered: September 2012

Senior Member

Any suggestions for where to start?
Perhaps for something more humble, as how to search in two fields at the same time such as CONCAT(name, surname)?

Thanks.

Report message to a moderator

Re: How to search all searchable fields of a table at the same time [message #3120 is a reply to message #3118]

Fri, 19 October 2012 01:48

AJM
Messages: 2368
Registered: April 2006
Location: Surrey, UK

Senior Member

You first have to build the SQL query that does what you want, then get the framework to use that query.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Breadcrumb links
Next Topic:	Dropdown Lists on Rowdata

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 16:21:37 EST 2024

Total time taken to generate the page: 0.01318 seconds