Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Monday 12:35 am
Add a reply View Replies (0)

Resolved Search Criteria

  1. ahmet-karaoglan
    ahmet-karaoglan
  2. Features Request
  3. Tuesday, December 29 2015, 10:36 PM
hi,
i have an integer custom field with 11 numbers. I want to search from this field but this field and search field must be equal. For example; in profile this field is 46792149721. i must find only this profile with 46792149721 search. But i search 467 or 921 or 4 or 72 and i find this profile. Profile field content and search field content must be equal. How can i do this?
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
this is because you use a text field type, the query use LIKE sql statement.

How can i do this?
You need to change the search query. follow these steps:
- open file /administrator/components/com_jsn/helpers/fields/text.php
- add after line 96 this code:
// LINE 96

if( $field->alias == 'tc_kimlik_no' ) 

    $query->where('b.' . $db->quoteName( $field->alias ) . ' LIKE ' . $db->quote( JRequest::getVar( $field->alias, null ) ) );

else

// LINE 97

now when you search for field tc_kimlik_no you have LIKE statement without jolly char (%), for all fields normal query.
  1. more than a month ago
  2. Features Request
  3. # Permalink
Responses (0)


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.