This topic contains 3 replies, has 2 voices, and was last updated by Viacheslav Bemza 6 years, 2 months ago.
- Topic
Hi,
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”
1- CASE WHEN caseEntity.followup_date < :yesterday THEN 'text-danger' ELSE '' END as row_class_nameThe 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.
Thank you!
The forum ‘OroCRM – How do I? Questions’ is closed to new topics and replies.