Title: Query debug?
Last modified: August 22, 2016

---

# Query debug?

 *  Resolved [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * (@rpb1001)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/)
 * Greetings.
    I am excited to use the querying on the spreadsheet. I have what 
   is stated below. Some of the columns have rather long names.
 * [gdoc key=”key” query=”Select `Your good name`,`Which event do you wish to enter?`,`
   Country (if not Nepal)` order by `Which event do you wish to enter?` desc”]
 * I am not having success, even if I strip the query right down to
 * [gdoc key=”key” query=”Select `Gender`“]
 * Is there anyway to debug and show the response from Google?
 * Thank you.
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Thread Starter [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * (@rpb1001)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508782)
 * pls note that the backticks have been formatted out!
 * The two examples are shown here. Thank you for an assistance you can give.
 * [https://www.dropbox.com/s/4x5v54e8pve2ec3/Screenshot%202014-11-23%2006.07.33.png?dl=0](https://www.dropbox.com/s/4x5v54e8pve2ec3/Screenshot%202014-11-23%2006.07.33.png?dl=0)
 * [https://www.dropbox.com/s/y5rmkiiniugi49g/Screenshot%202014-11-23%2006.08.06.png?dl=0](https://www.dropbox.com/s/y5rmkiiniugi49g/Screenshot%202014-11-23%2006.08.06.png?dl=0)
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508789)
 * With column names that complex and with that many special characters, I’d suggest
   you use their positions instead of their names. In other words, try using a `
   query` value more similar to `select A, B, C` where `A`, `B`, and `C` are the
   letter-positions of the columns in your spreadsheet. (`A` is the left-most column,`
   B` the column to its right, and so on.)
 *  Thread Starter [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * (@rpb1001)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508795)
 * Like this?
 * `query="Select B, Q, T order by Q desc"`
 * Still not working for me and it is outputting the full range of columns.
 * [http://ultratrailkathmandu.com/kathmandu-5050/registered/](http://ultratrailkathmandu.com/kathmandu-5050/registered/)
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508797)
 * Hmmm. Okay, thanks for providing a link to the page where this is an issue for
   you. I’ll take a closer look at this either tonight or tomorrow (I think/hope),
   and I’ll mark this as unresolved in the mean time.
 *  Thread Starter [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * (@rpb1001)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508805)
 * Many thanks. This line (40) is returning false clearly.
 * `if (preg_match('/\/(edit|pubhtml).*$/', $key, $m) && 'http' === substr($key,
   0, 4)) {`
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508934)
 * Oh, your spreadsheet is using the “old” Google Sheets. The `query` attribute 
   is only supported on _new_ Google Sheets. [Update your sheet to Google’s new implementation](https://support.google.com/docs/answer/3544847)
   and replace the `key` in your shortcode with the full URL as described by this
   plugin’s README.
 *  Thread Starter [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * (@rpb1001)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5508991)
 * Sorry for being such a fool and wasting your time!
 * I am trying the upgrade. One question: have you any idea how to copy an old form
   over to a new sheet? Can’t find documentation for that.
 * Thank you again.
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5509043)
 * No, when I moved to the new Google Spreadsheets, I just re-created the forms.
 *  Thread Starter [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * (@rpb1001)
 * [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5509044)
 * OK, many thanks again Meitar.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Query debug?’ 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/)

 * 9 replies
 * 2 participants
 * Last reply from: [rpb1001](https://wordpress.org/support/users/rpb1001/)
 * Last activity: [11 years, 6 months ago](https://wordpress.org/support/topic/query-debug/#post-5509044)
 * Status: resolved