I would like to include yesterday date in my select query for comparison. In MySQL we can easily get the date part using DATE() but in Doctrine we don’t have that functionality.
I tried to bind it as a parameter but that does not work with the error “You cannot define a mapping item when in a sequence in”YAML1- CASE WHEN caseEntity.followup_date < :yesterday THEN 'text-danger' ELSE '' END as row_class_name
The use case is that in the datagrid I want to color the overdue dates with red so I add a class. The followup_date is a datetime field. I’m ok with filtering by date or datetime but just don’t see any way. Can you please help?
As such doctrine is proving to be very restricting when it comes to datagrids.
You must be logged in to reply to this topic.