Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

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)
How to search all searchable fields of a table at the same time [message #3106] Wed, 17 October 2012 14:55 Go to next message
jjtoranzo2004 is currently offline  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.
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 Go to previous messageGo to next message
AJM is currently offline  AJM
Messages: 2312
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.

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 Go to previous messageGo to next message
jjtoranzo2004 is currently offline  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.
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 Go to previous message
AJM is currently offline  AJM
Messages: 2312
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.

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


Current Time: Sun Jan 29 19:38:24 EST 2023

Total time taken to generate the page: 0.01451 seconds