Transaction Date List Criteria

Former Member
Former Member $organization

Hello,

I'm a bit new to list criteria creation, and I am trying to add criteria for transaction date.  However, everything I've tried so far gives me an 'invalid column name: customer_no' error when I try to save a list.  Is there anyone who has built something similar that could help walk me through it?

Thanks!

Michael

  • Michael you need to use a table that contains a customer_no field - otherwise there is no way to link it to the customers you want. If that is the case that you don't have the customer_no included, then you can make a view that joins to the appropriates tables and you can base your criteria upon the view.

    Cheers
    Sandra

    Sandra Ashby

    Application Specialist & Support
    Tessitura Network Inc, Asia Pacific

    sashby@tessituranetwork.com

    ________________________________

    From: Tessitura Ticketing Forum on behalf of Michael Ferrari
    Sent: Sat 06-Nov-10 4:56 AM
    To: Sandra Ashby
    Subject: [Tessitura Ticketing Forum] Transaction Date List Criteria



    Hello,

    I'm a bit new to list criteria creation, and I am trying to add criteria for transaction date. However, everything I've tried so far gives me an 'invalid column name: customer_no' error when I try to save a list. Is there anyone who has built something similar that could help walk me through it?

    Thanks!

    Michael




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!