{"id":12252,"date":"2019-12-19T18:27:19","date_gmt":"2019-12-19T18:27:19","guid":{"rendered":"https:\/\/www.directimpactsolutions.com\/?p=12252"},"modified":"2025-05-01T04:09:58","modified_gmt":"2025-05-01T04:09:58","slug":"display-executesql-results-in-a-web-viewer","status":"publish","type":"post","link":"https:\/\/www.directimpactsolutions.com\/en\/display-executesql-results-in-a-web-viewer\/","title":{"rendered":"Display ExecuteSQL Results in a Web Viewer"},"content":{"rendered":"<p>In a previous blog post (<a href=\"https:\/\/directimpactsolutions.com\/en\/how-to-display-filemaker-data-on-the-web\">How to Display FileMaker Data Online<\/a>), I wrote about how to export data from a FileMaker database into a table hosted on a website using&nbsp;<a href=\"https:\/\/datatables.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">DataTables<\/a>. DataTables can also be used with FileMaker to create a layout that displays the results of your ExecuteSQL queries.<\/p><figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"598\" src=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/fm-data2.png\" alt=\"display ExecuteSQL results in a web viewer\" class=\"wp-image-12253\" style=\"width:742px;height:433px\" srcset=\"https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/fm-data2.png 1024w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/fm-data2-300x175.png 300w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/fm-data2-768x449.png 768w, https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/fm-data2-600x350.png 600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><p>The table is responsive when resizing the window<\/p><h3 class=\"wp-block-heading\">Exporting Data into DataTables:<\/h3><p>I\u2019ve included a demo file at the end of this blog post.<\/p><p>This method:<\/p><ol class=\"wp-block-list\"><li>Queries your database using the ExecuteSQL() function<\/li>\n\n<li>Converts the results to JSON<\/li>\n\n<li>Prepares the DataTable code and exports it to an html document<\/li>\n\n<li><a href=\"https:\/\/directimpactsolutions.com\/en\/displaying-filemaker-data-in-web-viewers\/\">Displays the data in a web viewer<\/a><\/li><\/ol><blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p class=\"has-medium-font-size\"><strong>This entire process should take less than 200 milliseconds.<\/strong><\/p><\/blockquote><h3 class=\"wp-block-heading\">Going further:<\/h3><ul class=\"wp-block-list\"><li>Geist Interactive (Proof+Geist) has thorough\u00a0<a href=\"https:\/\/www.proofgeist.com\/blog\/\" target=\"_blank\" rel=\"noreferrer noopener\">blog posts<\/a>\u00a0about using DataTables with FileMaker.<\/li>\n\n<li>You can find information about customizing the style of your table&nbsp;<a href=\"https:\/\/datatables.net\/manual\/styling\/\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/li><\/ul><h3 class=\"wp-block-heading\">Conclusion:<\/h3><p>This method is a quick way to display data returned by ExecuteSQL in FileMaker without having to create a layout or a report script for each set of data that you\u2019d like to generate.<\/p><hr class=\"wp-block-separator has-alpha-channel-opacity\" style=\"margin-top:var(--wp--preset--spacing--70);margin-bottom:var(--wp--preset--spacing--70)\"\/><p class=\"has-small-font-size\"><em>*This article was originally written for AppWorks, which has since joined Direct Impact Solutions. This article is intended for informative purposes only. To the best of our knowledge, this information is accurate as of the date of publication.<\/em><\/p><p><\/p>","protected":false},"excerpt":{"rendered":"<p>In a previous blog post (How to Display FileMaker Data Online), I wrote about how to export data from a FileMaker database into a table hosted on a website using&nbsp;DataTables. DataTables can also be used with FileMaker to create a layout that displays the results of your ExecuteSQL queries. The table is responsive when resizing &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.directimpactsolutions.com\/en\/display-executesql-results-in-a-web-viewer\/\"> <span class=\"screen-reader-text\">Display ExecuteSQL Results in a Web Viewer<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":6,"featured_media":12261,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","footnotes":""},"categories":[29],"tags":[272,273,39,275],"class_list":["post-12252","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-low-code","tag-datatables","tag-executesql","tag-filemaker","tag-web-viewer"],"uagb_featured_image_src":{"full":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results.jpg",2535,1183,false],"thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-150x150.jpg",150,150,true],"medium":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-300x140.jpg",300,140,true],"medium_large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-768x358.jpg",768,358,true],"large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-1024x478.jpg",1024,478,true],"1536x1536":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-1536x717.jpg",1536,717,true],"2048x2048":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-2048x956.jpg",2048,956,true],"woocommerce_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-600x280.jpg",600,280,true],"woocommerce_gallery_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/05\/ExecuteSQL-Results-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Direct Impact Solutions","author_link":"https:\/\/www.directimpactsolutions.com\/en\/author\/direct-impact-solutions\/"},"uagb_comment_info":0,"uagb_excerpt":"In a previous blog post (How to Display FileMaker Data Online), I wrote about how to export data from a FileMaker database into a table hosted on a website using&nbsp;DataTables. DataTables can also be used with FileMaker to create a layout that displays the results of your ExecuteSQL queries. The table is responsive when resizing&hellip;","_links":{"self":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/12252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/comments?post=12252"}],"version-history":[{"count":5,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/12252\/revisions"}],"predecessor-version":[{"id":20031,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/12252\/revisions\/20031"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media\/12261"}],"wp:attachment":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media?parent=12252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/categories?post=12252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/tags?post=12252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}