Date Manipulation in Filter

BIZ TMS XData
1

Hi,

I have an entity which has, amongst others, an appointent start date, end date and reminder interval which is the number of minutes the user should be reminded before the event.

Is it possible to do something like:

$filter=startdate sub reminderinterval gt 2023-06-12T14:05

Thanks,

Ken

2

Such filter will be directly translated into a SQL statement that will probably be like START_DATE - REMINDER_INTERVAL > :date so it will probably not work unless the underlying database accepts that syntax (subtract integers from date fields).

3

Thanks. I guess I'll do it the other end then.

1 Like
4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.