Intersection of lists

My repeater group has the data type “announced class”, and each announced class has a list of shifts. And in the search I want to find the intersection, for example, only the morning classes, or only the afternoon and
morning Where am I wrong? My turns are option sets

I’m not quite sure yet but I think it has something to do with your database structure.

If I were to build something like that, I would structure the database like this:

Data type: announced class

Fields:

Morning classes | Morning classes
Afternoon classes | Afternoon classes
Evening classes | Evening classes

Data type: Morning classes (for morning, afternoon, and evening)

Fields:
Time | Date

I’m not sure what you’re trying to build but that’s how I would structure the DB since this way, you could prevent lists

For the Bubblers that are reading this, please do correct me if I’m wrong. or I’m missing something. I’d be more than happy to receive feedback

1 Like

Hi fococaveira1 ! how did you solved this? I think I have the same issue