Xref

Relaciona un registre amb altres amb una taula intermitja (xref)

        teachers:
            type: xref
            caption: teachers
            optionsSpan: 3
            span: 12
            table: 
              ado: DriveappointStudentsScheduledReportResourcesXrefAdo
              localId: periodicReportId
              xrefId: entityId
              fixedFields:
                  entityType: teacher   
              options: SELECT id, name as name, (SELECT GROUP_CONCAT(gridId) from driveappoint_teachers_grids_xref where driveappoint_teachers_grids_xref.status=1 and teacherId = driveappoint_teachers.id) as filter FROM driveappoint_teachers WHERE PERMANENT_CONDITIONS order by name