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.
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
M
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.
Cheers,
Rachel
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!
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.