1. jimbo
  2. Support
  3. Sunday, August 09 2015, 11:00 AM
Hi,

I was wondering if there's a way to;

query from 2 (or more) database columns (from the same table) in the Options Select Field tab (so that I can create a custom search option)?

or

use the same alias for 2 (or more) text boxes (so that the data goes into the same column and can be accessed via a custom search field)?

Many thanks.
Accepted Answer
admin Accepted Answer
Admin
Hi,
sorry for now this is not possible. For each field type is defined a SQL code to append in search query, you need to edit this code, you will find this code in /administrator/components/com_jsn/helpers/fields/fieldtype.php in function "getSearchQuery"


for example:

use the same alias for 2 (or more) text boxes...
you can change line 97 from
$query->where('b.'.$db->quoteName($field->alias).' LIKE '.$db->quote('%'.JRequest::getVar($field->alias,null).'%'));
with
if( $field->alias== 'my_text_on_multiple_columns' )
{
$query->where('b.'.$db->quoteName( "field1alias" ).' LIKE '.$db->quote('%'.JRequest::getVar($field->alias,null).'%').' OR b.'.$db->quoteName( "field2alias" ).' LIKE '.$db->quote('%'.JRequest::getVar($field->alias,null).'%'));
}
else
{
$query->where('b.'.$db->quoteName($field->alias).' LIKE '.$db->quote('%'.JRequest::getVar($field->alias,null).'%'));
}

this code enable on text field with alias "my_text_on_multiple_columns" search on columns "field1alias" and "field2alias"

NOTE: this code is not tested and not supported

Easy Profile is a profiler component (not directory component), so search feature are limited.
  1. more than a month ago
  2. Support
  3. # Permalink
jimbo Accepted Answer
Basic
Thank you very much - that worked great for the text box.
  1. more than a month ago
  2. Support
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.