Forums

Administration & IT System Tables: Artists ID

System Tables: Artists ID

Randall Mitchell $organization over 15 years ago

I realize this is fairly simple, but where do I locate the artists ID? Which table(s) do they live in? Thanks

Parents

Former Member $organization over 15 years ago

T_ARTIST.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Randall Mitchell
Sent: Thursday, June 24, 2010 6:21 PM
To: Robert Bell
Subject: [Tessitura Technical Forum] System Tables: Artists ID

I realize this is fairly simple, but where do I locate the artists ID? Which table(s) do they live in? Thanks

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Former Member $organization over 15 years ago

T_ARTIST.

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Randall Mitchell
Sent: Thursday, June 24, 2010 6:21 PM
To: Robert Bell
Subject: [Tessitura Technical Forum] System Tables: Artists ID

I realize this is fairly simple, but where do I locate the artists ID? Which table(s) do they live in? Thanks

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Randall Mitchell $organization over 15 years ago in reply to Former Member

Ah - got it. Are the Artist's ID not "viewable" through the front end of Tessi? Is there anywhere int eh app that will display the ID number of hte artist without going into SQL? I dont see T_Artist in the "System Tables" list...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Former Member $organization over 15 years ago in reply to Randall Mitchell

Hi Randall

In general (with a few exceptions) , T_* tables don't appear in System Tables, just TR_* tables (and LTR_* tables, of course).

But if you really want to have those id numbers visible in the app, you could add T_ARTIST into System Tables yourself, using T_REFERENCE_TABLES. Best to just give Read-Only access, though.

Ken
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel