You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Problem using column names like 'first_table_of_join.column_name' when working with joined tables in Filters 'LIKE' (Contains) and possible solutions
#93
Open
alansgonzaga opened this issue
Oct 30, 2024
· 0 comments
Hi!
I got some errors with purity filters that are implementing LIKE queries (usualy CONTAINS FILTER), when I'm working with joined tables that has identical column names and that I need to send table name along with the column like (first_table_of_join.column_name).
I checked that purity use on ContainsFilter $query->whereRaw("{$this->column}...
In this case, when I send an "column" (first_table_of_join.column_name), the query are being assembly first_table_of_join.column_name instead of first_table_of_join.column_name, and sql throw error.
So I solved here in this way:
Do you guys see some scenario it wont work?
Maybe should we think other solution?
Replicated this to all these:
The text was updated successfully, but these errors were encountered:
Hi!
I got some errors with purity filters that are implementing LIKE queries (usualy CONTAINS FILTER), when I'm working with joined tables that has identical column names and that I need to send table name along with the column like (first_table_of_join.column_name).
I checked that purity use on ContainsFilter $query->whereRaw("
{$this->column}
...In this case, when I send an "column" (first_table_of_join.column_name), the query are being assembly
first_table_of_join.column_name
instead offirst_table_of_join
.column_name
, and sql throw error.So I solved here in this way:
Do you guys see some scenario it wont work?
Maybe should we think other solution?
Replicated this to all these:
The text was updated successfully, but these errors were encountered: