This is an old revision of the document!

Ensembles

Current ensembles

—- struct table —- from: ensemble, group select: %title%, ensemble.types, ensemble.age_groups, ensemble.genders, ensemble.weekdays, ensemble.recruiting, ensemble.audition where: group.end_date > $TODAY$ or: group.end_date = dynfilters: 1

Past ensembles

—- struct table —- from: ensemble, group select: %title%, ensemble.types, ensemble.age_groups, ensemble.genders, ensemble.weekdays, ensemble.recruiting, ensemble.audition where: group.end_date ⇐ $TODAY$ and: group.end_date != dynfilters: 1