Query not working

Resolved gkarami
(@gkarami)

10 years, 7 months ago

I have this doc published here:
https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml

I want only some columns, no query is working on this. I tried:
[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select A” ]

[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select A, B” ]

[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select Students” ]

https://ww.wp.xz.cn/plugins/inline-google-spreadsheet-viewer/

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

Plugin Author Meitar
(@meitar)

10 years, 7 months ago

I want only some columns, no query is working on this. I tried:
[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select A” ]

[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select A, B” ]

Works for me.

Thread Starter gkarami
(@gkarami)

10 years, 7 months ago

So with
[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select A” ]
you see only the first column?

It returns all columns here.

Thread Starter gkarami
(@gkarami)

10 years, 7 months ago

It does not matter what column I select, It returns all columns

Plugin Author Meitar
(@meitar)

10 years, 7 months ago

So with
[gdoc
key=”https://docs.google.com/spreadsheets/d/1-doN_hliHn2mfTlsCEYznE65liEE1eTfqc0gcPLf6YU/pubhtml” query=”select A” ]
you see only the first column?

Yes.

It does not matter what column I select, It returns all columns.

Okay. You might be viewing a cache, or some other output, so I suggest you look into possibilities induced by your WordPress installation and environment. Like I said twice now, it works for me.

Thread Starter gkarami
(@gkarami)

10 years, 7 months ago

Other columns are under the “Plus” icon. When I click that, open other columns. I tried with other browsers, cleared cache.

Can anybody please try this?

Thread Starter gkarami
(@gkarami)

10 years, 7 months ago

Dear Meitar,

I change the key and then returned it back to mine again and it worked.
Thank you for your help.

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

The topic ‘Query not working’ is closed to new replies.