Query issue

Resolved kopr
(@kopernikus)

9 years, 1 month ago

This works:
[gdoc key=”full_shared_google_spreadsheet_url” query=”select F”]

This works:
[gdoc key=”full_shared_google_spreadsheet_url” query=”select max(O)”]

This does not:
[gdoc key=”full_shared_google_spreadsheet_url” query=”select F where max(O)”]

This is your example:
[gdoc key=”ABCDEFG” query=”select A where max(B)”]

Question: What happen?

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

Plugin Author Meitar
(@meitar)

9 years, 1 month ago
If you want to understand the Google Query Language, you should ask this on the Google Spreadsheet product support forums. They can tell you more about what happens during a GQL query.

If you are trying to accomplish something with this plugin, you should describe the problem you’re having and what you’re trying to accomplish.
- This reply was modified 9 years, 1 month ago by Meitar.
Thread Starter kopr
(@kopernikus)

9 years, 1 month ago

If you are trying to accomplish something with this plugin, you should describe the problem you’re having and what you’re trying to accomplish.

Ok, my bad, I thought it was obvious enough for you.

What I’m trying to accomplish with this plugin is simply to select rows which have maximum value which I did it by following your very instruction: query=“select A where max(B)”.

Just for the test I tried “select F” and “max(O)”, each of which worked perfectly. So, as per your instruction, in my case I tried “select F where max (O)” then it failed and came up with error like “invalid query” or something.

Am I the only one who have this issue? If I am, is there any suggestion from the plugin’s author about it?
Plugin Author Meitar
(@meitar)

9 years, 1 month ago
That error means the query isn’t one Google understands, at least not on that dataset. Hence the error, “invalid query” (obviously?). My guess is you need to add a GROUP BY clause, but it’s pretty hard to divine your intention without seeing your data. You should consider reading Google’s Google Query Language documentation.
- This reply was modified 9 years, 1 month ago by Meitar. Reason: HTML, not Markdown. (Oops.)
Thread Starter kopr
(@kopernikus)

9 years, 1 month ago
That error means the query isn’t one Google understands, at least not on that dataset. Hence the error, “invalid query” (obviously?).

But, I did nothing but copy-paste your example and change the cell. Where did I do wrong?

My guess is you need to add a GROUP BY clause.

I did, still no luck.

You should consider reading Google’s Google Query Language documentation.

Well, I did that, too. Do I need to read whole documentation or just focus on Aggregation Functions?
- This reply was modified 9 years, 1 month ago by kopr.
Plugin Author Meitar
(@meitar)

9 years, 1 month ago

¯\_(ツ)_/¯ For the second time now, for support with Google’s products, post on Google‘s product support forums.