Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Meitar

    (@meitar)

    From the Google Sheets documentation:

    Note that column IDs in spreadsheets are always letters; the column heading text shown in the published spreadsheet are labels, not IDs. You must use the ID, not the label, in your query string.

    Thread Starter jturet

    (@jturet)

    Is it possible to reference labels in the query? I need to return data based off of current user ID.

    Plugin Author Meitar

    (@meitar)

    From the Inline Google Spreadsheet Viewer plugin’s documentation:

    gdoc_query – Filters the Google Visualization API query language query. The first argument is the string supplied to the query attribute, or false if no query was supplied. The second argument is an array of all the attributes and their values passed to the current invocation of the shortcode.

    A common use case for this filter is to query a Google Spreadsheet using dynamically generated content, such as the email address or username of a logged-in user.

    Beginning to see a pattern here?

    Thread Starter jturet

    (@jturet)

    I am not sure that I understand. Is replacing query for gdoc_query supposed to allow me to run the queries documented here: https://developers.google.com/chart/interactive/docs/querylanguage? This did not work for my simple test case.

    Plugin Author Meitar

    (@meitar)

    No, as it says in the documentation, gdoc_query is a WordPress filter hook. I really think you should spend some time reading the documentation of the tools you are using.

    Thread Starter jturet

    (@jturet)

    I appreciate your prompt responses. My issues are not due to lack of reading they are due to lack of understanding. I am somewhat of a novice.

    Plugin Author Meitar

    (@meitar)

    My issues are not due to lack of reading they are due to lack of understanding. I am somewhat of a novice.

    I understand that, and what I am telling you is that you need to do more searching because as is evidenced by this thread, your questions are literally directly answered by the most obvious pages of the manuals of the tools you are using. If you are telling me that you found these links before you asked the questions, read the pages, and still did not understand them, then why should I expect you to understand what I am writing now?

    For example, read:

    https://ww.wp.xz.cn/support/topic/qdoc-query-under-other-notes-bottom-of-screen-example-request?replies=3

    You’re asking, almost word-for-word, the same questions other people have asked on this forum, which tells me you did not search (at least not with much effort) to see if the answers to your questions were already answered before you asked them. But this forum’s archives (and the manual pages) exist for the express reason to make it possible for you to get those answers quickly and autonomously.

    It is a very real problem for me when people do not do the simple thing of searching and reading the friendly f’in manuals that already exist for that express purpose. I bluntly have better things to do than answer the same question over and over again, and you have better things to do than wait on someone else to give you answers you could have trivially found on your own.

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

The topic ‘Selecting column names in Google Sheets using query’ is closed to new replies.