quickbooks qbxml result ordering

0
votes

I can't find anything on how quickbooks orders results when querying with qbXML. It seems like at the very least it would be mentioned in this section:

https://developer.intuit.com/app/developer/qbdesktop/docs/develop/exploring-the-quickbooks-desktop-sdk/query-requests-and-responses#using-maxreturned-to-specifying-the-maximum-number-of-objects-returned

For example, in that section it says:

"To continue looking at objects that match the query’s criteria ... if you are dealing with an alphabetized list of customer names, use NameRangeFilter:FromName"

Is this saying that by virtue of using the NameRangeFilter, the results are guaranteed to be ordered by FromName? If I use a ModifiedDateRangeFilter, does that assure that the results are ordered by modified date?

I'm trying to figure out how to know where to pick up from the last time a connector transaction ran, but without knowing how results are ordered it seems like I can't confidently know.

1
quickbooksqbxml

1 Answers

1
votes

There is no way to specify the order of a qbXML result.

If you're trying to fetch a large # of results, use iterators - the purpose of an iterator is specifically so that you can walk through a large result set, and not have to keep track of where you left off -- the iterator does that for you.