Allow searches by Title and description in back end.
Go to Admin >> Listing >> Manage listing ,, then try to search for an item in the listing by its Title and or Description ...

There are different fields you can select like ID, pattern and email in backoffice.
Select correct one.

What is pattern for?
Also, what is the correct way to allow search by Title of the listing?
what is the correct way to allow search by description of the listing?

Search for title/desc

Search for title/desc

But is not working for me, My listing labguage is Arabic. see the attachement.

Enable query log and check what was query

SELECT oc2_t_item.*, oc2_t_item.s_contact_name as s_user_name, oc2_t_item_location.*
FROM (oc2_t_item)
LEFT JOIN oc2_t_item_description as d ON d.fk_i_item_id = oc2_t_item.pk_i_id
LEFT JOIN oc2_t_item_location ON oc2_t_item_location.fk_i_item_id = oc2_t_item.pk_i_id
WHERE MATCH(d.s_title, d.s_description) AGAINST('والسجائر' IN BOOLEAN MODE)
AND ( d.fk_c_locale_code LIKE 'en_US' )
ORDER BY dt_pub_date desc
LIMIT 0, 500


Please conseder the following:
- My oc2_t_item_location table is Empty, because i have imported my list my way only to oc2_t_item and oc2_t_item_description
- My language is Arabic so the fk_c_locale_code shouldnt be en_US , it should be ar_SY instead ...

I have just tried to run the SQL Q from phpMyAdmin like this (I have removed oc2_t_item_location table and changed fk_c_locale_code to 'ar_SY')

SELECT oc2_t_item.*, oc2_t_item.s_contact_name as s_user_name
FROM (oc2_t_item)
LEFT JOIN oc2_t_item_description as d ON d.fk_i_item_id = oc2_t_item.pk_i_id
WHERE MATCH(d.s_title, d.s_description) AGAINST('والسجائر' IN BOOLEAN MODE)
AND ( d.fk_c_locale_code LIKE 'ar_SY' )
ORDER BY dt_pub_date desc
LIMIT 0, 500

and it works fine ...

Where can  i do the change to system code in order to reflect such modification.?