So I came across this tricky search that I need to perform and I’m wondering if anyone has any bright ideas of how to solve it.
I have a datatype that has a list of items called “courses” and each course is set to either be beginner or advanced. I have a repeating group that shows three random courses like this:
I want to be able to specify the number of beginner and advanced courses in the list of three. So, for example, I want the repeating group to show 2 beginner courses and 1 advanced course. I’m guessing this requires an advanced search but am stuck on what to specify for the advanced search.
I know that I could just fake this behaviour by setting up a repeating group with two elements in it called “RepeatingGroup Courses: beginner” and another repeating group with only one element in it called “RepeatingGroup Courses: advanced” but this doesn’t give me the dynamic capabilities that good bubbling should have (let’s say I want to change from 2 and 1 to 1 and 2 at some point in the future. This would be much more involved with the “fake” approach)
Anyone got anything for me?
Thanks so much