Counting Elevated Events Attended

Hi Kevin,

Thanks for the extra advice.

I was trying for ages to add something to the WHERE column to enable date selecting in the output set, but couldn’t work out for ages why it kept crashing out.

Then I noticed the lv_elevated_events view was being used by other lines in the query element table, so replaced tx_event_extract with that and then tried num_attendees >=1 and event_dt between <<p1>> and <<p2>>.

Then I select the dates, and executed the set and it seems to be working as desired.

Unless I’m missing something glaringly obvious? I’ll also look into getting your other suggestion implemented too! I’m assumed that as lv_elevated_events view exists already I can skip that and proceed to adding the List Criteria?

Kyle Johnson

Database Coordinator

Development Department

Glad to hear it!

For the date range, this is what your list should be in that case.  If you want users to be able to enter a date range, here are steps.

Run this script in SQL (you might have to ask your IT admin) - this creates a view called LV_ELEVATED EVENTS  (a view is like a table that can potentially look at filtered data or, in this case, joins two or more tables together as one).  'Select' access needs to be granted to ImpUsers in permssions.

********************************************

USE [impresario]

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE view [dbo].[LV_ELEVATED_EVENTS] AS

select a.*, VS_CAMPAIGN.event_dt from TX_EVENT_EXTRACT a

join VS_CAMPAIGN

on a.campaign_no = VS_CAMPAIGN.campaign_no

GO

*************************************************

Now you have this view, you can use it to create a List Manager criteria element, here are values you can enter in T_KEYWORD:

Description: Elevated Events - Dates

Data Type: Date

Edit Mask: Date

Detail Tbl: lv_elevated_events (the view created above)

Detail Col: !.event_dt

Category: (Select the appropriate Category)

Use for List: List Only

Create your list on the date range you need using the Between Operator then run the output set on it

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Hi Kevin,

Thanks for the extra advice.

I was trying for ages to add something to the WHERE column to enable date selecting in the output set, but couldn’t work out for ages why it kept crashing out.

Then I noticed the lv_elevated_events view was being used by other lines in the query element table, so replaced tx_event_extract with that and then tried num_attendees >=1 and event_dt between <<p1>> and <<p2>>.

Then I select the dates, and executed the set and it seems to be working as desired.

Unless I’m missing something glaringly obvious? I’ll also look into getting your other suggestion implemented too! I’m assumed that as lv_elevated_events view exists already I can skip that and proceed to adding the List Criteria?

Kyle Johnson

Database Coordinator

Development Department

Glad to hear it!

For the date range, this is what your list should be in that case.  If you want users to be able to enter a date range, here are steps.

Run this script in SQL (you might have to ask your IT admin) - this creates a view called LV_ELEVATED EVENTS  (a view is like a table that can potentially look at filtered data or, in this case, joins two or more tables together as one).  'Select' access needs to be granted to ImpUsers in permssions.

********************************************

USE [impresario]

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE view [dbo].[LV_ELEVATED_EVENTS] AS

select a.*, VS_CAMPAIGN.event_dt from TX_EVENT_EXTRACT a

join VS_CAMPAIGN

on a.campaign_no = VS_CAMPAIGN.campaign_no

GO

*************************************************

Now you have this view, you can use it to create a List Manager criteria element, here are values you can enter in T_KEYWORD:

Description: Elevated Events - Dates

Data Type: Date

Edit Mask: Date

Detail Tbl: lv_elevated_events (the view created above)

Detail Col: !.event_dt

Category: (Select the appropriate Category)

Use for List: List Only

Create your list on the date range you need using the Between Operator then run the output set on it

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!