Compare one date field to another in conditions
Add support for condition builder rules where one date field can be compared to another date field.
Example use case: Date field A is before Date field B.
This should support common field-to-field comparisons for date-based attributes rather than only comparing against static values.
Request from Sarah
Additional transcript examples:
- A specific worklist use case is identifying jobs where an event date is before the linked inspection date, which can happen when an inspection is rescheduled but linked events are not moved with it.
- The team also discussed broader field-to-field comparisons such as comparing event inspector vs inspection inspector, though that part extends beyond date-only logic.
- This request is closely related to the need for exists / does not exist checks so worklists can detect missing event records or partially configured scheduling data.
Status: Planned
Log in to comment and vote
No comments yet
Be the first to share your thoughts.