Can't order result about xeroizer

[waynerobinson]

The values for order should be the same as the attribute names in the actual API at the moment unfortunately.

So what you're probably looking for is:

xero_connection.Account.all(order: "Name")

[bpinto]

I had tried that but it doesn't work:

account.xero_connection.Account.all(order: "Name").map(&:name)
=> ["Business Bank Account",
 "Business Savings Account",
 "Sales",
 "Other Revenue",
 "Interest Income",
 "Purchases",
 "Advertising",
 "Bank Fees",
 "Cleaning",
 "Consulting & Accounting",
 "Depreciation",

I could only make it work when I changed the gem to use order instead of orderBy.

[waynerobinson]

I'm not sure what the issue is at your end. The Gem doesn't make use of orderBy. The code for the ordering is in lib/xeroizer/record/base_model_http_proxy.rb

My version of the test code returns accounts in the correct order:

Xero = Xeroizer::PrivateApplication.new(ACCESS_KEY, ACCESS_SECRET, XERO_PRIVATE_KEY)
accounts = Xero.Account.all(order: "Name")
ap accounts.map(&:name)

Returns:

[
    [ 0] "Accounts Payable",
    [ 1] "Accounts Receivable",
    [ 2] "Accrued Liabilities",
    [ 3] "Advertising",
    [ 4] "Bank Fees",
    [ 5] "Bank Revaluations",
    [ 6] "Business Bank Account",
    [ 7] "Business Savings Account",
    [ 8] "Cleaning",
    [ 9] "Clearing Account",
    [10] "Commission",
    [11] "Computer Equipment",
    [12] "Consulting & Accounting",
    [13] "Depreciation",
    [14] "Entertainment",
    [15] "Freight & Courier",
    [16] "General Expenses",
    [17] "GST",
    [18] "Historical Adjustment",
    [19] "Income Tax Expense",
    [20] "Income Tax Payable",
    [21] "Insurance",
    [22] "Interest Expense",
    [23] "Interest Income",
    [24] "Legal expenses",
    [25] "Less Accumulated Depreciation on Computer Equipment",
    [26] "Less Accumulated Depreciation on Office Equipment",
    [27] "Light, Power, Heating",
    [28] "Loan",
    [29] "Motor Vehicle Expenses",
    [30] "Office Equipment",
    [31] "Office Expenses",
    [32] "Other Revenue",
    [33] "Owner A Drawings",
    [34] "Owner A Funds Introduced",
    [35] "Owner A Share Capital",
    [36] "PAYG Withholdings Payable",
    [37] "Prepayments",
    [38] "Printing & Stationery",
    [39] "Purchases",
    [40] "Realised Currency Gains",
    [41] "Rent",
    [42] "Repairs and Maintenance",
    [43] "Retained Earnings",
    [44] "Revenue Received in Advance",
    [45] "Rounding",
    [46] "Sales",
    [47] "Subscriptions",
    [48] "Superannuation",
    [49] "Superannuation Payable",
    [50] "Suspense",
    [51] "Telephone & Internet",
    [52] "Tracking Transfers",
    [53] "Travel - International",
    [54] "Travel - National",
    [55] "Unpaid Expense Claims",
    [56] "Unrealised Currency Gains",
    [57] "Wage Payables",
    [58] "Wages and Salaries"
]

[waynerobinson]

Ahh, but my code is currently using the HEAD version of Xeroizer.

[waynerobinson]

I have bumped the Gem version with all the latest patches in it. If you update Xeroizer to 2.5.15 then this issue should be fixed.

[bpinto]

Oh thanks!