Filtrer by translatable field
Created 6 years ago by sdr1989Hello everyone I got this code:
{% set news = entries('news').where('status', '=', 1).orderBy('publish', 'DESC').paginate(10) %}
wich works fine, but if i try to filter by a translatable field, like the field name for example, i get a mysql error:
{% set news = entries('news').where('status', '=', 1).where('name', 'like', '%john%').orderBy('publish', 'DESC').paginate(10) %}
the error i get: Column not found: 1054 Unknown column 'name' in 'where clause' (SQL: select count(*) as aggregate from meis_news_news
where status
= 1 and name
like %john%)
I get the same errore even I use the get() instead of paginate()
How can i make the second query work? Thanks
Thanks for your reaply @piterden
It kinda works but: {% set table = builder.connection.table %} is empty in my case, if I put myself the name of the connection table than it works, the only problem left is that it gets every localitations (i.e. en - sp - de) of the model and not the one I'm actually using ( i.e. en) .
Please, anyone?