USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD
Add adhoc query and list for fafevent allparticipants
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @APPUSERID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @TYPE | tinyint | IN | |
| @USERID | int | IN | |
| @CLIENTSID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.USP_FAF_ADHOCQUERY_LIST_ALLPARTICIPANTS_ADD
(
@EVENTID uniqueidentifier,
@APPUSERID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@TYPE tinyint = 1, -- 1: All Participants, 2: All Leaders, 3: All Members, 4: Company & Team Leaders, 5: Company Leaders,
-- 6: Team Leaders, 7: Household leaders, 8: Team members & Individuals, 9: Household members
-- 20: All Participants Fundraising Target not met
@USERID int = null,
@CLIENTSID int = null
)
as
SET NOCOUNT ON;
DECLARE @EVENTNAME varchar(200)
DECLARE @QUERYDEFINITIONXML xml
DECLARE @QUERYDEFINITION nvarchar(max)
DECLARE @ADHOCQUERYID uniqueidentifier
DECLARE @IDSETREGISTERID uniqueidentifier
DECLARE @IDSETFUNCTIONNAME nvarchar(128)
DECLARE @SQL nvarchar(max)
DECLARE @QUERYNAME varchar(255)
-- DECLARE @UserID int
-- DECLARE @ClientsID int
DECLARE @DATEADDED datetime
DECLARE @EMAILLISTID int
DECLARE @EMAILLISTGUID uniqueidentifier
DECLARE @EMAILLISTQUERY nvarchar(2000)
DECLARE @BBNCQUERYID int
DECLARE @BBNCQUERYNAME varchar(512)
DECLARE @EMAILLISTQUERYXML xml
DECLARE @QUERYNAMETAG varchar(55)
DECLARE @PREVIOUSEVENTID uniqueidentifier
DECLARE @PREVIOUSEVENTNAME varchar(200)
DECLARE @ORIGINALEVENTID uniqueidentifier = @EVENTID
DECLARE @ROLEPERMISSION xml
DECLARE @SYSTEMROLE varchar(100),
@CLIENTSITESID int
SELECT @SYSTEMROLE=NAME from dbo.SYSTEMROLE where ID = 'A91E9BBA-E8D4-482C-8F79-BC78D4798EC4' -- originally called FAF Event Admin
SET @ROLEPERMISSION=N'<?xml version="1.0" encoding="utf-16"?>
<SYSTEMROLELIST>
<ITEM><GRANTORDENY>1</GRANTORDENY>
<NAME>'+@SYSTEMROLE+'</NAME>
<SYSTEMROLEID>A91E9BBA-E8D4-482C-8F79-BC78D4798EC4</SYSTEMROLEID>
</ITEM></SYSTEMROLELIST>'
SET @DATEADDED = GETDATE()
IF @TYPE = 1
SET @QUERYNAMETAG = ': All Participants'
IF @TYPE = 2
SET @QUERYNAMETAG = ': All Leaders'
IF @TYPE = 3
SET @QUERYNAMETAG = ': All Members' -- Team members, household members, individuals
IF @TYPE = 4
SET @QUERYNAMETAG = ': Company and Team Leaders'
IF @TYPE = 5
SET @QUERYNAMETAG = ': Company Leaders'
IF @TYPE = 6
SET @QUERYNAMETAG = ': Team Leaders'
IF @TYPE = 7
SET @QUERYNAMETAG = ': Household Leaders'
IF @TYPE = 8
SET @QUERYNAMETAG = ': Team members and Individuals'
IF @TYPE = 9
SET @QUERYNAMETAG = ': Household members'
IF @TYPE = 10
SET @QUERYNAMETAG = ': All Previous Participants'
IF @TYPE = 11
SET @QUERYNAMETAG = ': Previous Team and Household Leaders'
IF @TYPE = 12
SET @QUERYNAMETAG = ': Previous Individuals'
IF @TYPE = 13
SET @QUERYNAMETAG = ': Previous Company Leaders'
IF @TYPE = 14
SET @QUERYNAMETAG = ': Previous Team Leaders'
IF @TYPE = 15
SET @QUERYNAMETAG = ': Previous Household Leaders'
IF @TYPE = 20
SET @QUERYNAMETAG = ': AP Fundraising target not met'
SELECT @EVENTNAME = NAME,@CLIENTSITESID=EX.CLIENTSITESID FROM dbo.EVENT E (NOLOCK)
JOIN dbo.EVENTEXTENSION EX ON E.ID = EX.EVENTID
WHERE E.ID = @EVENTID;
SELECT @PREVIOUSEVENTNAME = PE.NAME, @PREVIOUSEVENTID = PE.ID
FROM dbo.EVENTEXTENSION EE (NOLOCK)
INNER JOIN dbo.EVENT PE (NOLOCK)
ON EE.PRIORYEAREVENTID = PE.ID
WHERE EE.EVENTID = @EVENTID;
SET @ADHOCQUERYID = NEWID();
SET @IDSETREGISTERID = @ADHOCQUERYID;
SET @EMAILLISTID = 0;
IF @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
SET @QUERYNAME = @EVENTNAME + @QUERYNAMETAG
SET @BBNCQUERYNAME = @QUERYNAME+' (Ad-hoc Query)'
SET @IDSETFUNCTIONNAME = 'UFN_ADHOCQUERYIDSET_'+CAST(@ADHOCQUERYID as varchar(40));
IF @TYPE = 1
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 2
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Company leader</v>
<v>Team leader</v>
<v>Head of household</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 3
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Household member</v>
<v>Individual</v>
<v>Team member</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 4
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Company leader</v>
<v>Team leader</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 5
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Company leader</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 6
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Team leader</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 7
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Head of household</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 8
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Individual</v>
<v>Team member</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 9
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Household member</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 10
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="IsNextYearRegistrant" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 11
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="IsNextYearRegistrant" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Team leader</v>
<v>Head of household</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 12
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="IsNextYearRegistrant" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Individual</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 13
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="IsNextYearRegistrant" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Company leader</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 14
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="IsNextYearRegistrant" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Team leader</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 15
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="IsNextYearRegistrant" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRATIONROLES" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsOneOf" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>Head of household</v>
</Values>
<TranslatedValues />
<DataType>String</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
IF @TYPE = 20
set @QUERYDEFINITION = N'<AdHocQuery xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns="Blackbaud.AppFx.WebService.API.1"
SuppressDuplicateRows="true" ChangedByCulture="en-US" FolderID="00000000-0000-0000-0000-000000000000" OwnerID="00000000-0000-0000-0000-000000000000" RecordType="Constituent" ID="c29c1b0e-654a-45e9-a3d6-8896a7becbbf" CategoryID="00000000-0000-0000-0000-000000000000" DefaultDataFormID="00000000-0000-0000-0000-000000000000" SiteID="00000000-0000-0000-0000-000000000000" Name="Walk-A-Thon: All Participants" ChangedByID="00000000-0000-0000-0000-000000000000" AddedByID="00000000-0000-0000-0000-000000000000" HasIDSet="true">
<QueryView ID="ee8a7483-c483-4214-9646-4bb62ec29ab7" ObjectName="V_QUERY_CONSTITUENT" RecordTypeID="00000000-0000-0000-0000-000000000000" PrimaryKeyField="" />
<SelectFields>
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="NAME" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" />
<f ObjectName="V_QUERY_CONSTITUENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT" />
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" />
</SelectFields>
<FilterFields>
<f ObjectName="V_QUERY_EVENT" ColumnName="ID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Event">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>27beb1b6-f3ec-40ae-b22d-b89888f92ae7</v>
</Values>
<TranslatedValues>
<v>Walk-A-Thon</v>
</TranslatedValues>
<DataType>Guid</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="DONOTEMAIL" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
<f ObjectName="V_QUERY_CONSTITUENTEMAILADDRESS" ColumnName="EMAILADDRESS" ParentPath="V_QUERY_CONSTITUENT\Email Addresses" DisplayPath="V_QUERY_CONSTITUENT\Email Addresses" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>EmailAddress</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT" ColumnName="REGISTRANTLOOKUPID" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant" FilterOperator="IsNotBlank" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values />
<TranslatedValues />
<DataType>String</DataType>
</f>
<f ObjectName="V_QUERY_REGISTRANT_FUNDRAISINGTOTAL" ColumnName="ISFUNDRAISINGGOALMET" ParentPath="V_QUERY_CONSTITUENT\FAFRegistrant\Fundraising Totals" DisplayPath="V_QUERY_CONSTITUENT\FAFRegistrant\Fundraising Totals" CompareType="And">
<DateFilterTypes />
<FuzzyDateFilterTypes />
<MonthDayFilterTypes />
<Values>
<v>0</v>
</Values>
<TranslatedValues />
<DataType>Boolean</DataType>
</f>
</FilterFields>
<SortFields />
<GroupFilterFields />
<IDSetInfo>
<IDSetID>d05dddf0-c0c2-4c64-ad22-c342d6efd10f</IDSetID>
</IDSetInfo>
<PermissionedRunRoles />
<PermissionedEditRoles />
<Mobilize>false</Mobilize>
<IsFavorite>false</IsFavorite>
</AdHocQuery>'
SET @SQL = N'select distinct [V_QUERY_CONSTITUENT].[NAME] as [Name],
[V_QUERY_CONSTITUENT\Email Addresses].[EMAILADDRESS] as [Email Addresses\Email address],
[V_QUERY_CONSTITUENT].[ID] as [System record ID],
[V_QUERY_CONSTITUENT\FAFRegistrant\Event].[ID] as [FAFRegistrant\Event\Event ID],
[V_QUERY_CONSTITUENT].[ID] as [QUERYRECID]
from [V_QUERY_CONSTITUENT] as [V_QUERY_CONSTITUENT]
left outer join [V_QUERY_CONSTITUENTEMAILADDRESS] as [V_QUERY_CONSTITUENT\Email Addresses] on [V_QUERY_CONSTITUENT].[ID] = [V_QUERY_CONSTITUENT\Email Addresses].[CONSTITUENTID]
left outer join [V_QUERY_REGISTRANT] as [V_QUERY_CONSTITUENT\FAFRegistrant] on [V_QUERY_CONSTITUENT].[ID] = [V_QUERY_CONSTITUENT\FAFRegistrant].[CONSTITUENTID]
inner join [V_QUERY_EVENT] as [V_QUERY_CONSTITUENT\FAFRegistrant\Event] on [V_QUERY_CONSTITUENT\FAFRegistrant].[EVENTID] = [V_QUERY_CONSTITUENT\FAFRegistrant\Event].[ID]
where [V_QUERY_CONSTITUENT\FAFRegistrant\Event].[ID] = ''27beb1b6-f3ec-40ae-b22d-b89888f92ae7''
and [V_QUERY_CONSTITUENT\Email Addresses].[DONOTEMAIL] = 0
and ([V_QUERY_CONSTITUENT\Email Addresses].[EMAILADDRESS] is not null and [V_QUERY_CONSTITUENT\Email Addresses].[EMAILADDRESS] <> '''')
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRANTLOOKUPID] is not null and [V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRANTLOOKUPID] <> '''')';
IF @TYPE = 2
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Company leader'', ''Team leader'',''Head of household''))'
IF @TYPE = 3
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Household member'', ''Individual'', ''Team member''))'
IF @TYPE = 4
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Company leader'', ''Team leader''))'
IF @TYPE = 5
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Company leader''))'
IF @TYPE = 6
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Team leader''))'
IF @TYPE = 7
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Head of household''))'
IF @TYPE = 8
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Individual'', ''Team member''))'
IF @TYPE = 9
SET @SQL = @SQL + ' and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Household member''))'
IF @TYPE = 10
SET @SQL = @SQL + ' and [V_QUERY_CONSTITUENT\FAFRegistrant].[IsNextYearRegistrant] = 0'
IF @TYPE = 11
SET @SQL = @SQL + ' and [V_QUERY_CONSTITUENT\FAFRegistrant].[IsNextYearRegistrant] = 0
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Team leader'',''Head of household''))'
IF @TYPE = 12
SET @SQL = @SQL + ' and [V_QUERY_CONSTITUENT\FAFRegistrant].[IsNextYearRegistrant] = 0
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Individual''))'
IF @TYPE = 13
SET @SQL = @SQL + ' and [V_QUERY_CONSTITUENT\FAFRegistrant].[IsNextYearRegistrant] = 0
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Company leader''))'
IF @TYPE = 14
SET @SQL = @SQL + ' and [V_QUERY_CONSTITUENT\FAFRegistrant].[IsNextYearRegistrant] = 0
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Team leader''))'
IF @TYPE = 15
SET @SQL = @SQL + ' and [V_QUERY_CONSTITUENT\FAFRegistrant].[IsNextYearRegistrant] = 0
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRATIONROLES] in (''Head of household''))'
IF @TYPE = 20
SET @SQL = N'select distinct [V_QUERY_CONSTITUENT].[NAME] as [Name],
[V_QUERY_CONSTITUENT\Email Addresses].[EMAILADDRESS] as [Email Addresses\Email address],
[V_QUERY_CONSTITUENT].[ID] as [QUERYRECID]
from [V_QUERY_CONSTITUENT] as [V_QUERY_CONSTITUENT]
left outer join [V_QUERY_CONSTITUENTEMAILADDRESS] as [V_QUERY_CONSTITUENT\Email Addresses] on [V_QUERY_CONSTITUENT].[ID] = [V_QUERY_CONSTITUENT\Email Addresses].[CONSTITUENTID]
left outer join [V_QUERY_REGISTRANT] as [V_QUERY_CONSTITUENT\FAFRegistrant] on [V_QUERY_CONSTITUENT].[ID] = [V_QUERY_CONSTITUENT\FAFRegistrant].[CONSTITUENTID]
inner join [V_QUERY_EVENT] as [V_QUERY_CONSTITUENT\FAFRegistrant\Event] on [V_QUERY_CONSTITUENT\FAFRegistrant].[EVENTID] = [V_QUERY_CONSTITUENT\FAFRegistrant\Event].[ID]
inner join [V_QUERY_REGISTRANT_FUNDRAISINGTOTAL] as [V_QUERY_CONSTITUENT\FAFRegistrant\Fundraising Totals] on [V_QUERY_CONSTITUENT\FAFRegistrant].[ID] = [V_QUERY_CONSTITUENT\FAFRegistrant\Fundraising Totals].[ID]
where [V_QUERY_CONSTITUENT\FAFRegistrant\Event].[ID] = ''27beb1b6-f3ec-40ae-b22d-b89888f92ae7''
and [V_QUERY_CONSTITUENT\Email Addresses].[DONOTEMAIL] = 0
and ([V_QUERY_CONSTITUENT\Email Addresses].[EMAILADDRESS] is not null and [V_QUERY_CONSTITUENT\Email Addresses].[EMAILADDRESS] <> '''')
and ([V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRANTLOOKUPID] is not null and [V_QUERY_CONSTITUENT\FAFRegistrant].[REGISTRANTLOOKUPID] <> '''')
and [V_QUERY_CONSTITUENT\FAFRegistrant\Fundraising Totals].[ISFUNDRAISINGGOALMET] = 0'
IF @TYPE IN (10,11,12) -- for previous event we need to filter based on previous event info
BEGIN
SET @EVENTNAME = @PREVIOUSEVENTNAME
SET @EVENTID = @PREVIOUSEVENTID
END
SET @QUERYDEFINITION = REPLACE(@QUERYDEFINITION,'Walk-A-Thon: All Participants',@QUERYNAME)
SET @QUERYDEFINITION = REPLACE(@QUERYDEFINITION,'Walk-A-Thon',@EVENTNAME)
SET @QUERYDEFINITION = REPLACE(@QUERYDEFINITION,'27beb1b6-f3ec-40ae-b22d-b89888f92ae7',cast(@EVENTID as nvarchar(40)))
SET @QUERYDEFINITION = REPLACE(@QUERYDEFINITION,'d05dddf0-c0c2-4c64-ad22-c342d6efd10f',cast(@IDSETREGISTERID as nvarchar(40)))
set @QUERYDEFINITION = REPLACE(@QUERYDEFINITION,'c29c1b0e-654a-45e9-a3d6-8896a7becbbf',cast(@ADHOCQUERYID as nvarchar(40)))
set @QUERYDEFINITION = REPLACE(@QUERYDEFINITION, '&','&' ) -- ensuring all ampersand in same format
set @QUERYDEFINITION = REPLACE(@QUERYDEFINITION, '&', '&') -- now replace to have all ampersand in correct format for XML casting
SET @QUERYDEFINITIONXML = CAST(@QUERYDEFINITION as XML);
SET @SQL = REPLACE(@SQL,'27beb1b6-f3ec-40ae-b22d-b89888f92ae7',cast(@EVENTID as nvarchar(40)));
BEGIN TRAN
begin try
-- Create Query
EXEC dbo.USP_ADHOCQUERY_CREATEORUPDATEDEFINITION @ID = @ADHOCQUERYID,@QUERYVIEWCATALOGID='EE8A7483-C483-4214-9646-4BB62EC29AB7',
@NAME = @QUERYNAME,@DESCRIPTION=N'',@QUERYDEFINITIONXML = @QUERYDEFINITIONXML, @QUERYCATEGORYCODEID='00000000-0000-0000-0000-000000000000',
@DATAFORMINSTANCEID='00000000-0000-0000-0000-000000000000',@OTHERSCANMODIFY=1,@APPUSERID = @APPUSERID, @CHANGEAGENTID = @CHANGEAGENTID,
@SITEID=NULL,@FOLDERID='00000000-0000-0000-0000-000000000000',@SECURITYLEVEL=0,@PERMISSIONEDROLES=@ROLEPERMISSION,
@SECURITYLEVELEDIT=1,@PERMISSIONEDROLESEDIT=@ROLEPERMISSION,@MOBILIZE=0,@ISFAVORITE=0;
EXEC dbo.USP_ADHOCQUERY_CREATEORUPDATEIDSET @ADHOCQUERYID = @ADHOCQUERYID,@SQLWITHCLAUSE=N'',@SQL = @SQL,@USEINQUERYDESIGNER=0,@STATIC=0,
@NUMROWS=NULL,@CHANGEAGENTID=@CHANGEAGENTID,@IDSETREGISTERID = @IDSETREGISTERID, @IDSETFUNCTIONNAME = @IDSETFUNCTIONNAME;
-- Create List based on query
SELECT @BBNCQUERYID = ID FROM dbo.BBNCIDSETIDMAP (NOLOCK) WHERE IDSETREGISTERID = @IDSETREGISTERID;
set @BBNCQUERYNAME = REPLACE(@BBNCQUERYNAME, '&','&')
set @BBNCQUERYNAME = REPLACE(@BBNCQUERYNAME, '&', '&')
SET @EMAILLISTQUERY = '<root><QueryList QueryID="'+CAST(@BBNCQUERYID as nvarchar(25))+'" QueryName="'+@BBNCQUERYNAME+'" BBSystem="0" /></root>';
EXEC dbo.spAddUpdate_EmailList @UserID=@Userid,@ClientsID=@ClientsID,@PKID=@EMAILLISTID output ,@Name=@QUERYNAME, @Description=N'',@Subscription=0,
@QueryXML=@EMAILLISTQUERY,@Guid=@EMAILLISTGUID output, @Type=0,@DataSourceID=320,@Options=N'',@AcquiredStatus=0,@AcquiredDate=@DATEADDED,
@AcquiredMsg=N'',@AcquiredStartDate=@DATEADDED, @AcquiredRecordCount=0,@EmailDisplayNameFieldName=N'',@EmailAddressFieldName=N'',
@UniqueKeyFieldName=N'',@UploadFileName=N'',@UploadFileSize=0,@UploadedDataSourceID=0,@ListDataSchema=N'',
@FileContents=0x00,@Origin=2,@UserImportID=0,@BBDMListID=N'',@SystemList=0,@CLIENTSITESID=@CLIENTSITESID;
INSERT INTO dbo.FAFEVENTADHOCQUERY(ID,EVENTID,ADHOCQUERYID,ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
VALUES(NEWID(),@ORIGINALEVENTID,@ADHOCQUERYID,@CHANGEAGENTID, @CHANGEAGENTID, @DATEADDED, @DATEADDED)
end try
begin catch
exec dbo.USP_RAISE_ERROR;
ROLLBACK TRAN
return 1;
end catch
COMMIT TRAN
return 0;