Plugin Author
Meitar
(@meitar)
On this forum:
* “query” part is ignored
* Diffculties with “query” option
* Query not working
Please search for existing answers to your question before making a new posting.
-
This reply was modified 9 years, 5 months ago by
Meitar.
Hello,
of course I read about my problem first. I learn from this site. And also read another examples from internet and “Other Notes” from plugin download site. I use the whole URL address in key attribute, my chart is displayed. My problem is that I would like to show only e.g. third column but the plugin always show all columns. It not react on query attribute. Can anybody help me to solve this issue? My version of wordpress is 4.7. The plugin is compatibile up to 4.6.1. Could this be a problem?
Here is example of my code:
[gdoc
key=”whole address to my spreadsheet” chart=”Column” title=”Title” query=”select A,B”
]
My table in spradsheet have 13 rows and 4 columns but on my page there is every column in my chart. Is there some problem with my code?
Thank you!
I suggest you:
1) Create a dummy spreadsheet w/ some sample data, including more columns than you need to display
2) Share this dummy sheet via the plug-in instructions
3) Reply and include your actual shortcode
I and many others have no problems displaying just specified columns from a many-columned spreadsheet, so without looking at your code and spreadsheet it’s pretty tough to help you.
Plugin Author
Meitar
(@meitar)
After more than aa week without a reply, I’m marking this resolved. (Thanks for your help, Dustin.)
Hello,
sorry for late response, I was on vocation.
here is my shortcode:
[gdoc
key=”https://docs.google.com/spreadsheets/d/1oAXojGlqFGVMevxbXH35Wq6bau1l-r-xWjeV6TenCWc/edit#gid=0″ chart=”Column” title=”r.2016″ query=”select A,B”
]
I can see all three columns even I chose only one. I thing, the shortcode is ok.
So why it is not working for me? This is what I see:
https://drive.google.com/file/d/0B9TerafhhkGpVkVDcFU4b0Z5eWs/view?usp=sharing
I would like to show, for example, only one column of my table.
The plugin is compatibile up to 4.6.1. but i have wordpress 4.7. Could be this the problem? What should I do to make it work for me?
I have to set this incident to not resolved for 3 time. It still not working for me. Can anybody help?
Your shortcode works fine for me as well. I would suspect that your issue is either caused by your WordPress theme (try using a default theme to test with) or another installed Plug-in (try disabling them to see if the problem persists).
Additionally, is your browser’s Console Log showing any errors? If so… what are they?
Hi Dustin,
I tried this steps:
1. disable all plugins – did not help
2. default theme – did not help
3. another two themes – did not help
4. update plugins – did not work
I see in console only this warrning:
A Parser-blocking, cross-origin script, https://www.google.com/uds/?file=visualization&v=1.0&packages=annotatedtimeline%2Cannotationchart%2Ccorechart%2Cgauge%2Ctimeline, is invoked via document.write. This may be blocked by the browser if the device has poor network connectivity.
I think, this should not be a problem.
If you do not have any ideas, it seems that I will need a special table for each column.
Plugin Author
Meitar
(@meitar)
Just in case it’s something “obvious,” make sure your shortcode is plain text. Using curly quotes, for instance, will not work.
Other than that, though, ¯\_(ツ)_/¯.
