Can anyone tell me how to tell which extraction a list has come from? We're trying to duplicate some results but I beleive the list that was pulled came from an extraction that was previously built.
I looked at T_List but I'm not seeing anything in there that would give me that information.
Oh no worries – This is just getting more interesting.
I had to create an extraction and save to list for a Marketing email. I checked what that did in the table (makes sense to do that right?). My list number is 38921 and my Keycode ids are 38920 and 38918. Those both point back to my extraction of 2762.
However for this other list number my closest previous keycode id is 36860 which points to extraction 2652 which is a NCOA extraction; not at all related to the list we’re trying to trace. I’m guessing the extraction is one that was built and then used many times with just a slight change of criteria. I’m going to continue to dig on this and maybe drop in a ticket. I’m totally determined to figure this out.
M
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Rachel Schlaff Sent: Wednesday, May 24, 2017 11:25 AM To: Michelle Usadel <musadel@phoenixsymphony.org> Subject: RE: [Tessitura Ticketing Forum] List from specific extraction
I'm sorry about that, Michelle, I was mistaken about the keycode_id. Looking at my database, I believe you can find the extraction by looking at
WHERE keycode_id = 36882
36882 should find the last segment that was extracted before it and the other segment results from the same extraction were compiled and given the id 36883.
Cheers,
Rachel
From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com> Sent: 5/24/2017 5:55:30 PM
Ah - I was looking at the wrong column. I didn’t expand my column or scroll far enough to the right.
I’m still returning no result when I use the list number as an integer and when I scroll through the results, I’m not seeing my list number. What I am seeing as results from the table doesn’t actually line up with the Live environment. I’m going to continue to try to interpret the results. I feel like the answer is going to be knock me on the head when I figure it out, it’s just getting there.
Thanks
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Rachel Schlaff Sent: Wednesday, May 24, 2017 10:08 AM To: Michelle Usadel <musadel@phoenixsymphony.org> Subject: RE: [Tessitura Ticketing Forum] List from specific extraction
Try the WHERE clause with the list_no/keycode_id as an integer rather than a string.
Are you sure the low numbers you're seeing are in the keycode_id column, not the keycode column? To see keycode_id in the results, you probably need to scroll right.
From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com> Sent: 5/24/2017 4:28:51 PM
I hurrahed to soon.
When I pull a simple query on the list in question (36883), it’s returning 0 lines:
Select *
from t_keycode
where keycode_id = '36883'
When I comment out the where statement, I get returns but only low numbers as well as duplicates.
Am I possibly missing something?
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Rachel Schlaff Sent: Wednesday, May 24, 2017 7:12 AM To: Michelle Usadel <musadel@phoenixsymphony.org> Subject: Re: [Tessitura Ticketing Forum] List from specific extraction
Hi Michelle,
You can find that information in your impresario_cci database in the T_KEYCODE table. The keycode_id column holds the list number and the ka_no column holds the extraction number.
From: Michelle Usadel <bounce-michelleusadel3057@tessituranetwork.com> Sent: 5/23/2017 7:04:31 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Try this one in impresario_cci:
select distinct b.ka_nofrom v_LIST a join T_DL_HEADER b on a.create_dt between dateadd(MINUTE,-1,b.dl_dt) and dateadd(MINUTE,+1,b.dl_dt)where a.list_no = 36883