• Was this page helpful?
Intuit Blog
|
Support
GoPayment
|
Payroll
|
QuickBooks Online
|
QuickBooks
|
Website Services
Intuit
Sign In
Register
Banking Creating & Customizing Forms Importing & Exporting Data Inventory Journal Entries & Accounting Tasks Multicurrency Vendors & Vendor Center Printing in Quickbooks QuickBooks Installation, Update, & Conversion
Customers & Customer Center Reports & Report Center QuickBooks UPS, FedEx Shipping Manager QuickBooks Online Services & Features QuickBooks File, Edit & View Menu Tasks QuickBooks Performance Issues & Program Errors QuickBooks Networking & User Setup
QuickBooks Attached Documents QuickBooks Connect QuickBooks Enterprise Solutions QuickBooks for Mac QuickBooks Online (US) QuickBooks Online Suggestions for Improvement QuickBooks Point of Sale QuickBooks Simple Start Edition QuickBooks Time and Billing Manager Cash Register Plus Customer Manager
Customer Manager & Client Manager Desktop Intuit Commissions Manager Intuit Data Protect Intuit Websites Review Websites and Get Feedback GoPayment Intuit Sync Manager New Intuit Business Tools & Resources Quickbase Quicken Turbotax
Better Because of You Considering Buying QuickBooks? Quickbooks Educational Resources QuickBooks Service/Support Policies & Procedures Classifieds
QuickBooks Payroll (Desktop) Intuit Online Payroll ViewMyPaycheck
Builders & Contractors Non-profit Real Estate Retailers Service Industries Other Industries
QuickBooks Canada QuickBooks UK Desktop QuickBooks UK Online QuickBooks Singapore Online QuickBooks en Español QuickBooks Australia
  • QuickBooks Tasks
  • Intuit Products
  • Intuit Resources
  • Intuit Payroll
  • Industries
  • International
Leaderboard
Hide Advanced Search
 
All of these words
Any of these words
This exact phrase
None of these words
In this forum
With posts written by
With posts from
to
mm/dd/yy
mm/dd/yy
Show Advanced Search
Home   Help with Intuit Products   Intuit Products   QuickBase  
hide
05/24/2012 at 04:51PM PDT
Important Announcement! A planned system-wide upgrade will take place over the Memorial Day Weekend in the US (From Thurs, May 24, 2012 at 6 pm PDT thru Tues, May 29, 2012 at 5 am PDT). This includes QuickBooks, QuickBooks Payroll, Point of Sale, & Salesforce.com. This is only for US based products. This does not affect QuickBooks Online customers! During this time, you can shop, but can’t place orders online, activate products or update account info. We apologize for the inconvenience & thank you for patience while we improve our infrastructure to better serve you. International versions are unaffected. For more info, see our community discussion.
70
10298
cAyptauQer4yUOacwZ5xHE
Subscribe RSS
RyanSinnott
RyanSinnott
Questions asked: 32
Questions answered: 126
Points earned: 438
RyanSinnott
RyanSinnott
Questions asked: 32
Questions answered: 126
Points earned: 438
Contributor
02/08/12 2:09pm PST
Viewed by asker 03/13/12 2:12pm PDT

Javascript DoQuery

I'm utilizing the JavaScript SDK DoQuery call and everything is working fine except for my sorting. I'm trying to sort by FID 101 and FID 13, but I want to sort FID 101 in sortorder-A and FID 13 sortorder-D.

Here is my code:

var comments =  qdb.getRecords(qdb.DoQuery("MY DBID", "{6.EX.1}AND{52.EX.1}AND{101.XCT.J}", "52.11.13.101","101.13", "sortorder-A"));

I have tried this, but it didn't work:

var comments =  qdb.getRecords(qdb.DoQuery("MY DBID", "{6.EX.1}AND{52.EX.1}AND{101.XCT.J}", "52.11.13.101","101.13", "sortorder-A.sortorder-D"));

Solved!
Submit a reply to this question
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
 Report Abuse
5 Replies
ambcadmin
ambcadmin
Questions asked: 7
Questions answered: 637
Points earned: 2022
Allstar
Allstar
Advisory council of community power users.
ambcadmin
ambcadmin
Questions asked: 7
Questions answered: 637
Points earned: 2022
Allstar
02/08/12 4:27pm PST
The solution

Try this:

var comments =  qdb.getRecords(qdb.DoQuery("MY DBID", "{6.EX.1}AND{52.EX.1}AND{101.XCT.J}", "52.11.13.101","101.13", "sortorder-AD"));

Charles Guilbert | Trinity Integrated Solutions, Inc. | http://community.intuit.com/me...
Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
10
 Report Abuse
 
 
 
RyanSinnott
RyanSinnott
Questions asked: 32
Questions answered: 126
Points earned: 438
Contributor
02/09/12 6:30am PST

Worked perfectly, thanks for the quick reply. I wish Intuit would post some kind of documentation on the SDK..

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
DRobi
DRobi
Questions asked: 5
Questions answered: 6
Points earned: 6
New Member
02/09/12 12:50pm PST

Where do you get the QuickBaseClient.js file?  I can't find the download on the SDK site.

 

Thanks,

David

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
RyanSinnott
RyanSinnott
Questions asked: 32
Questions answered: 126
Points earned: 438
Contributor
02/09/12 12:55pm PST

The *.js file is located here: https://www.quickbase.com/js/Q...

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
 Report Abuse
 
 
 
DRobi
DRobi
Questions asked: 5
Questions answered: 6
Points earned: 6
New Member
02/09/12 12:58pm PST
Latest post

Thanks Ryan!

Type of Abuse
Abusive behavior
 
Inaccurate information
 
Other (add details below)
 
Add Details
Cancel_sm Submit_sm
This helped me! Add 1 point.
0
Reply to this Answer
 Report Abuse
 
 
 
   
 
Submit a reply to this question
 
Subscribe RSS
Tags for this topic
    Help other users find this post by tagging it
Use commas to add multiple tags
Add tags
Latest Site Activity
Pause Feed
AubreyT
49 secs ago
AubreyT
replied to
Picture Help
Dorothy34
1 min ago
Dorothy34
posted
Sales Receipt Entry error
Peggy1218
1 min ago
Peggy1218
posted
I was talking with Cass bef...
ConnieQB
1 min ago
ConnieQB
posted
posting payments
Operations2
1 min ago
Operations2
replied to
Quickbooks Overloaded??
Community Home Help with Intuit Products Start & Grow Your Business Help for Accountants Small Business Blog Join us on Facebook Follow us on Twitter Watch us on YouTube Meet us on LinkedIn
About Intuit | Careers | Register Your QuickBooks | QuickBooks Affiliate Program | Privacy | Legal | Contact Us | Our Hosts
© 2012 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trademarks of Intuit, Inc.
Terms and conditions, features, support, pricing and service options subject to change without notice.
TRUSTe - Privacy Standards and Principles
Intuit Websites - Create the perfect site
Intuit Small Business
QuickBooks Accounting Software
Small Business Grants
QuickBooks Online Accounting
Intuit Payroll Services
Intuit Credit Card Processing
Intuit Business Directory
Intuit GoPayment
Intuit Small Business Education
Intuit Small Business Blog
Love a Local Business