• Replies 5 replies
  • Subscribers 336 subscribers
  • Views 21 views
  • Users 0 members are here
Related

System Tables: Artists ID

Randall Mitchell
$organization

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

  • $organization

    t_artist

    column is called art_no

  • $organization

    I don’t know if this is what you’re looking for: T_ARTIST.art_no

     

    Lucie

  • Former Member
    Former Member $organization
    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!
  • $organization 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...

  • Former Member
    Former Member $organization 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