Title: Query Issues
Last modified: February 8, 2021

---

# Query Issues

 *  [GMRobbins](https://wordpress.org/support/users/gmrobbins/)
 * (@gmrobbins)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/query-issues-2/)
 * Issue: “No data available in table” after viewing page with the following shortcode:
 * `[gdoc key="https://docs.google.com/spreadsheets/d/12EU3NfQE4kiVylPiQRy6C2z_nmCc5ITBhzU0a8o18dM/
   edit?usp=sharing" query="select A,C,D,E,F WHERE B %3E'3'" header_cols="5" datatables_page_length
   ="10" csv_headers="1" datatables_order='%5B 4, "desc" %5D']`
 * I receive no errors, but the code does not return the desired results. In fact,
   I can not get ANY results. Has anyone else run into this issue? I have followed
   instructions and searched for any answer with no satisfaction. Thus, I turn to
   this support page.
    TIA! Grayson

Viewing 1 replies (of 1 total)

 *  Thread Starter [GMRobbins](https://wordpress.org/support/users/gmrobbins/)
 * (@gmrobbins)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/query-issues-2/#post-14020857)
 * Well, Finally! I had to go to the below page to figure out the correct coding:
 * [https://developers.google.com/chart/interactive/docs/querylanguage#where](https://developers.google.com/chart/interactive/docs/querylanguage#where)
 * `[gdoc key="https://docs.google.com/spreadsheets/d/12EU3NfQE4kiVylPiQRy6C2z_nmCc5ITBhzU0a8o18dM/
   edit?usp=sharing"  query="select A,B,C,D,E,F WHERE B != 0" header_cols="6" datatables_page_length
   ="10" csv_headers="1" datatables_order='%5B 4, "desc" %5D' use_cache="no"]`
 * Although the plugin is absolutely outstanding, the author seems to believe everyone
   has similar coding knowledge as himself and makes seeking answers a series of
   trial and errors … an Easter egg hunt in many ways. Very challenging to say the
   least! Yes, most of the answers are plainly in the documentation, but some tact
   and better replies would be most welcoming to users of the plugin. The documentation
   could be adjusted to highlight the redundant request and make using this plugin
   so much easier. All the same, wonderful plugin! Thanks!

Viewing 1 replies (of 1 total)

The topic ‘Query Issues’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

## Tags

 * [query](https://wordpress.org/support/topic-tag/query/)

 * 1 reply
 * 1 participant
 * Last reply from: [GMRobbins](https://wordpress.org/support/users/gmrobbins/)
 * Last activity: [5 years, 3 months ago](https://wordpress.org/support/topic/query-issues-2/#post-14020857)
 * Status: not resolved