Query Issues

  • 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

    (@gmrobbins)

    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

    [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.

Tags