Worrisome worker wequests

Hello Matt,

Perhaps this can help you. To get all tables which have columns like WORKER and PLAN, ran the SQL in impresario DB:

select

sysobjects.name tbl_name,

syscolumns.name col_name

from syscolumns , sysobjects

where syscolumns.id=sysobjects.id

and sysobjects.type='U' --user tables

and syscolumns.name like '%plan%'----------'%worker%'

Thanks,

Simon

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Wednesday, September 16, 2015 6:42 PM
To: Basyuk, Simon
Subject: [Tessitura Technical Forum] Worrisome worker wequests

When looking at Plan Details I can see the Primary Worker for a given plan. Where can I find the table that connects workers to plans and the assumed column labled Primary_worker or some such name that designates said worker for that role?

I ask this because I've been given a request to write a stored procedure that would change the Primary Worker to whatever name is designated in the attribute "Portfolio Owner", and I can't seem to find the specific table that holds that information so that I can "get all algorithmic on it".

Am I going about this wrong? Is there such a table? Who wrote the book of love? What's love got to do, got to do with it?

Thanks in advance, Tessiturians.

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!

Hello Matt,

Perhaps this can help you. To get all tables which have columns like WORKER and PLAN, ran the SQL in impresario DB:

select

sysobjects.name tbl_name,

syscolumns.name col_name

from syscolumns , sysobjects

where syscolumns.id=sysobjects.id

and sysobjects.type='U' --user tables

and syscolumns.name like '%plan%'----------'%worker%'

Thanks,

Simon

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Gonzales
Sent: Wednesday, September 16, 2015 6:42 PM
To: Basyuk, Simon
Subject: [Tessitura Technical Forum] Worrisome worker wequests

When looking at Plan Details I can see the Primary Worker for a given plan. Where can I find the table that connects workers to plans and the assumed column labled Primary_worker or some such name that designates said worker for that role?

I ask this because I've been given a request to write a stored procedure that would change the Primary Worker to whatever name is designated in the attribute "Portfolio Owner", and I can't seem to find the specific table that holds that information so that I can "get all algorithmic on it".

Am I going about this wrong? Is there such a table? Who wrote the book of love? What's love got to do, got to do with it?

Thanks in advance, Tessiturians.

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!