Added
false
Non Members Signing Up for Events
Creates a list of Event Signups for Profiles that are not members. Change the Event Start Date filter to update what date range the report runs for. Also, dropped members may appear on this report even though they were members when they attended the event. Make sure you verify that a Sign Up was not a member at the time of Signing Up.
2016-12-08T10:52:50
tao
40
0
Select
EventList_EventName As 'Event Name', CONVERT(CHAR(10), EventList_EventDate, 101) As 'Event Start Date', EventTypes_EventType As 'Event Type', EventSignUps_OrgName As 'Sign Up Organization Name', EventSignUps_FName As 'Sign Up First Name', EventSignUps_LName As 'Sign Up Last Name', EventSignUps_Email As 'Sign Up Email', EventSignUps_Phone As 'Sign Up Phone', EventSignUps_Profile_View_Profile_Member As 'Sign Up''s Member Checkbox'
From
EventAttendees_View
Where
(EventSignUps_Profile_View_Profile_Member = 0 And EventList_EventDate >= '1/1/2016')
Order By
EventList_EventDate Asc
2016-12-08T10:52:50
EventAttendees_View
false
0
false
Unchanged
false
Daily
1
1
0
0
false
false
2016-12-08T00:00:00-08:00
2016-12-08T00:00:00-08:00
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
false
0
Unchanged
false
0
0
1900-01-01T00:00:00
1900-01-01T00:00:00
0
false
0
false
1900-01-01T00:00:00
1900-01-01T00:00:00
0
0
false
false
Added
false
EventAttendees_View
EventList_EventName
Event Name
System.String
508
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventList_EventDate
Event Start Date
System.DateTime
8
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventTypes_EventType
Event Type
System.String
200
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_OrgName
Sign Up Organization Name
System.String
508
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_FName
Sign Up First Name
System.String
508
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_LName
Sign Up Last Name
System.String
508
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_Email
Sign Up Email
System.String
508
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_Phone
Sign Up Phone
System.String
100
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
StartsWith
Starts With
StartsWith
Added
false
Contains
Contains
Contains
Added
false
DoesNotContain
Does Not Contain
DoesNotContain
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_Profile_View_Profile_Member
Sign Up's Member Checkbox
System.Boolean
1
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventSignUps_Profile_View_Profile_Member
Accept AmEx
System.Boolean
1
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
Added
false
False
false
2012-03-12T00:00:00-07:00
0
0
Ascending
AndJoin
1
Added
false
EventAttendees_View
EventList_EventDate
Accept AmEx
System.DateTime
1
false
GreaterThanOrEqual
Added
false
EqualTo
Equal To
EqualTo
Added
false
NotEqualTo
Not Equal To
NotEqualTo
Added
false
LessThan
Less Than
LessThan
Added
false
LessThanOrEqual
Less Than Or Equal To
LessThanOrEqual
Added
false
GreaterThan
Greater Than
GreaterThan
Added
false
GreaterThanOrEqual
Greater Than Or Equal To
GreaterThanOrEqual
Modified
false
12/8/2016 12:00:00 AM
false
2016-01-01T00:00:00
427
0
Ascending
AndJoin
1
Modified
false
EventAttendees_View
EventList_EventDate
Sign Up's Member Checkbox
System.Boolean
1
false
EqualTo
Added
false
EqualTo
Equal To
EqualTo
true
2016-12-08T00:00:00-08:00
0
0
Ascending
AndJoin
1