Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.
Home Blogs Forums Photos Downloads
Forums » Product Forums » The Patron Edge » Order Type Details

Order Type Details

Last post 02-19-2009 6:46 PM by Nicholai Burton. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 02-11-2009 12:29 PM

    • John Bobnick
    • Not Ranked
    • Posts 1
    • Organization: National Baseball Hall of Fame

    Order Type Details

    Reply Contact

    I am going to start using Order Type Details to capture e-mail address' at our Admissions Booth. We are a General Admission museum, so we do not associate an order with a client. There is no canned report to get get this information. I know it is being stored in the Orders table in SQL. Does anyone know how I can pull this information out from the backend? I would like to pull by date and the specific Order Type Detail that I create. Any help would be greatly appreciated. Thanks.

    John

  • 02-19-2009 6:46 PM In reply to

    • Nicholai Burton
    • Top 75 Contributor
    • User Since: 2004
    • Posts 84
    • Organization: Blackbaud, Inc.
    • Products:  The Patron Edge, The Raiser's Edge

    Re: Order Type Details

    Reply Contact

    Hey John,

    If you are capturing it on the transaction level (as opposed to the ticket level with different sets of details based on price type), this query should get you started:

    select *
    from Orders
    where ordOpenDate between 'date1here' and 'date2here'

     

    Nicholai

    Filed under:
Page 1 of 1 (2 items)