I am trying to set up a decision which checks all reservations in the database and compares those times to the times the user wants to use. So the attributes are StartTime and EndTime, both date-time attributes and the attributes the user puts in are PickedStartTime and PickedEndTime. Now I don’t know how to compare this, so that no reservation can be made if the timebetwen my picked start and endtimes is filled in by any reservation’s start or endtimes, meaning also the timebetween.

I am trying to set up a decision which checks all reservations in the database and compares those times to the times the user wants to use. So the attributes are StartTime and EndTime, both date-time attributes and the attributes the user puts in are PickedStartTime and PickedEndTime. Now I don’t know how to compare this, so that no reservation can be made if the timebetwen my picked start and endtimes is filled in by any reservation’s start or endtimes, meaning also the timebetween.

I managed to use mendix Audit trail module with one entity, but couldn’t do it with multiple entities. What is the best way to pass multiple entities parameters here ?

ERROR: new row for relation “membre_spec” violates check constraint “membre_spec_qualite_check”
Detail: Failing row contains (4, 2024-04-12, 2024-04-15, 5, Co_Signature, Co_gerant1, 1, null).