<UserDefQueryXml><WebQuerySource><QUERYNO>eedd9617-9575-5d2d-8ffd-421b5fcc2267</QUERYNO><QUERYNAME /><OWNERTABLE>e8522e38-4696-49d1-b90e-e5a6ae5265e9</OWNERTABLE><QUERYSOURCECHANGED>Fri, 08 Oct 2021 09:14:17 GMT</QUERYSOURCECHANGED><QUICKSEARCH_TEXT /></WebQuerySource><WebQuerySource1><RULENO>47d1eddd-bf4b-4d80-d6db-66e821c3f047</RULENO><RULENAME>New rule created at Thu Sep 15 10:51:40 2011</RULENAME><RULENUMBER>1</RULENUMBER><QUERYNO>eedd9617-9575-5d2d-8ffd-421b5fcc2267</QUERYNO><ORRULE>0</ORRULE><NOTRULE>0</NOTRULE><BRACKETOPEN /><BRACKETCLOSE>and eventmodule.publishtowebsite = 1</BRACKETCLOSE><CREATEDBY /><CHANGEDBY /></WebQuerySource1><WebQuerySource1><RULENO>f773c2c7-89f9-90a8-ec4d-d574b9018beb</RULENO><RULENAME>New rule created at Wed Mar 11 10:42:36 2015</RULENAME><RULENUMBER>2</RULENUMBER><QUERYNO>eedd9617-9575-5d2d-8ffd-421b5fcc2267</QUERYNO><ORRULE>0</ORRULE><NOTRULE>0</NOTRULE><BRACKETOPEN>(</BRACKETOPEN><BRACKETCLOSE /><CREATEDBY /><CHANGEDBY /></WebQuerySource1><WebQuerySource1><RULENO>8c478dea-2867-f9b4-4bba-3880cda82deb</RULENO><RULENAME>New rule created at Tue Sep 07 2021 12:53:18 GMT+0100 (British Summer Time)</RULENAME><RULENUMBER>3</RULENUMBER><QUERYNO>eedd9617-9575-5d2d-8ffd-421b5fcc2267</QUERYNO><ORRULE>1</ORRULE><NOTRULE>0</NOTRULE><BRACKETOPEN /><BRACKETCLOSE>)</BRACKETCLOSE><CREATEDBY /><CHANGEDBY /></WebQuerySource1><WebQuerySource2><CONDITIONNO>3c0baea2-65c7-4fac-38c3-04c2a477b495</CONDITIONNO><DBFIELD /><RULENO>47d1eddd-bf4b-4d80-d6db-66e821c3f047</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONORDER>1</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>4abfce2f-dd13-4710-959f-06004577ba73</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>c5e04dbd-b14e-48b8-9bdf-ebec498d9728</DBFIELD_ENTITYID><DBFIELD_VIEWID>e8522e38-4696-49d1-b90e-e5a6ae5265e9</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>EVENTMODULENO</TABLECOLUMN><TABLENAME>SESSION</TABLENAME><VALUE><<EVENTMODULE_EVENTMODULENO>></VALUE><LOOKUP_TEXT><<EVENTMODULE_EVENTMODULENO>></LOOKUP_TEXT><TableColumnCaption>Session.Event</TableColumnCaption><ColumnId>4abfce2f-dd13-4710-959f-06004577ba73</ColumnId><DbEntityId>c5e04dbd-b14e-48b8-9bdf-ebec498d9728</DbEntityId><ColumnName>EVENTMODULENO</ColumnName><ColumnCaption_NoNull>EVENTMODULENO</ColumnCaption_NoNull><PrimaryTable>SESSION</PrimaryTable><Description>EVENTMODULENO</Description><Type>23</Type><TypeDesc>Textbox</TypeDesc><DataTextColumn>SESSION_EVENTMODULENO</DataTextColumn><Hidden>1</Hidden><ShowInListBuilder>1</ShowInListBuilder><DataType>uniqueidentifier</DataType><TextFormat></TextFormat><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn>EVENTMODULE_EVENTMODULENO</PickValueColumn><PickTextColumn>EVENTMODULE_DESCRIPTION</PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuildLookup>1</BuildLookup><DataFormId></DataFormId><DataId></DataId><Hint></Hint><Url></Url><IsEncrypted></IsEncrypted><Width></Width><NoWrap></NoWrap><Icon></Icon><PickWorkflowId>c859b4e3-3891-4063-b38a-f6ab18154e7a</PickWorkflowId><PickWorkflowName>Events Listing (Global)</PickWorkflowName><PickListMaxSize></PickListMaxSize><Caption>Event</Caption><Target></Target><BuiltInLookupType></BuiltInLookupType><ListShowFilterButton></ListShowFilterButton></WebQuerySource2><WebQuerySource2><CONDITIONNO>ce6ad1c9-8537-1501-4f30-f027ea9bab64</CONDITIONNO><DBFIELD>Subject Areas</DBFIELD><RULENO>f773c2c7-89f9-90a8-ec4d-d574b9018beb</RULENO><OPERATOR>Contains</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>1</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>85c1c203-2e8d-42dd-8d2b-c42d970f8a62</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>4fe9081e-8623-4d6a-b5e4-7fd151b6400b</DBFIELD_ENTITYID><DBFIELD_VIEWID>e8522e38-4696-49d1-b90e-e5a6ae5265e9</DBFIELD_VIEWID><USERSELECT>1</USERSELECT><VIEWNAME /><TABLECOLUMN>GRIDLISTOFSUBJECTAREAS</TABLECOLUMN><TABLENAME>SESSION</TABLENAME><VALUE></VALUE><LOOKUP_TEXT></LOOKUP_TEXT><TableColumnCaption>Session.Subject Areas</TableColumnCaption><ColumnId>85c1c203-2e8d-42dd-8d2b-c42d970f8a62</ColumnId><DbEntityId>4fe9081e-8623-4d6a-b5e4-7fd151b6400b</DbEntityId><ColumnName>GRIDLISTOFSUBJECTAREAS</ColumnName><ColumnCaption_NoNull>Subject Areas</ColumnCaption_NoNull><PrimaryTable>SESSION</PrimaryTable><Description>GRIDLISTOFSUBJECTAREAS</Description><Type>5</Type><TypeDesc>Label</TypeDesc><Caption>Subject Areas</Caption><DataTextColumn>SESSION_GRIDLISTOFSUBJECTAREAS</DataTextColumn><DataSqlSelect>SELECT isnull([SUBJECTAREA].DESCRIPTION +';','') FROM SUBJECTAREA
WHERE [SUBJECTAREA].SESSIONNO = SESSION.SESSIONNO AND ISNULL(SUBJECTAREA.DELETEFLAG,0)=0
FOR XML PATH ('')</DataSqlSelect><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><PermanentName>Subject Areas</PermanentName><TextFormat></TextFormat><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><BuildLookup></BuildLookup><DataFormId></DataFormId><DataId></DataId><Hint></Hint><Url></Url><IsEncrypted></IsEncrypted><Width></Width><NoWrap></NoWrap><Icon></Icon><PickWorkflowId></PickWorkflowId><PickWorkflowName></PickWorkflowName><PickListMaxSize></PickListMaxSize><Target></Target><ListShowFilterButton></ListShowFilterButton></WebQuerySource2><WebQuerySource2><CONDITIONNO>09ea166b-2024-2092-1072-9b48ddc4f8dc</CONDITIONNO><DBFIELD>Subject Areas</DBFIELD><RULENO>f773c2c7-89f9-90a8-ec4d-d574b9018beb</RULENO><OPERATOR>Contains</OPERATOR><ORCONDITION>1</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>2</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>85c1c203-2e8d-42dd-8d2b-c42d970f8a62</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>4fe9081e-8623-4d6a-b5e4-7fd151b6400b</DBFIELD_ENTITYID><DBFIELD_VIEWID>e8522e38-4696-49d1-b90e-e5a6ae5265e9</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>GRIDLISTOFSUBJECTAREAS</TABLECOLUMN><TABLENAME>SESSION</TABLENAME><VALUE>General</VALUE><LOOKUP_TEXT /><TableColumnCaption>Session.Subject Areas</TableColumnCaption><ColumnId>85c1c203-2e8d-42dd-8d2b-c42d970f8a62</ColumnId><DbEntityId>4fe9081e-8623-4d6a-b5e4-7fd151b6400b</DbEntityId><ColumnName>GRIDLISTOFSUBJECTAREAS</ColumnName><ColumnCaption_NoNull>Subject Areas</ColumnCaption_NoNull><PrimaryTable>SESSION</PrimaryTable><Description>GRIDLISTOFSUBJECTAREAS</Description><Type>5</Type><TypeDesc>Label</TypeDesc><Caption>Subject Areas</Caption><DataTextColumn>SESSION_GRIDLISTOFSUBJECTAREAS</DataTextColumn><DataSqlSelect>SELECT isnull([SUBJECTAREA].DESCRIPTION +';','') FROM SUBJECTAREA
WHERE [SUBJECTAREA].SESSIONNO = SESSION.SESSIONNO AND ISNULL(SUBJECTAREA.DELETEFLAG,0)=0
FOR XML PATH ('')</DataSqlSelect><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><PermanentName>Subject Areas</PermanentName><TextFormat></TextFormat><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><BuildLookup></BuildLookup><DataFormId></DataFormId><DataId></DataId><Hint></Hint><Url></Url><IsEncrypted></IsEncrypted><Width></Width><NoWrap></NoWrap><Icon></Icon><PickWorkflowId></PickWorkflowId><PickWorkflowName></PickWorkflowName><PickListMaxSize></PickListMaxSize><Target></Target><ListShowFilterButton></ListShowFilterButton></WebQuerySource2><WebQuerySource2><CONDITIONNO>a2561079-526b-00a4-0ba8-b8b51325c0fd</CONDITIONNO><DBFIELD>Subject Areas</DBFIELD><RULENO>f773c2c7-89f9-90a8-ec4d-d574b9018beb</RULENO><OPERATOR>Contains</OPERATOR><ORCONDITION>1</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>3</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>85c1c203-2e8d-42dd-8d2b-c42d970f8a62</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>4fe9081e-8623-4d6a-b5e4-7fd151b6400b</DBFIELD_ENTITYID><DBFIELD_VIEWID>e8522e38-4696-49d1-b90e-e5a6ae5265e9</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>GRIDLISTOFSUBJECTAREAS</TABLECOLUMN><TABLENAME>SESSION</TABLENAME><VALUE>Accomadation</VALUE><LOOKUP_TEXT /><TableColumnCaption>Session.Subject Areas</TableColumnCaption><ColumnId>85c1c203-2e8d-42dd-8d2b-c42d970f8a62</ColumnId><DbEntityId>4fe9081e-8623-4d6a-b5e4-7fd151b6400b</DbEntityId><ColumnName>GRIDLISTOFSUBJECTAREAS</ColumnName><ColumnCaption_NoNull>Subject Areas</ColumnCaption_NoNull><PrimaryTable>SESSION</PrimaryTable><Description>GRIDLISTOFSUBJECTAREAS</Description><Type>5</Type><TypeDesc>Label</TypeDesc><Caption>Subject Areas</Caption><DataTextColumn>SESSION_GRIDLISTOFSUBJECTAREAS</DataTextColumn><DataSqlSelect>SELECT isnull([SUBJECTAREA].DESCRIPTION +';','') FROM SUBJECTAREA
WHERE [SUBJECTAREA].SESSIONNO = SESSION.SESSIONNO AND ISNULL(SUBJECTAREA.DELETEFLAG,0)=0
FOR XML PATH ('')</DataSqlSelect><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><PermanentName>Subject Areas</PermanentName><TextFormat></TextFormat><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><BuildLookup></BuildLookup><DataFormId></DataFormId><DataId></DataId><Hint></Hint><Url></Url><IsEncrypted></IsEncrypted><Width></Width><NoWrap></NoWrap><Icon></Icon><PickWorkflowId></PickWorkflowId><PickWorkflowName></PickWorkflowName><PickListMaxSize></PickListMaxSize><Target></Target><ListShowFilterButton></ListShowFilterButton></WebQuerySource2><WebQuerySource2><CONDITIONNO>cd8a5814-81ce-a07d-99ce-e0783fd1bc9a</CONDITIONNO><DBFIELD /><RULENO>8c478dea-2867-f9b4-4bba-3880cda82deb</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>1</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>0d572a3d-bc43-4528-93f4-70f81b6f7ddd</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>bfefacb2-b7fa-4ece-8aa8-5ab10ece8f71</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff64db0a-a641-4ef6-ae67-ff048d068095</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>EVENTPLACENO</TABLECOLUMN><TABLENAME>SESSIONATTENDANCE</TABLENAME><VALUE><<EVENTPLACE_EVENTPLACENO>></VALUE><LOOKUP_TEXT /><TableColumnCaption>Session Attendance.EVENTPLACENO</TableColumnCaption><ColumnId>0d572a3d-bc43-4528-93f4-70f81b6f7ddd</ColumnId><DbEntityId>bfefacb2-b7fa-4ece-8aa8-5ab10ece8f71</DbEntityId><ColumnName>EVENTPLACENO</ColumnName><ColumnCaption_NoNull>EVENTPLACENO</ColumnCaption_NoNull><PrimaryTable>SESSIONATTENDANCE</PrimaryTable><Description>EVENTPLACENO</Description><Type>1</Type><TypeDesc>Text and Label</TypeDesc><DataTextColumn>SESSIONATTENDANCE_EVENTPLACENO</DataTextColumn><Hidden>1</Hidden><ShowInListBuilder>0</ShowInListBuilder><DataType>uniqueidentifier</DataType><PermanentName>EVENTPLACENO</PermanentName><TextFormat></TextFormat><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><BuildLookup></BuildLookup><DataFormId></DataFormId><DataId></DataId><Hint></Hint><Url></Url><IsEncrypted></IsEncrypted><Width></Width><NoWrap></NoWrap><Icon></Icon><PickWorkflowId></PickWorkflowId><PickWorkflowName></PickWorkflowName><PickListMaxSize></PickListMaxSize><Target></Target><ListShowFilterButton></ListShowFilterButton></WebQuerySource2></UserDefQueryXml> |