Hi all,
I am just wondering about the content that that can be assigned to Titles/Productions/Seasons/Performances, under the 'Content' tab - TN_Express_Title, etc.
Where is all of that content stored in the Database? I've had a poke around and can't find it anywhere.
I want to create a procedure that can copy that content from one performance to another, across the financial year.
Thanks!,Daniel.
And now that I've asked, I've found it - LV_LIST_INV_CONTENT
Thanks all.
Hi Daniel
TR_INV_CONTENT holds the content Types, and TX_INV_CONTENT holds the values
Try this:
SELECT TOP 1000 c.[id]
,c.[inv_no]
,c.[content_type]
, ic.description type_desc
,c.[value]
,c.[created_by]
,c.[create_dt]
,c.[create_loc]
,c.[last_updated_by]
,c.[last_update_dt]
FROM [impresario].[dbo].[TX_INV_CONTENT] c
JOIN impresario.dbo.TR_INV_CONTENT AS ic ON c.content_type = ic.id
ORDER BY c.last_update_dt desc
Ken
ah, of course - I found the view, not the underlying content.
That's great, thanks! I'll report back with how I go.