I have a collection with numbers from 1 to 10 and then I have collection with MaxCapacity.
The goal is to show all numbers in collection 1 in a select field that are below or equal the MaxCapacity. In the filter I use: SElect numbers WHERE people “less or equal then” MAX(maxcapacity).
I applied a select with that condition but it does not return anything at all. Thank you.