• Replies 5 replies
  • Subscribers 338 subscribers
  • Views 64 views
  • Users 0 members are here
Related

About Output Sets

Vicky Wenhan Yu
$organization

Hello,

Would it be possible to add the area from TR_GEO_AREA to Output Sets?

Any suggestions...

Thank you very much in advance.

Vicky

Parents
  • $organization

    I tried to add a new output element in tr_quesry_element. The problem is in the column Data From – The table or view name from which the data is pulled must contain a column called customer_no.  I want  to pull data from tr_geo_area, which doesn’t have customer_no.

    I use Description as Data select , and (select * from t_address  a  JOIN tr_geo_area b ON a. geo_area = b.id) as Data From in tr_quesry_element

    When I execute an Output Set report(located in the Lists and Output Sets report folder), I would get an error message…

    Any suggestions. …

    Thank you very much in advance



    [edited by: Vicky Wenhan Yu at 3:58 PM (GMT -6) on 11 Dec 2009]
  • $organization in reply to Vicky Wenhan Yu

    -------

     

     

     



    [edited by: Vicky Wenhan Yu at 9:14 (GMT -6) on 6 Jan 2010]
  • $organization in reply to Vicky Wenhan Yu

    Make sure the “single_row” column in TR_QUERY_ELEMENT is unchecked for the element row.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Vicky Wenhan Yu
    Sent: Wednesday, January 06, 2010 10:02 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] About Output Sets

     

    I made a few changes to my script, now it works.

    There are potentially multiple values returned, one for each address on the record. Usually these are marked with an asterisk (*) in the menu.

    But I don't know how to add an asterisk beside the new output element I created.

    Any suggestions ....  

    Thank you very much in advance

     

     

     

    From: Vicky Wenhan Yu <bounce-vickywenhanyu1681@tessituranetwork.com>
    Sent: 12/11/2009 1:52:52 PM

    I tried to add a new output element in tr_quesry_element. The problem is in the column Data From – The table or view name from which the data is pulled must contain a column called customer_no.  I want  to pull data from tr_geo_area, which doesn’t have customer_no.

    I use Description as Data select , and (select * from t_address  a  JOIN tr_geo_area b ON a. geo_area = b.id) as Data From in tr_quesry_element

    When I execute an Output Set report(located in the Lists and Output Sets report folder), I would get an error message…

    Any suggestions. …

    Thank you very much in advance




    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!

Reply
  • $organization in reply to Vicky Wenhan Yu

    Make sure the “single_row” column in TR_QUERY_ELEMENT is unchecked for the element row.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Vicky Wenhan Yu
    Sent: Wednesday, January 06, 2010 10:02 AM
    To: Ryan Creps
    Subject: Re: [Tessitura Technical Forum] About Output Sets

     

    I made a few changes to my script, now it works.

    There are potentially multiple values returned, one for each address on the record. Usually these are marked with an asterisk (*) in the menu.

    But I don't know how to add an asterisk beside the new output element I created.

    Any suggestions ....  

    Thank you very much in advance

     

     

     

    From: Vicky Wenhan Yu <bounce-vickywenhanyu1681@tessituranetwork.com>
    Sent: 12/11/2009 1:52:52 PM

    I tried to add a new output element in tr_quesry_element. The problem is in the column Data From – The table or view name from which the data is pulled must contain a column called customer_no.  I want  to pull data from tr_geo_area, which doesn’t have customer_no.

    I use Description as Data select , and (select * from t_address  a  JOIN tr_geo_area b ON a. geo_area = b.id) as Data From in tr_quesry_element

    When I execute an Output Set report(located in the Lists and Output Sets report folder), I would get an error message…

    Any suggestions. …

    Thank you very much in advance




    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!

Children
No Data