2000000000 f762e3a9-e4c5-4e4a-9a9e-28a3320930b4 *Group Members - Same Day Reminder Text to Hybrid This recipient group can be used to send automated reminder texts to group members of In-Person-only events, the day of the event. Schedule texts with this recipient group to run between 4am and 6am every day Connect4 Support true false <Query QueryName="" QueryGUID="9fadbaaf-9071-431c-b9a3-3d9eb976d0db" SchemaGUID="f762e3a9-e4c5-4e4a-9a9e-28a3320930b4" SchemaVer="143"> <Properties /> <Top>All</Top> <ResultGrouping>1</ResultGrouping> <Select> <ReturnField> <FieldName>Person.TPhoneMobile</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>0</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Registrations.IsGroupMember</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>1</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.EPrimaryEmailAddress</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>2</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.FullFormalName</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>3</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Person.PID</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>4</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> <ReturnField> <FieldName>Events.EVName</FieldName> <AggregationType>0</AggregationType> <ReturnSetOrder>5</ReturnSetOrder> <ReturnSetSortOrder>-1</ReturnSetSortOrder> <ReturnSortDirection>0</ReturnSortDirection> </ReturnField> </Select> <Where> <ConditionGroup GroupName="baseGroup" Behavior="0"> <Condition> <ComparisonFieldName>EventInstance.EVIStartEventZone_fixed</ComparisonFieldName> <ComparisonTypeName>is between</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues> <ConditionValue>00:01:00</ConditionValue> <ConditionValue>18:00:00</ConditionValue> </ConditionValues> <ValueSourceType>2</ValueSourceType> <ValueSourceTitle>9a9c9c8b-1b96-4c4d-a15c-33e110fccb05</ValueSourceTitle> <ValueProviderGUID>9a9c9c8b-1b96-4c4d-a15c-33e110fccb05</ValueProviderGUID> <DisplayConditionValues> <DisplayConditionValue>Run Time Plus 00:01</DisplayConditionValue> <DisplayConditionValue>Run Time Plus 18:00</DisplayConditionValue> </DisplayConditionValues> </Condition> <Condition> <ComparisonFieldName>EventInstance.EVICanceled</ComparisonFieldName> <ComparisonTypeName>is false</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Registrations.REIDRegCategory</ComparisonFieldName> <ComparisonTypeName>is null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>Person.TPhoneMobile</ComparisonFieldName> <ComparisonTypeName>is not null</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> <Condition> <ComparisonFieldName>EventInstance.HasOnlineMeeting</ComparisonFieldName> <ComparisonTypeName>is true</ComparisonTypeName> <AggregationType>0</AggregationType> <ConditionValues /> <ValueSourceType>0</ValueSourceType> <ValueSourceTitle /> <DisplayConditionValues /> </Condition> </ConditionGroup> </Where> </Query> SELECT DISTINCT Events.EVName AS Event_Name, Person.PID AS Person_ID, (LTrim(ISNull(PTitle,'') + ' ' + IsNull(PFirstName,'') + ' ' + LTrim(IsNull(PMidName,'') + ' ' + IsNull(PLastName,''))) + RTrim(' ' + IsNull(PSuffix,''))) AS Full_Formal_Name, Person.EPrimaryEmailAddress AS Primary_Email_Address, Registrations.IsGroupMember AS Is_Group_Member, Person.TPhoneMobile AS Phone_Mobile FROM dbo.v1_Personv2 Person RIGHT OUTER JOIN dbo.vs104_RegistrationsPlusMembers Registrations ON Registrations.PID = Person.PID LEFT OUTER JOIN ( SELECT [EVIID] ,[tbl104_EventInstance].[EVID] ,[EVIStart_fixed] ,[EVIStartEventZone_fixed] ,[EVIOriginalStart] ,[EVICanceled] ,[EVINotes] ,[EVIMediaBaseUrl] ,[EVIUserModified] ,IsNull(EVIOnlineMeetingNumber, tbl2_OnlineMeeting.OMNumber) AS OnlineMeetingNumber ,IsNull(EVIOnlineMeetingPassword, tbl2_OnlineMeeting.OMPassword) AS OnlineMeetingPassword ,OMAccountName AS OnlineMeetingAccount ,OMKeepID AS SameOnlineIDForAll ,Cast(Case when tbl2_OnlineMeeting.OMID is null then 0 else 1 end as bit) as HasOnlineMeeting FROM [tbl104_EventInstance] INNER JOIN tbl104_Events ON [tbl104_EventInstance].EVID = tbl104_Events.EVID LEFT OUTER JOIN tbl2_OnlineMeeting ON tbl104_Events.EVID = tbl2_OnlineMeeting.EVID ) EventInstance ON Registrations.EVIID = EventInstance.EVIID RIGHT OUTER JOIN dbo.tbl104_Events Events ON Events.EVID = EventInstance.EVID WHERE EventInstance.EVIStartEventZone_fixed between cast('2021-06-08 09:59:32' as datetime) and cast('2021-06-09 03:58:32' as datetime) AND EventInstance.EVICanceled = 0 AND Registrations.REIDRegCategory is Null AND Person.TPhoneMobile is not Null AND EventInstance.HasOnlineMeeting = 1 OPTION (USE HINT ('FORCE_LEGACY_CARDINALITY_ESTIMATION')); false 2021-06-08T04:56:13 2021-06-08T04:56:13 1000 Connect4 Support 2602 Event Registration Administration false 2000000000 1017 Same Day Reminder Text - Group Members to Hyrbid Event Test Text Message 2 EventInstance.EVIStartEventZone_fixed,Events.EVName,Person.TPhoneMobile,Person.PPrefName,EventInstance.OnlineMeetingPassword,Events.EVLocation DESKTOP-A3CPLGV Connect4 Support 2 false 2021-06-16T22:31:26 false false 2021-06-08T09:54:13 2021-06-16T22:31:32 1000 Connect4 Support 2 true true 2000000000 1169 _______ Event Reminder: «EventInstance.Event_Start_Local_Time»: «Events.Event_Name» «Events.EVLocation» If you are not well or no longer comfortable attending in person, or have been in contact with someone who has tested positive for COVID, you may still attend via Zoom! Zoom Link: «@ShortenURL("«ZoomMeetingURL»",autoauth)» Password: «EventInstance.Online_Meeting_Password» From a send-only number. STOP to opt-out. 1016 1016 false false false false 2021-06-08T09:54:13 2021-06-08T09:54:13 1000 Connect4 Support 2000000000 2000000000 <__SourceCommsTypes> 1015 E-Mail Message EmailMergeEngine 3.1 Connect4.Framework.Email.dll,Connect4.Framework.Email.cEmailEngine Email 1016 1018 0 1 2 EPrimaryEmailAddress,PID,EIDPrimary,PFirstName|First_Name,PLastName|Last_Name false true true true false false false false true 30 <__SourceCommsTypes> 1020 MSWord Mail-Merge MSWordMerge 3.3 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cMSWordEngine Hardcopy 0 0 1021 2 3 AIDPrimary,HID true true false true false true false false false 30 <__SourceCommsTypes> 1168 Mail File Generation MailFileGeneration 3.9 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cExportFileEngine Postal Mail 0 2 AIDPrimary,HID false true false true false false false false true 30 <__SourceCommsTypes> 1169 SMS Text Message SMSTextMessage 3.11 Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cSMSTextEngine SMS Text Msg. 1016 3 PID,TIDPhoneMobile,TPhoneMobile,THasSMS,TSMSDenied false true true true false false false false false 30 <__SourceCommsTypes> 1174 Gnosis Report Design GREPMergeEngine 3.13 Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cGREPMergeEngine 1173 0 0 2 AIDPrimary,HID false true true true false false false false false 30 <__SourceCommsTypes> 1265 RTF Mail-Merge RTFMerge 3.15 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cRTFMergeEngine HardCopy 1263 0 0 2 AIDPrimary,HID false true false true false false false false false 30 <__SourceCommsTypes> 1272 Envelopes (Gnosis Rep Design) GREPEnvelopes 3.13 Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.dll,Connect4.Framework.Plugins.CommsEngines.AdditionalCommsEngines.cGREPMergeEngine N/A 1173 0 0 2 AIDPrimary,HID false true true true false false false false false 30 <__SourceCommsTypes> 1276 Envelopes (for RTF Mail-Merge) RTFEnvelopes 3.15 CommsModule.dll,Connect4.Framework.Plugins.CommsModule.cRTFMergeEngine N/A 1263 0 0 2 AIDPrimary,HID false true false true false false false false false 30 <__SourceCommsDataTypes> 1016 8 Plain Text txt 3 <__SourceCommsDataTypes> 1018 8 HTML htm txt 3 <__SourceCommsDataTypes> 1021 8 MS Word Document doc 3 <__SourceCommsDataTypes> 1173 8 Gnosis Report Format repx 3 <__SourceCommsDataTypes> 1263 8 RTF rtf txt 3 <__SourceCommsDataTypes> 1454 8 Beefree The beefree/pro/plugin json format (template) that the html is built from beeJSON