hello i have a smart field that was calculated from a different table and i wanted to have search through that field. and the only option (at least what shown in the documentation) for me is to add my query conditions to the where_clause of the query, but in my case i need to add a table to the fro…

finally after a lot of trial and error it works. here’s the code: search_translated_names = lambda do |query, search| # Injects your new filter into the WHERE clause. query = query.joins("LEFT OUTER JOIN user_translations ON user_translations.user_id = users.id") query.where_clause.sen…

Search through a smart field that was calculated from a different table

Help me!

Sliman_Medini March 1, 2021, 4:28pm 4

Hi @huss,

I am asking for my teammates about the capacity of the query object explained in the doc.

Topic		Replies	Views
Implement Search on Smart Field Help me! howtos	7	594	June 28, 2021
Searching on an other-table based Smart Field Help me!	23	722	February 10, 2021
Smart field reference link Help me!	7	587	March 4, 2021
Cannot Search on a smart field with two joints Help me!	6	601	June 3, 2021
Search in a reference field which is a smart field Help me!	1	296	November 5, 2021

Search through a smart field that was calculated from a different table

Related topics