Showing available rooms using time slot filtering
I'm trying to display all available meeting rooms with a condition of only showing meeting rooms that are not booked for a user given time period
Some context :
Booking table contains startTime, endTime and meetingRoom Id
Meeting room table contains information relevant to the room like name, pictures etc
What I've tried
Using a join (meeting room & booking data tables) and put a condition where user start time is not equal to booking.startTime. As you can imagine, it's not working
Any suggestions on what I can try doing?
Working with APIs
5 replies