• Replies 9 replies
  • Subscribers 247 subscribers
  • Views 66 views
  • Users 0 members are here
Related

XSLT

Marty Jones
$organization

Just found out that I am going to have build my own Email Confirmation template. I do not knowing anything about XSLT and I am currently at w3 Schools website teaching myself about it, my question is, in the sample templates, it appears that all the data comes from //GetOrderDetailsInfoResults/... Is there documentation or somewhere I can go to find out what fields are available in this uh.. data connection thingy?

 

Thanks!

Parents
  • Former Member
    Former Member $organization

    Hi Marty,

    If you have access to the impresario database, you can pull up the stored procedure

    [dbo]

    .[WP_GET_ORDER_DETAILS]

    and that will tell you all the fields that are available. Another good stored procedure to look at is

    [dbo]

    .[WP_GET_ORDER_CONF_DATA]

    Hope this helps.

    Naomi

Reply
  • Former Member
    Former Member $organization

    Hi Marty,

    If you have access to the impresario database, you can pull up the stored procedure

    [dbo]

    .[WP_GET_ORDER_DETAILS]

    and that will tell you all the fields that are available. Another good stored procedure to look at is

    [dbo]

    .[WP_GET_ORDER_CONF_DATA]

    Hope this helps.

    Naomi

Children
  • $organization in reply to Former Member

    Thanks Naomi, I think this is what I am looking for.

     

    Marty Jones

    Database Administrator

     

    Omaha Performing Arts
    1200 Douglas Street

    Omaha, Nebraska 68102

    P 402.661.8469  |  F 402.345.0222    

    majones@omahaperformingarts.org

    www.omahaperformingarts.org

    For tickets, call Ticket Omaha at 402.345.0606

     

    From: Tessitura Web Forum [mailto:forums-tessitura-web@tessituranetwork.com] On Behalf Of Naomi Williams
    Sent: Thursday, September 03, 2009 4:51 PM
    To: Martin A. Jones
    Subject: Re: [Tessitura Web Forum] XSLT

     

    Hi Marty,

    If you have access to the impresario database, you can pull up the stored procedure

    [dbo]

    .[WP_GET_ORDER_DETAILS]

    and that will tell you all the fields that are available. Another good stored procedure to look at is

    [dbo]

    .[WP_GET_ORDER_CONF_DATA]

    Hope this helps.

    Naomi

    From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>
    Sent: 9/3/2009 4:28:08 PM

    Just found out that I am going to have build my own Email Confirmation template. I do not knowing anything about XSLT and I am currently at w3 Schools website teaching myself about it, my question is, in the sample templates, it appears that all the data comes from //GetOrderDetailsInfoResults/... Is there documentation or somewhere I can go to find out what fields are available in this uh.. data connection thingy?

     

    Thanks!




    You were sent this email automatically because you subscribed to the Tessitura Web forum. You may reply to this message to post to the Web 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!