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

ON ACCOUNT TRACKING REPORT

Revanth Anne
$organization

Hi ,

I am planning to add source channel to this report.

I jus want the data from tr_sales_channel to be linked to know whether its from phone room or telesales.

I don't want to add the source name,not from tx_appeal_media_type where I can get the source from(not neccesary).

Can this be possible.....

Kindly let me know your suggestionss....

 

Parents
  • $organization

    Hi,

    Did anyone get a chance to look at this...

    Kindly let me know........

     

  • $organization in reply to Revanth Anne
    Hi Revanth Anne,

    Is this what you are looking for?

    select * from t_order a 
    join tr_order_category b
    on a.class=b.id

    ~Dan

    On Thu, May 7, 2009 at 10:37 AM, Revanth Anne <bounce-revanthanne9441@tessituranetwork.com> wrote:

    Hi,

    Did anyone get a chance to look at this...

    Kindly let me know........

     

    From: Revanth Anne <bounce-revanthanne9441@tessituranetwork.com>
    Sent: 5/6/2009 5:32:55 PM

    Hi ,

    I am planning to add source channel to this report.

    I jus want the data from tr_sales_channel to be linked to know whether its from phone room or telesales.

    I don't want to add the source name,not from tx_appeal_media_type where I can get the source from(not neccesary).

    Can this be possible.....

    Kindly let me know your suggestionss....

     




    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 Revanth Anne
    Hi Revanth Anne,

    Is this what you are looking for?

    select * from t_order a 
    join tr_order_category b
    on a.class=b.id

    ~Dan

    On Thu, May 7, 2009 at 10:37 AM, Revanth Anne <bounce-revanthanne9441@tessituranetwork.com> wrote:

    Hi,

    Did anyone get a chance to look at this...

    Kindly let me know........

     

    From: Revanth Anne <bounce-revanthanne9441@tessituranetwork.com>
    Sent: 5/6/2009 5:32:55 PM

    Hi ,

    I am planning to add source channel to this report.

    I jus want the data from tr_sales_channel to be linked to know whether its from phone room or telesales.

    I don't want to add the source name,not from tx_appeal_media_type where I can get the source from(not neccesary).

    Can this be possible.....

    Kindly let me know your suggestionss....

     




    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
  • $organization in reply to Dan Taraborrelli

    Hi Dan,

    I am looking to add the source channel to on account tracking report.

    but I can't see any tables which is connected to source channel tr_sales_channel.

    Source Number in t_transaction or t_order is the source name from tx_appeal_media_type.

    I am looking for a report that has feild post date,customer no,Name,source channel and amont on account.

    Kindly ,let me know if this is clear.

    will appreciate your help