Query by range i.e. id=from-to or order_date from=2014-10-01

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • QuickBooksDev
    Junior Blueparker
    • Oct 2014
    • 15

    #1

    Query by range i.e. id=from-to or order_date from=2014-10-01

    If we want to get a range of orders by date or number is there a way of doing this besides doing every possible one within that range.

    i.e. I want to retrieve all orders from October 1, 2014 or all orders ids from 100 to 200.

    Is there a way of doing this in a single query like most other ecommerce systems have?

    Thanks
    Jack
    www.AaaTeX.com
    QuickBooks Add-ons and custom programming
  • Red Devil
    Senior Blueparker
    • Oct 2009
    • 2569

    #2
    Can't say I've studied this in detail but as a starting point I would look at

    order_date_min / order_date_max
    https://www.hopevmselainesdogs.com/

    Comment

    • QuickBooksDev
      Junior Blueparker
      • Oct 2014
      • 15

      #3
      Thanks

      So there is an order date range but NOT an id or order_number, etc.
      www.AaaTeX.com
      QuickBooks Add-ons and custom programming

      Comment

      Working...