Hello,
I’d need to create a relation which tests a date field on the to table to see both:
- if the field is not null and,
- if not null, whether it is greater than the from table related field
Now I can’t seem to find any suitable method to do this directly using relations. Is it even possible? What I basically need is to translate a query like
SELECT table2.* FROM table1 INNER JOIN table2 ON table1.pk = table2.pk WHERE table2.date_field IS NOT NULL AND table2.date_field > table1.date_field
Thanks in advance.