Title: Table Headers missing from dataset when using SQL ‘where’ clause. Last modified: October 3, 2016 --- # Table Headers missing from dataset when using SQL ‘where’ clause. * Resolved [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/) * I’ve been experiencing this issue for a long time, so I don’t think it’s related to any WP or Plug-in updates… I’ve also dug through this plug-in’s forum (at least to page 15) and tried searching as well, but it seems I may be alone in experiencing this issue. * As the subject says, my table headers appear to be missing from the dataset when using a SQL query with a ‘where’ clause. * The two example tables on [my example page](http://beckatl.com/ooh-tracker-adams/) are being spawned thusly: * `[gdoc key="https://docs.google.com/spreadsheets/d/1wknxYVy1-kuoKZAd8YINHxJJKAJUbZRDAwB6D76lOKM/ edit?usp=sharing" query="SELECT C,D WHERE D CONTAINS '69' LIMIT 10" use_cache ="no" expire_in="1" datatables_paging="true"]Results when "SELECT C,D WHERE D CONTAINS '69' LIMIT 10"[/gdoc]` * `[gdoc key="https://docs.google.com/spreadsheets/d/1wknxYVy1-kuoKZAd8YINHxJJKAJUbZRDAwB6D76lOKM/ edit?usp=sharing" query="SELECT C,D LIMIT 10" use_cache="no" expire_in="1" datatables_paging ="true"]Results when "SELECT C,D LIMIT 10"[/gdoc]` * As you can hopefully see on [my example page](http://beckatl.com/ooh-tracker-adams/) the first table is not properly displaying the Sheet’s frozen header row, while the 2nd table is. * Any thoughts? Dustin * P.S. On a side note, for some reason my table export options are missing as well. I have hidden them via CSS, but I don’t see them being output in the HTML at all. I’m certain that I have not modified your plug-in’s files at all… nor have I added any custom hooks in functions.php Viewing 8 replies - 1 through 8 (of 8 total) * Thread Starter [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8249641) * I forgot to mention… I’m running version 0.10.2 of the Inline Google Spreadsheet Viewer plug-in. * Thread Starter [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8252021) * FYI… A) I’ve found where I am overriding the “table export options” on the plug- in’s settings page, so no problems there. B) I’ve also now gone through ALL of the plug-in’s support forum pages, unsuccessfully looking for an answer to the Header issue I’m having. * Thread Starter [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8252388) * I suppose I should include that this is in reference to the Inline Google Spreadsheet Viewer: [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8260690) * It looks like there’s a jQuery error on your page. If you open up the [Web Inspector’s console](https://developer.mozilla.org/en-US/docs/Tools/Web_Console/Opening_the_Web_Console)( in Firefox), you’ll see a `TypeError: jQuery.fn.dataTable is undefined` message. This means none of the DataTables features will work until the error is resolved. Unfortunately, this is probably happening due to a conflict with some other plugin, as my own test pages don’t raise such an error. * Have you considered stepping through the [plugin troubleshooting process described on the WordPress codex](https://codex.wordpress.org/Managing_Plugins#Troubleshooting)? * Thread Starter [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8260793) * Interesting… I pretty much use Chrome for development, and it’s not showing that error in it’s Console 😐 but yes, that would indicate a plug-in problem. * I’ll troubleshoot further. Thanks for getting back to me about it. 🙂 * Edit: Not to be argumentative or anything, but why would a jQuery error cause the header row to be missing from the returned dataset? - This reply was modified 9 years, 8 months ago by [Dustin Tantum](https://wordpress.org/support/users/tantumonium/). Reason: Followup question * Thread Starter [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8263850) * Hi, Meitar. * I temporarily disabled all plug-ins except the “Inline Google Spreadsheet Viewer”, and I still have no head rows on the table in which I’m using a “where” clause. * Also, I viewed the sample page with Firefox (v40.0.2 for OS X) before and after disabling the plug-ins… and I am not seeing any jQuery errors in the console. * I understand that a jQuery conflict could cause DataTables functionality to not work, however I don’t understand why but why that would cause the header row to be completely missing from the returned dataset… * Any thoughts? * P.S. I’m doing a backup right now and am going to setup a separate DEV server to do further testing on this. * Thread Starter [Dustin Tantum](https://wordpress.org/support/users/tantumonium/) * (@tantumonium) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8264762) * Meitar, * On the development server, I’m using the default WordPress theme “Twenty Sixteen”, and have only your plug-in active. I’m still not getting header rows for the first set of data. * See: [http://dev.beckatl.com/ooh-tracker-adams/](http://dev.beckatl.com/ooh-tracker-adams/) * Dustin * Plugin Author [Meitar](https://wordpress.org/support/users/meitar/) * (@meitar) * [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8268194) * Oh, my apologies, I misunderstood your question. * You’ll note that no cell in your header row contains the string `69`, so your` where` clause is excluding it. That’s why Google is not returning that row as part of the result set. Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Table Headers missing from dataset when using SQL ‘where’ clause.’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer. svg) * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/) * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq) * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/) * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/) * 8 replies * 2 participants * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/) * Last activity: [9 years, 8 months ago](https://wordpress.org/support/topic/table-headers-missing-from-dataset-when-using-sql-where-clause/#post-8268194) * Status: resolved