Pulling Constituency withe End Date

Hello Everyone

 

I was able to figure it out.

 

Here’s the situation: I was looking up a constituency for our Ballet School Students. I was attempting to pull our students last year (st dt: whenever / end dt: 5/16/2013) AND a separate list of our current students this year (st dt: 9/3/2013 / end dt: 5/13/2014).

 

So in actuality, the information I was trying to pull is “INACTIVE” as of today (8/29/2013). Last year’s constituency is inactive because the end date has past. The current constituency is inactive because the start date has yet to occur.

 

The “Constituency” list criteria element only pulls “active” constituencies. So when I paired it with my dates, the information I was asking for did not exist.

 

We created a “Constituency – ALL” to include active and inactive constituencies. However, to get accurate results this criterion must be paired with “Constituency Start Date” OR “Constituency End Date.” Otherwise, it will pull all records that have a particular constituency – active or inactive.

 

Thanks everyone for your help – much appreciated,

 

 

 

Beth – You and I are on the same track. I had it on my list of suggestions to talk to my DBA.

 

Thanks,

 

 

Hi Marie!

You can see where your list criteria is pulling it's data from. When you are creating a list, right-click on the criteria element (say, "Constituency") and you'll see the "Detail Table" that it is pulling from.

If the Detail Table is "vxs_const_cust" - it will NOT pull your inactive constituencies - even if it is a constituency in the future! This could be the root of your trouble.

It's my recollection that when we started with Tessitura, we only had one criteria element that referred to this table and only pulled current constituencies. I added three new elements -- Constituency(Archive),Constituency(Archive) Start Dt, Constituency(Archive) End Dt --  so I could pull ANY constituency, whether expired or not. It will probably require the assistance of your DBA and a new secure view -- but it would keep you from doing a lot of list criteria gymnastics to get what you're after.

Help on adding criteria can be found here: http://www.tessituranetwork.com/Help_System/Content/System_Tables/T_KEYWORD.htm

Beth

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!

Hello Everyone

 

I was able to figure it out.

 

Here’s the situation: I was looking up a constituency for our Ballet School Students. I was attempting to pull our students last year (st dt: whenever / end dt: 5/16/2013) AND a separate list of our current students this year (st dt: 9/3/2013 / end dt: 5/13/2014).

 

So in actuality, the information I was trying to pull is “INACTIVE” as of today (8/29/2013). Last year’s constituency is inactive because the end date has past. The current constituency is inactive because the start date has yet to occur.

 

The “Constituency” list criteria element only pulls “active” constituencies. So when I paired it with my dates, the information I was asking for did not exist.

 

We created a “Constituency – ALL” to include active and inactive constituencies. However, to get accurate results this criterion must be paired with “Constituency Start Date” OR “Constituency End Date.” Otherwise, it will pull all records that have a particular constituency – active or inactive.

 

Thanks everyone for your help – much appreciated,

 

 

 

Beth – You and I are on the same track. I had it on my list of suggestions to talk to my DBA.

 

Thanks,

 

 

Hi Marie!

You can see where your list criteria is pulling it's data from. When you are creating a list, right-click on the criteria element (say, "Constituency") and you'll see the "Detail Table" that it is pulling from.

If the Detail Table is "vxs_const_cust" - it will NOT pull your inactive constituencies - even if it is a constituency in the future! This could be the root of your trouble.

It's my recollection that when we started with Tessitura, we only had one criteria element that referred to this table and only pulled current constituencies. I added three new elements -- Constituency(Archive),Constituency(Archive) Start Dt, Constituency(Archive) End Dt --  so I could pull ANY constituency, whether expired or not. It will probably require the assistance of your DBA and a new secure view -- but it would keep you from doing a lot of list criteria gymnastics to get what you're after.

Help on adding criteria can be found here: http://www.tessituranetwork.com/Help_System/Content/System_Tables/T_KEYWORD.htm

Beth

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!