Header row being filtered by query

  • Resolved wpdevboy

    (@wpdevboy)


    6 years, 5 months ago

    I run a query on a google sheet and its filtering the header row. I’ve tried using the header_rows=1 to force it to recognize the top row as a header but no joy.

    Heres the code being used (it pulls in a region value from a combobox on the page)

    [gdoc key="1fPbp0__UZlThgxy5o-AUXbJWIE7fQ_qXYmfumlKckFk" datatables_page_length="100" query="select A, B, D where E contains \'region\' AND A != ''" datatables_order='%5B%5B 1, "asc" %5D%5D']

    Any ideas what might be causing this?

Viewing 1 replies (of 1 total)
  • Plugin Author Meitar

    (@meitar)

    I’m not entirely sure what you mean by “filtering the header row,” but I can see two potential issues in your shortcode invocation:

    1. The query attribute is only fully supported on new-style Google Sheets, so rather than using the Sheet ID in the key attribute, use the full URL.
    2. Your query does not need to escape the single quotes around region. I don’t know if that’s harmful or not but you can simply single-quote them. I.e., replace \'region\' with 'region'.

    Hope this helps.

Viewing 1 replies (of 1 total)
  • The topic ‘Header row being filtered by query’ is closed to new replies.