research notes and output set builder

Hi everyone,

I’m trying to create an output set element called ‘Research tab notes’ with a parameter of note type.  I set up the parameter just fine and was able to construct my output set, but am running into an error with the element.  When I try to execute the output set I get an error stating “the multi-part identifier c.id could not be bound.”  Here’s how I’ve created the element:

Data select:  !.notes

Data from:   (select a.notes, b.customer_no from tx_cust_notes_ext a JOIN tx_cust_notes b ON a.cust_notes_no=b.cust_notes_no JOIN tr_cust_notes_type c ON b.note_type=c.id)

Data where:  c.id in (<<p4>>)

(c.id being my element parameter of note type, pulled from tr_cust_notes_type)

Does anyone have any suggestions? 

Cheers,
Kathleen

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!

Hi everyone,

I’m trying to create an output set element called ‘Research tab notes’ with a parameter of note type.  I set up the parameter just fine and was able to construct my output set, but am running into an error with the element.  When I try to execute the output set I get an error stating “the multi-part identifier c.id could not be bound.”  Here’s how I’ve created the element:

Data select:  !.notes

Data from:   (select a.notes, b.customer_no from tx_cust_notes_ext a JOIN tx_cust_notes b ON a.cust_notes_no=b.cust_notes_no JOIN tr_cust_notes_type c ON b.note_type=c.id)

Data where:  c.id in (<<p4>>)

(c.id being my element parameter of note type, pulled from tr_cust_notes_type)

Does anyone have any suggestions? 

Cheers,
Kathleen

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!