D!BS room capacity settings can be hard to understand. The explanation below should be more helpful!
Let's say you have rooms with various capacities. For example:
Room | Minimum | Maximum |
A | 2 | 4 |
B | 2 | 4 |
C | 2 | 6 |
D | 4 | 6 |
E | 4 | 8 |
Let's say we are requesting a room and we have these choices:
2 to 4 People |
2 to 6 People |
4 to 6 People |
4 to 8 People |
We have 5 People. First, which one do we choose?
-
- If we choose "2 to 6 People", then we will not see Rooms D or E because they hold more than 6 and cannot hold 2.
- If we choose "4 to 6 People", we will get all three rooms.
- If we choose "4 to 8 People", then we will not see Rooms C or D because they hold more than 6.
You would say: "But they can all hold 5 People".
Yes, but the Database query that looks for rooms is confused by your quest. It looks for all rooms that can handle the numbers contained in your request. So only rooms that can handle all of the numbers in the choice will be chosen. Each choice is not unique.
The correct way to define the choices would be the following:
2 to 3 People |
4 to 4 People |
5 to 6 People |
7 to 8 People |
The reason this is correct is because each choice can be fully contained in at least one room capacity.
- If we choose "2 to 4 People", it will not work properly because
-
-
- Rooms D & E contain 4 but not 2 or 3.
-
-
- If we choose "2 to 6 People", it will not work properly because
-
-
- Rooms A & B contain 2, 3, and 4 but not 5 or 6.
-
-
- If we choose "4 to 6 People", it will not work properly because
-
-
- Rooms A & B contain 4 but not 5 or 6.
-
-
- If we choose "4 to 8 People", it will not work properly because
-
-
- Rooms A & B contain 4 but not 5, 6, 7, or 8 and
- Rooms C & D contain 4, 5 & 6 but not 7 or 8.
-
-
Remember: All capacities have to be represented but each option has to be contained within the range of capacities for the room, and not split across them.