If you require any further advice or information, please call our Course Enquiry team on 01772 892400 or email [email protected]
| <UserDefQueryXml><WebQuerySource><QUERYNO>d4afcf26-9b07-b85d-723a-a54a99f66ec0</QUERYNO><QUERYNAME /><OWNERTABLE>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</OWNERTABLE><QUERYSOURCECHANGED>Wed, 19 May 2021 14:29:05 GMT</QUERYSOURCECHANGED><QUICKSEARCH_TEXT /></WebQuerySource><WebQuerySource1><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><RULENAME>New rule created at Wed Jul 29 10:08:52 2015</RULENAME><RULENUMBER>1</RULENUMBER><QUERYNO>d4afcf26-9b07-b85d-723a-a54a99f66ec0</QUERYNO><ORRULE>0</ORRULE><NOTRULE>0</NOTRULE><BRACKETOPEN /><BRACKETCLOSE /><CREATEDBY /><CHANGEDBY /></WebQuerySource1><WebQuerySource2><CONDITIONNO>771a98a9-b912-c0e6-2366-691a6b9dee64</CONDITIONNO><DBFIELD>Start Date</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Greater than or equal to</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>1</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>17116297-5a7e-4005-a78d-c97a7a4d6824</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>b5925cec-43d0-4d17-88cd-6f982a29b5ff</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>STARTDATE</TABLECOLUMN><TABLENAME>EVENTMODULE</TABLENAME><VALUE><<today>></VALUE><LOOKUP_TEXT /><TableColumnCaption>Event .Start Date</TableColumnCaption><ColumnId>17116297-5a7e-4005-a78d-c97a7a4d6824</ColumnId><DbEntityId>b5925cec-43d0-4d17-88cd-6f982a29b5ff</DbEntityId><ColumnName>STARTDATE</ColumnName><ColumnCaption_NoNull>Start Date</ColumnCaption_NoNull><PrimaryTable>EVENTMODULE</PrimaryTable><Description>STARTDATE</Description><Type>1</Type><TypeDesc>Text and Label</TypeDesc><Caption>Start Date</Caption><DataTextColumn>EVENTMODULE_STARTDATE</DataTextColumn><BuildLookup>1</BuildLookup><TextFormat>dd/MM/yyyy</TextFormat><BuiltInLookupType>DATE</BuiltInLookupType><ShowInListBuilder>1</ShowInListBuilder><DataType>datetime</DataType><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><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><SplitChar></SplitChar><SplitPart></SplitPart></WebQuerySource2><WebQuerySource2><CONDITIONNO>dbdbf0b3-5cba-aa88-41b9-f9bac9cff391</CONDITIONNO><DBFIELD>Event Code</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>2</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>93b2bb5b-c09c-4690-84e8-eec9b5633cf9</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>a2ae67a1-d206-4e4d-a8f7-f5150134a96f</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</DBFIELD_VIEWID><USERSELECT>1</USERSELECT><VIEWNAME /><TABLECOLUMN>EVENTCODE</TABLECOLUMN><TABLENAME>EVENTMODULE</TABLENAME><VALUE></VALUE><LOOKUP_TEXT></LOOKUP_TEXT><TableColumnCaption>Event .Event Code</TableColumnCaption><ColumnId>93b2bb5b-c09c-4690-84e8-eec9b5633cf9</ColumnId><DbEntityId>a2ae67a1-d206-4e4d-a8f7-f5150134a96f</DbEntityId><ColumnName>EVENTCODE</ColumnName><ColumnCaption_NoNull>Event Code</ColumnCaption_NoNull><PrimaryTable>EVENTMODULE</PrimaryTable><Description>EVENTCODE</Description><Type>1</Type><TypeDesc>Text and Label</TypeDesc><Caption>Event Code</Caption><DataTextColumn>EVENTMODULE_EVENTCODE</DataTextColumn><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><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><SplitChar></SplitChar><SplitPart></SplitPart></WebQuerySource2><WebQuerySource2><CONDITIONNO>77dcdb6b-caf3-4750-59a8-4aa6422ccda3</CONDITIONNO><DBFIELD>Campaign Code</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>3</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>6cd13dcb-e47b-453d-9476-a011599a16ae</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>cf9a336f-39f0-4e8e-92e9-7f7780754132</DBFIELD_ENTITYID><DBFIELD_VIEWID>411c8f9f-b16c-448c-a34a-7d1d613bd4f7</DBFIELD_VIEWID><USERSELECT>1</USERSELECT><VIEWNAME /><TABLECOLUMN>CAMPAIGNCODE</TABLECOLUMN><TABLENAME>CAMPAIGNS</TABLENAME><VALUE>CTB2223</VALUE><LOOKUP_TEXT></LOOKUP_TEXT><TableColumnCaption>Campaigns.Campaign Code</TableColumnCaption><ColumnId>6cd13dcb-e47b-453d-9476-a011599a16ae</ColumnId><DbEntityId>cf9a336f-39f0-4e8e-92e9-7f7780754132</DbEntityId><ColumnName>CAMPAIGNCODE</ColumnName><ColumnCaption_NoNull>Campaign Code</ColumnCaption_NoNull><PrimaryTable>CAMPAIGNS</PrimaryTable><Description>CAMPAIGNCODE</Description><Type>1</Type><TypeDesc>Text and Label</TypeDesc><Caption>Campaign Code</Caption><DataTextColumn>CAMPAIGNS_CAMPAIGNCODE</DataTextColumn><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><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><SplitChar></SplitChar><SplitPart></SplitPart></WebQuerySource2><WebQuerySource2><CONDITIONNO>c44300e8-053f-b876-efc8-f08a9cdfd749</CONDITIONNO><DBFIELD>Stage</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>4</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>1cf3a36e-7d4f-47a0-af07-c418f46f77e0</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>0b981251-1f10-4861-b045-80e842a33ada</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>STAGE</TABLECOLUMN><TABLENAME>EVENTMODULE</TABLENAME><VALUE>Live</VALUE><LOOKUP_TEXT /><TableColumnCaption>Event .Stage</TableColumnCaption><ColumnId>1cf3a36e-7d4f-47a0-af07-c418f46f77e0</ColumnId><DbEntityId>0b981251-1f10-4861-b045-80e842a33ada</DbEntityId><ColumnName>STAGE</ColumnName><ColumnCaption_NoNull>Stage</ColumnCaption_NoNull><PrimaryTable>EVENTMODULE</PrimaryTable><Description>STAGE</Description><Type>1</Type><TypeDesc>Text and Label</TypeDesc><Caption>Stage</Caption><DataTextColumn>EVENTMODULE_STAGE</DataTextColumn><BuildLookup>1</BuildLookup><PickListId>4477e7c4-ba67-43cd-b844-6bc5151a481a</PickListId><PickListName>Campaign Stage</PickListName><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><TextFormat></TextFormat><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><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><SplitChar></SplitChar><SplitPart></SplitPart></WebQuerySource2><WebQuerySource2><CONDITIONNO>12d3bc85-e0c1-f033-c609-3fe84cf319b4</CONDITIONNO><DBFIELD>Invitation Only</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>5</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>74661578-7fdb-4f9b-81a5-6a0318bdd8c0</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>863f65af-b3f3-4c2e-8fe6-5b38b2a35e77</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>INVITATIONONLY</TABLECOLUMN><TABLENAME>EVENTMODULE</TABLENAME><VALUE>No</VALUE><LOOKUP_TEXT /><TableColumnCaption>Event .Invitation Only</TableColumnCaption><ColumnId>74661578-7fdb-4f9b-81a5-6a0318bdd8c0</ColumnId><DbEntityId>863f65af-b3f3-4c2e-8fe6-5b38b2a35e77</DbEntityId><ColumnName>INVITATIONONLY</ColumnName><ColumnCaption_NoNull>Invitation Only</ColumnCaption_NoNull><PrimaryTable>EVENTMODULE</PrimaryTable><Description>INVITATIONONLY</Description><Type>15</Type><TypeDesc>Radio List</TypeDesc><Caption>Invitation Only</Caption><DataTextColumn>EVENTMODULE_INVITATIONONLY</DataTextColumn><BuildLookup>1</BuildLookup><PickListId>29b172b5-d2fa-44a0-88f9-69dcbaef0bc0</PickListId><PickListName>Yes/No</PickListName><ShowInListBuilder>1</ShowInListBuilder><DataType>nvarchar</DataType><TextFormat></TextFormat><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><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><SplitChar></SplitChar><SplitPart></SplitPart></WebQuerySource2><WebQuerySource2><CONDITIONNO>d371ab5f-06f2-db89-6a50-0f9f8e4e4cc6</CONDITIONNO><DBFIELD>Start Date</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>6</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>17116297-5a7e-4005-a78d-c97a7a4d6824</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>b5925cec-43d0-4d17-88cd-6f982a29b5ff</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</DBFIELD_VIEWID><USERSELECT>1</USERSELECT><VIEWNAME /><TABLECOLUMN>STARTDATE</TABLECOLUMN><TABLENAME>EVENTMODULE</TABLENAME><VALUE></VALUE><LOOKUP_TEXT></LOOKUP_TEXT><TableColumnCaption>Event .Start Date</TableColumnCaption><ColumnId>17116297-5a7e-4005-a78d-c97a7a4d6824</ColumnId><DbEntityId>b5925cec-43d0-4d17-88cd-6f982a29b5ff</DbEntityId><ColumnName>STARTDATE</ColumnName><ColumnCaption_NoNull>Start Date</ColumnCaption_NoNull><PrimaryTable>EVENTMODULE</PrimaryTable><Description>STARTDATE</Description><Type>1</Type><TypeDesc>Text and Label</TypeDesc><Caption>Start Date</Caption><DataTextColumn>EVENTMODULE_STARTDATE</DataTextColumn><BuildLookup>1</BuildLookup><TextFormat>dd/MM/yyyy</TextFormat><BuiltInLookupType>DATE</BuiltInLookupType><ShowInListBuilder>1</ShowInListBuilder><DataType>datetime</DataType><PickListName></PickListName><PickListId></PickListId><PickFormId></PickFormId><PickValueColumn></PickValueColumn><PickTextColumn></PickTextColumn><PickerType></PickerType><PickMandatory></PickMandatory><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><SplitChar></SplitChar><SplitPart></SplitPart></WebQuerySource2><WebQuerySource2><CONDITIONNO>be5002f9-4ba5-3ab1-e3ab-231376a3a166</CONDITIONNO><DBFIELD>At Capacity</DBFIELD><RULENO>d6f9ce70-1418-d117-4815-af33264a2148</RULENO><OPERATOR>Equal To</OPERATOR><ORCONDITION>0</ORCONDITION><CONDITIONLEVEL>1</CONDITIONLEVEL><CONDITIONORDER>7</CONDITIONORDER><RELATIONSHIPPATH /><DBFIELD_VIEWRELID>139eeeab-e8fd-4f6a-82e6-a26238e1aee5</DBFIELD_VIEWRELID><DBFIELD_ENTITYID>128e4308-f4cf-44ea-881d-53e748df95b8</DBFIELD_ENTITYID><DBFIELD_VIEWID>ff5c8f7d-db33-4e18-b31b-88c35b0b804a</DBFIELD_VIEWID><USERSELECT /><VIEWNAME /><TABLECOLUMN>ATCAPACITY</TABLECOLUMN><TABLENAME>EVENTMODULE</TABLENAME><VALUE>0</VALUE><LOOKUP_TEXT>No</LOOKUP_TEXT><TableColumnCaption>Event .At Capacity</TableColumnCaption><ColumnId>139eeeab-e8fd-4f6a-82e6-a26238e1aee5</ColumnId><DbEntityId>128e4308-f4cf-44ea-881d-53e748df95b8</DbEntityId><ColumnName>ATCAPACITY</ColumnName><ColumnCaption_NoNull>At Capacity</ColumnCaption_NoNull><PrimaryTable>EVENTMODULE</PrimaryTable><Description>ATCAPACITY</Description><Type>2</Type><TypeDesc>Checkbox</TypeDesc><Caption>At Capacity</Caption><DataTextColumn>EVENTMODULE_ATCAPACITY</DataTextColumn><DataSqlSelect>CASE WHEN ( [EVENTMODULE].[MAXNOPLACES] - ( (CASE WHEN [EVENTMODULE].[ADDGUESTSTOATTENDEES] = 1 THEN (SELECT ISNULL(SUM(ISNULL(EVENTPLACE.GUESTS,0) + 1),0) FROM EVENTPLACE WHERE EVENTPLACE.STATUS IN ('Accepted','Attended') AND ISNULL(EVENTPLACE.DELETEFLAG,0) = 0 AND EVENTPLACE.EVENTMODULENO = [EVENTMODULE].EVENTMODULENO) ELSE (SELECT ISNULL(COUNT(*),0) FROM EVENTPLACE WHERE EVENTPLACE.STATUS IN ('Accepted','Attended') AND ISNULL(EVENTPLACE.DELETEFLAG,0) = 0 AND EVENTPLACE.EVENTMODULENO = [EVENTMODULE].EVENTMODULENO) END) ) ) <= 0 AND isnull([EVENTMODULE].[OVERBOOKING],0) <> 1 THEN 1 ELSE 0 END</DataSqlSelect><ShowInListBuilder>1</ShowInListBuilder><DataType>tinyint</DataType><PermanentName>At Capacity</PermanentName><PickListName></PickListName><PickTextColumn></PickTextColumn><BuildLookup></BuildLookup><PickValueColumn></PickValueColumn><TextFormat></TextFormat><PickListId></PickListId><PickFormId></PickFormId><PickerType></PickerType><PickMandatory></PickMandatory><BuiltInLookupType></BuiltInLookupType><DataFormId></DataFormId><DataId></DataId><Hint></Hint><Url></Url><IsEncrypted></IsEncrypted><Width></Width><NoWrap></NoWrap><Icon></Icon><SplitChar></SplitChar><SplitPart></SplitPart><PickWorkflowId></PickWorkflowId><PickWorkflowName></PickWorkflowName><PickListMaxSize></PickListMaxSize><Target></Target><ListShowFilterButton></ListShowFilterButton></WebQuerySource2></UserDefQueryXml> |
|