Model service filtering by date

Question

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?

Answer 1

$data = ee('Model')->get('ChannelEntry')->filter('field_id_103', '>' , '1536677819');

This code works for me. Where field_id_103 is my field ID and 2nd parameter is operator (> , <, >=, <= etc.) and last parameter is db value that needs to check.