How to find if given slot is already booked or not

0
Hello, I want to check for given slot if there is already an appointment in the calendar. If I do it in SQL I will fire below query. (startTime BETWEEN 'yourStartImput' AND 'yourEndImput') OR (endTime BETWEEN 'yourStartImput' AND 'yourEndImput') As I am new in Mendix could you please guide me, how to achieve it in Mendix. Thanks Prajakta
asked
2 answers
0

Retrieve the object from the database with an activity in a microflow and write the xpath for this.

Should be quite similar to what you’d do in SQL.

Xpath is explained in the documentation: https://docs.mendix.com/refguide/xpath

answered
0

Xpath condition should be

[$InputStartTime >= StartTime or $InputStartTime <= EndTime]
[$InputEndTime >= StartTime or $InputEndTime <= EndTime]
 

answered