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
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 -- View this message online at http://www.tessituranetwork.com/COMMUNITY/forums/p/6983/22013.aspx#22013 or reply to this message Catherine Goodwin Tessitura Lead Team DATA Harbourfront Centre 235 Queens Quay West Toronto, Ontario M5J 2G8 Office: (416) 973-4085 Fax: (416) 954-0366 cgoodwin@harbourfrontcentre.com www.harbourfrontcentre.com heart of toronto's waterfront Harbourfront Centre A 10-acre public trust powered by the creative cultures of Canada and the world. Check out our official blog.
Cheers, Kathleen