I have recently started using the model service to query channel entries.
$query = ee('Model')->get('ChannelEntry')
->filter(...);
I have been using EE's documentation to get by for most queries, but am now stuck.
I need to filter entries where a field matches a specific date. There is no mention of this in the documentation.
Previously, when I was able to query channel entries with a database call, I was using the following in a where clause:
DATE_FORMAT(from_unixtime(field_id_xx),'%d%m%y')
Does anyone know of how this can be achieved using the model service?
field_id_xx
custom query, data was saved in same table (exp_channel_data
). But in EE4, it saves in it's own table (exp_channel_data_field_xx
) – Mufi - Amici Infotech Sep 26 '18 at 14:50