Greetings,
I have a output set consisting of a Constituency End Date that is looking for a NULL value. I have set up the fields where the data select is !.end_dt looking at the view VXS_CONST_CUST. The where area is defined as:
constituency = <<p4>> and end_dt is null
The output set has this and nothing else. A search HH is checked. I receive an error message that states:
The columns constituency and end_dt are ambiguous. I was peering into RP_RUNQUERY and noticed that there is only one table alias allowed for the work table, hence the error. Has anyone worked out the solution to something like this?
Troy – glad that fixed it.
They are probably pre-v11 ones as !. was not required in the Where clause for Single Row elements.
With the introduction of the Household model and the ability to Search Households aliasing was then required for the where clause, but only for Single Row elements where the data_select field is not an aggregated result ie is not a MAX(), MIN(), COUNT() , SUM() etc
If you are unsure – try the element out before you change it.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Troy Nelson Sent: Thursday, 27 June 2013 12:35 AM To: Sandra Ashby Subject: RE: [Tessitura Technical Forum] Ambiguous column name in Output Set Report
Yes! That did it. The funny thing is that 90% of the TR_QUERY_ELEMENT parameters do not use the alias in the where clause. It looks like some house cleaning is in order. Thanks for the solution Sandra.
From: Troy Nelson <bounce-troynelson3148@tessituranetwork.com> Sent: 6/26/2013 9:17:19 AM
I will try that.
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!