SQLexplorer

Web Viewer Portal

SQLexplorer.WebViewerPortal History

Hide minor edits - Show changes to output

July 19, 2013, at 03:50 PM by 75.71.120.47 -
Changed line 7 from:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer with some HTML 5 and Javascript techniques to display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
to:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer with some HTML 5 and Javascript techniques to display our results in a new way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
July 18, 2013, at 09:30 PM by 75.71.120.47 -
Changed line 7 from:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer and some HTML 5 and Javascript techniques and display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
to:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer with some HTML 5 and Javascript techniques to display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
July 18, 2013, at 08:33 PM by 75.71.120.47 -
Changed line 9 from:
We ended up using the %newwin% [[http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action %newwin [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:
to:
We ended up using the %newwin% [[http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action %newwin% [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:
July 18, 2013, at 08:33 PM by 75.71.120.47 -
Changed line 33 from:
*More information on theses last three tokens is in the JQGrid %newwin [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation.]]
to:
*More information on theses last three tokens is in the JQGrid %newwin% [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation.]]
July 18, 2013, at 08:32 PM by 75.71.120.47 -
Changed lines 9-10 from:
We ended up using the %newwin% [http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:
to:
We ended up using the %newwin% [[http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action %newwin [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:
Changed lines 33-36 from:
*More information on theses last three tokens is in the JQGrid [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation.]]

'''CSS''' The [[http://www.trirand.com/blog/ | JQGrid]] plug-in uses themes built with the [[http://jqueryui.com/themeroller/| jQuery UI Theme Roller]].  We've created a [[http://jqueryui.com/themeroller/#!zThemeParams=5d000001001406000000000000003d8888d844329a8dfe02723de3e57031bfe049f4bbfda82bb04620400305ed55a625997824a99ed436ffeeef18133f377f7e7486b7f8525d9d0b24fd32daa7619458a3ab42bb90979ce442f142e94f5fb9f2149db0364976b76de09766da2cd02061d7cc3ab648a195ee9bee9fb9a77ec095d5131e0302ef8b679e77a36c43ac64eb82388aabae798f47dd9cf27b2b4013763cfdf26a6f320c1ef32141b641d2e329e32b1913b3c97b1af947e2a3b6dc73448cc7da4bb4682d793229e2d298cde9ef413028c2f047cb75980f8aefac76132289a6dbe52b7f0c173c3770eee71e093c6e1313bcd838bef2a8595b989793f4082450fef34987b065122199e7c9b0887c040db87d123fa3c229b4f3bd542ff90a4c4d5cfef6dcad9e38e0475013125c2fc27f667a5657212b2ce9cb19f2989081a8c1872d1bde051afd52dc1a1c264626bba8b039db23275281a13cd40dc5343e0d7404f1025bac9040274d643f0d2b767cd2109c8f9ff25fa9279fd52cd9a4d83c5070af8298417760c5c5b0b786e98685055408e5050f52544519d1576ac663c0c92415616dc2d3be840ef3b3e79f6885aca02fea7ae301cde1583102bebb81f9fa90049f|custom theme]] that fits nicely with the FileMaker Onyx theme the Explorer uses.  If you want to use a different theme you can create it using the Theme Roller and then download it.  Once downloaded, you can go the the SQL Explorer Layout '''css''' and import the CSS into SQL Explorer and change the theme of the web viewer.
to:
*More information on theses last three tokens is in the JQGrid %newwin [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation.]]

'''CSS''' The %newwin% [[http://www.trirand.com/blog/ | JQGrid]] plug-in uses themes built with the [[http://jqueryui.com/themeroller/| jQuery UI Theme Roller]].  We've created a [[http://jqueryui.com/themeroller/#!zThemeParams=5d000001001406000000000000003d8888d844329a8dfe02723de3e57031bfe049f4bbfda82bb04620400305ed55a625997824a99ed436ffeeef18133f377f7e7486b7f8525d9d0b24fd32daa7619458a3ab42bb90979ce442f142e94f5fb9f2149db0364976b76de09766da2cd02061d7cc3ab648a195ee9bee9fb9a77ec095d5131e0302ef8b679e77a36c43ac64eb82388aabae798f47dd9cf27b2b4013763cfdf26a6f320c1ef32141b641d2e329e32b1913b3c97b1af947e2a3b6dc73448cc7da4bb4682d793229e2d298cde9ef413028c2f047cb75980f8aefac76132289a6dbe52b7f0c173c3770eee71e093c6e1313bcd838bef2a8595b989793f4082450fef34987b065122199e7c9b0887c040db87d123fa3c229b4f3bd542ff90a4c4d5cfef6dcad9e38e0475013125c2fc27f667a5657212b2ce9cb19f2989081a8c1872d1bde051afd52dc1a1c264626bba8b039db23275281a13cd40dc5343e0d7404f1025bac9040274d643f0d2b767cd2109c8f9ff25fa9279fd52cd9a4d83c5070af8298417760c5c5b0b786e98685055408e5050f52544519d1576ac663c0c92415616dc2d3be840ef3b3e79f6885aca02fea7ae301cde1583102bebb81f9fa90049f|custom theme]] that fits nicely with the FileMaker Onyx theme the Explorer uses.  If you want to use a different theme you can create it using the Theme Roller and then download it.  Once downloaded, you can go the the SQL Explorer Layout '''css''' and import the CSS into SQL Explorer and change the theme of the web viewer.
Changed lines 41-45 from:
*[[http://code.jquery.com/jquery-1.9.0.js | jQuery v1.90]]
*[[http://layout.jquery-dev.net/lib/js/jquery.layout-latest.js | jQuery Layout v1.30]]
*[[http://trirand.com/blog/jqgrid/js/jquery.jqGrid.js | jQGrid v 4.52]]
*[[http://trirand.com/blog/jqgrid/js/grid.locale-en | grid.locale-en]] (Localized code of jQGrid)
*[[http://trirand.com/blog/jqgrid/js/jquery-ui-custom.min.js | jQuery-ui-Custom]] (Built by jQGrid folks)
to:
*%newwin% [[http://code.jquery.com/jquery-1.9.0.js | jQuery v1.90]]
*%newwin% [[http://layout.jquery-dev.net/lib/js/jquery.layout-latest.js | jQuery Layout v1.30]]
*%newwin% [[http://trirand.com/blog/jqgrid/js/jquery.jqGrid.js | jQGrid v 4.52]]
*%newwin% [[http://trirand.com/blog/jqgrid/js/grid.locale-en | grid.locale-en]] (Localized code of jQGrid)
*%newwin% [[http://trirand.com/blog/jqgrid/js/jquery-ui-custom.min.js | jQuery-ui-Custom]] (Built by jQGrid folks)
Changed lines 47-48 from:
*[[https://github.com/douglascrockford/JSON-js/blob/master/json2.js | json2 ]] (Used in CSVtoJSON)
to:
*%newwin% [[https://github.com/douglascrockford/JSON-js/blob/master/json2.js | json2 ]] (Used in CSVtoJSON)
Changed lines 51-53 from:
'''jQGrid Plug-In''' The [[http://www.trirand.com/blog/ | jQGrid]] plug-in is an open source jQuery Library with a ton of functionality that we're only scratching the surface with here.  Check out their [[http://trirand.com/blog/jqgrid/jqgrid.html | demo page]] to get a sense of what this thing can do.

If you're interested in experimenting with these options then review the plug-ins [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation,]] '''Make Sure You Have a Back-Up,''' and start experimenting!  The script '''Configure jQGrid''' is where you can make these changes to the Web Viewer.  You will need to re-run the '''Upon Opening''' script to see these changes take effect.
to:
'''jQGrid Plug-In''' The %newwin% [[http://www.trirand.com/blog/ | jQGrid]] plug-in is an open source jQuery Library with a ton of functionality that we're only scratching the surface with here.  Check out their [[http://trirand.com/blog/jqgrid/jqgrid.html | demo page]] to get a sense of what this thing can do.

If you're interested in experimenting with these options then review the plug-ins %newwin% [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation,]] '''Make Sure You Have a Back-Up,''' and start experimenting!  The script '''Configure jQGrid''' is where you can make these changes to the Web Viewer.  You will need to re-run the '''Upon Opening''' script to see these changes take effect.
July 18, 2013, at 08:30 PM by 75.71.120.47 -
Changed line 9 from:
We ended up using the [[http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:
to:
We ended up using the %newwin% [http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:
July 18, 2013, at 07:10 PM by 75.71.120.47 -
Changed line 5 from:
%center newwin% [[http://205.186.131.92/rootimages/stikipad/sqlexplorer/WebViewerPortal.jpg | http://205.186.131.92/rootimages/stikipad/sqlexplorer/WebViewerPortal.jpg]]
to:
%center newwin% [[http://205.186.131.92/rootimages/stikipad/sqlexplorer/querypage.jpg | http://205.186.131.92/rootimages/stikipad/sqlexplorer/WebViewerPortal.jpg]]
July 18, 2013, at 07:06 PM by 75.71.120.47 -
Changed line 21 from:
<script src="file:///private/var/folders/8w/sgn/T/S10.1/jquery.js" type="text/javascript"></script>
to:
<script src="file:///private/.../jquery.js" type="text/javascript"></script>
July 18, 2013, at 07:05 PM by 75.71.120.47 -
Added lines 2-5:

The Web Viewer Portal was introduced in [[VersionHistory | version 1.29]].

%center newwin% [[http://205.186.131.92/rootimages/stikipad/sqlexplorer/WebViewerPortal.jpg | http://205.186.131.92/rootimages/stikipad/sqlexplorer/WebViewerPortal.jpg]]
July 17, 2013, at 07:05 PM by 75.71.120.47 -
Changed lines 47-49 from:
'''jQGrid Plug-In''' The [[http://www.trirand.com/blog/ | jQGrid]] plug-in is an open source jQuery Library with a ton of functionality that we're only scratching the surface with here.  If you're interested in experimenting with these options then review the plug-ins [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation,]] '''Make Sure You Have a Back-Up,''' and start experimenting!  The script '''Configure jQGrid''' is where you can make these changes to the Web Viewer.  You will need to re-run the '''Upon Opening''' script to see these changes take effect.
to:
'''jQGrid Plug-In''' The [[http://www.trirand.com/blog/ | jQGrid]] plug-in is an open source jQuery Library with a ton of functionality that we're only scratching the surface with here.  Check out their [[http://trirand.com/blog/jqgrid/jqgrid.html | demo page]] to get a sense of what this thing can do.

If you're interested in experimenting with these options then review the plug-ins [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation,]] '''Make Sure You Have a Back-Up,''' and start experimenting!  The script '''Configure jQGrid''' is where you can make these changes to the Web Viewer.  You will need to re-run the '''Upon Opening''' script to see these changes take effect.
July 17, 2013, at 07:02 PM by 75.71.120.47 -
Changed lines 29-30 from:
*More on the last three tokens in the '''JQGrid''' options below.
to:
*More information on theses last three tokens is in the JQGrid [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation.]]
Deleted line 47:
July 17, 2013, at 06:46 PM by 75.71.120.47 -
Changed lines 45-46 from:
As with the CSS, we didn't want to modify these libraries themselves, so when it's necessary to modify this code, we do substitutions to our exports so if the libraries are updated, then nothing should break.  The Javascript substitutions are performed in the script '''Export JS to temp directory.'''
to:
As with the CSS, we don't want to modify these libraries themselves, so when it's necessary to modify this code, we do substitutions to our exports so if the libraries are updated, then nothing should break.  The Javascript substitutions are performed in the script '''Export JS to temp directory.'''
July 17, 2013, at 06:45 PM by 75.71.120.47 -
Changed lines 15-16 from:
'''HTML Template''' On start-up, SQL Explorer creates a Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like the following example.
to:
'''HTML Template''' On start-up, SQL Explorer creates a Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like this.
July 17, 2013, at 06:44 PM by 75.71.120.47 -
Changed lines 11-12 from:
You can also view an expanded view of your results in a full browser window by exporting the Data URL and having FileMaker open it in your default browser.  This view also adds additional search functionality where you can refine your results and copy and paste the search back into your SQL Query.
to:
You can also view an expanded view of your results in a full browser window by exporting the Data URL and having FileMaker open it in your default browser.  This view also adds additional search functionality where you can refine your results and copy and paste the search back into your SQL Query.  It's also great for debugging as you can use your browsers debug tools that aren't available in the Web Viewer.
July 17, 2013, at 06:42 PM by 75.71.120.47 -
Changed lines 3-4 from:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer and some HTML 5 and Javascript code in a data url and display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
to:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer and some HTML 5 and Javascript techniques and display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
July 17, 2013, at 06:42 PM by 75.71.120.47 -
Changed lines 3-4 from:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer and some HTML 5 and Javascript code in a data url and display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
to:
SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types, less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer and some HTML 5 and Javascript code in a data url and display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.
July 17, 2013, at 06:41 PM by 75.71.120.47 -
Changed lines 15-16 from:
'''HTML Template''' On start-up, SQL Explorer creates a Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache[1]).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like the following example.
to:
'''HTML Template''' On start-up, SQL Explorer creates a Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like the following example.
July 17, 2013, at 06:41 PM by 75.71.120.47 -
Changed lines 45-48 from:



to:
As with the CSS, we didn't want to modify these libraries themselves, so when it's necessary to modify this code, we do substitutions to our exports so if the libraries are updated, then nothing should break.  The Javascript substitutions are performed in the script '''Export JS to temp directory.'''

'''jQGrid Plug-In''' The [[http://www.trirand.com/blog/ | jQGrid]] plug-in is an open source jQuery Library with a ton of functionality that we're only scratching the surface with here.  If you're interested in experimenting with these options then review the plug-ins [[http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs | documentation,]] '''Make Sure You Have a Back-Up,''' and start experimenting!  The script '''Configure jQGrid''' is where you can make these changes to the Web Viewer.  You will need to re-run the '''Upon Opening''' script to see these changes take effect.

July 17, 2013, at 05:44 PM by 75.71.120.47 -
Changed lines 43-48 from:
*[["https://github.com/douglascrockford/JSON-js/blob/master/json2.js" | json2 ]] (Used in CSVtoJSON)




to:
*[[https://github.com/douglascrockford/JSON-js/blob/master/json2.js | json2 ]] (Used in CSVtoJSON)




July 17, 2013, at 05:43 PM by 75.71.120.47 -
Changed lines 37-39 from:
[["http://code.jquery.com/jquery-1.9.0.js"|jQuery v1.90]]

to:
*[[http://code.jquery.com/jquery-1.9.0.js | jQuery v1.90]]
*[[http://layout.jquery-dev.net/lib/js/jquery.layout-latest.js | jQuery Layout v1.30]]
*[[http://trirand.com/blog/jqgrid/js/jquery.jqGrid.js | jQGrid v 4.52]]
*[[http://trirand.com/blog/jqgrid/js/grid.locale-en | grid.locale-en]] (Localized code of jQGrid)
*[[http://trirand.com/blog/jqgrid/js/jquery-ui-custom.min.js | jQuery-ui-Custom]] (Built by jQGrid folks)
*[[http://www.cparker15.com/code/utilities/csv-to-json/ | CSVtoJSON]] (Allows us to pass CSV as a token and convert to JSON within Javascript)
*[["https://github.com/douglascrockford/JSON-js/blob/master/json2.js" | json2 ]] (Used in CSVtoJSON)




July 17, 2013, at 04:57 PM by 75.71.120.47 -
Changed lines 31-39 from:
'''CSS''' The [[http://www.trirand.com/blog/ | JQGrid]] plug-in uses themes built with the [[http://jqueryui.com/themeroller/| jQuery UI Theme Roller]].  We've created a [[http://jqueryui.com/themeroller/#!zThemeParams=5d000001001406000000000000003d8888d844329a8dfe02723de3e57031bfe049f4bbfda82bb04620400305ed55a625997824a99ed436ffeeef18133f377f7e7486b7f8525d9d0b24fd32daa7619458a3ab42bb90979ce442f142e94f5fb9f2149db0364976b76de09766da2cd02061d7cc3ab648a195ee9bee9fb9a77ec095d5131e0302ef8b679e77a36c43ac64eb82388aabae798f47dd9cf27b2b4013763cfdf26a6f320c1ef32141b641d2e329e32b1913b3c97b1af947e2a3b6dc73448cc7da4bb4682d793229e2d298cde9ef413028c2f047cb75980f8aefac76132289a6dbe52b7f0c173c3770eee71e093c6e1313bcd838bef2a8595b989793f4082450fef34987b065122199e7c9b0887c040db87d123fa3c229b4f3bd542ff90a4c4d5cfef6dcad9e38e0475013125c2fc27f667a5657212b2ce9cb19f2989081a8c1872d1bde051afd52dc1a1c264626bba8b039db23275281a13cd40dc5343e0d7404f1025bac9040274d643f0d2b767cd2109c8f9ff25fa9279fd52cd9a4d83c5070af8298417760c5c5b0b786e98685055408e5050f52544519d1576ac663c0c92415616dc2d3be840ef3b3e79f6885aca02fea7ae301cde1583102bebb81f9fa90049f|custom theme]] that fits nicely with the FileMaker Onyx theme.  If you want to use a different theme you can create it using the Theme Roller and then download it.  Once downloaded, you can go the the SQL Explorer Layout '''css''' and import the CSS into SQL Explorer and change the theme of the web viewer.
to:
'''CSS''' The [[http://www.trirand.com/blog/ | JQGrid]] plug-in uses themes built with the [[http://jqueryui.com/themeroller/| jQuery UI Theme Roller]].  We've created a [[http://jqueryui.com/themeroller/#!zThemeParams=5d000001001406000000000000003d8888d844329a8dfe02723de3e57031bfe049f4bbfda82bb04620400305ed55a625997824a99ed436ffeeef18133f377f7e7486b7f8525d9d0b24fd32daa7619458a3ab42bb90979ce442f142e94f5fb9f2149db0364976b76de09766da2cd02061d7cc3ab648a195ee9bee9fb9a77ec095d5131e0302ef8b679e77a36c43ac64eb82388aabae798f47dd9cf27b2b4013763cfdf26a6f320c1ef32141b641d2e329e32b1913b3c97b1af947e2a3b6dc73448cc7da4bb4682d793229e2d298cde9ef413028c2f047cb75980f8aefac76132289a6dbe52b7f0c173c3770eee71e093c6e1313bcd838bef2a8595b989793f4082450fef34987b065122199e7c9b0887c040db87d123fa3c229b4f3bd542ff90a4c4d5cfef6dcad9e38e0475013125c2fc27f667a5657212b2ce9cb19f2989081a8c1872d1bde051afd52dc1a1c264626bba8b039db23275281a13cd40dc5343e0d7404f1025bac9040274d643f0d2b767cd2109c8f9ff25fa9279fd52cd9a4d83c5070af8298417760c5c5b0b786e98685055408e5050f52544519d1576ac663c0c92415616dc2d3be840ef3b3e79f6885aca02fea7ae301cde1583102bebb81f9fa90049f|custom theme]] that fits nicely with the FileMaker Onyx theme the Explorer uses.  If you want to use a different theme you can create it using the Theme Roller and then download it.  Once downloaded, you can go the the SQL Explorer Layout '''css''' and import the CSS into SQL Explorer and change the theme of the web viewer.

In a few cases we've made some small changes to the CSS to have it fit a little better on the layout and look more "FileMakery."  We wanted to preserve the ease of importing a Theme Roller theme, so rather than messing with the Downloaded CSS, we've added a small section in the HTML template to override the CSS.  If you want to make any additional CSS changes or review the ones we've made, then you can do so in the script '''Configure CSS Overrides.'''

'''Javascript'''  We use 7 Javascript Libraries that are loaded into the temp directory at start-up.

[["http://code.jquery.com/jquery-1.9.0.js"|jQuery v1.90]]

July 17, 2013, at 04:38 PM by 75.71.120.47 -
Changed lines 15-16 from:
'''HTML Template''' On start-up, SQL Explorer creates a large Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache[1]).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like the following example.
to:
'''HTML Template''' On start-up, SQL Explorer creates a Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache[1]).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like the following example.
Added line 31:
'''CSS''' The [[http://www.trirand.com/blog/ | JQGrid]] plug-in uses themes built with the [[http://jqueryui.com/themeroller/| jQuery UI Theme Roller]].  We've created a [[http://jqueryui.com/themeroller/#!zThemeParams=5d000001001406000000000000003d8888d844329a8dfe02723de3e57031bfe049f4bbfda82bb04620400305ed55a625997824a99ed436ffeeef18133f377f7e7486b7f8525d9d0b24fd32daa7619458a3ab42bb90979ce442f142e94f5fb9f2149db0364976b76de09766da2cd02061d7cc3ab648a195ee9bee9fb9a77ec095d5131e0302ef8b679e77a36c43ac64eb82388aabae798f47dd9cf27b2b4013763cfdf26a6f320c1ef32141b641d2e329e32b1913b3c97b1af947e2a3b6dc73448cc7da4bb4682d793229e2d298cde9ef413028c2f047cb75980f8aefac76132289a6dbe52b7f0c173c3770eee71e093c6e1313bcd838bef2a8595b989793f4082450fef34987b065122199e7c9b0887c040db87d123fa3c229b4f3bd542ff90a4c4d5cfef6dcad9e38e0475013125c2fc27f667a5657212b2ce9cb19f2989081a8c1872d1bde051afd52dc1a1c264626bba8b039db23275281a13cd40dc5343e0d7404f1025bac9040274d643f0d2b767cd2109c8f9ff25fa9279fd52cd9a4d83c5070af8298417760c5c5b0b786e98685055408e5050f52544519d1576ac663c0c92415616dc2d3be840ef3b3e79f6885aca02fea7ae301cde1583102bebb81f9fa90049f|custom theme]] that fits nicely with the FileMaker Onyx theme.  If you want to use a different theme you can create it using the Theme Roller and then download it.  Once downloaded, you can go the the SQL Explorer Layout '''css''' and import the CSS into SQL Explorer and change the theme of the web viewer.
July 17, 2013, at 02:12 PM by 75.71.120.47 -
July 16, 2013, at 08:33 PM by 75.71.120.47 -
Changed lines 15-16 from:
On start-up, SQL Explorer creates a large Data URL and stores it in a global field (SQLWizardHome::jsCodeCache[1]).  A few of the references in the HTML are set with placeholder values or Tokens.  These values are determined when the query is run and substituted into the Data URL before loading it into the Web Viewer.  The Tokens are:
to:
'''HTML Template''' On start-up, SQL Explorer creates a large Data URL Template in HTML and stores it in a global field (SQLWizardHome::jsCodeCache[1]).  During this routine, the external references for the Javascript and CSS are exported to the user's temp directory and the HTML references to the temp directory are written to the HTML template like the following example.

<script src="file:///private/var/folders/8w/sgn/T/S10.1/jquery.js" type="text/javascript"></script>

'''Tokens'''
A few of the references in the HTML are set with placeholder values or Tokens.  These values are determined when the query is run and substituted into the Data URL before loading it into the Web Viewer.  The Tokens are:
Changed lines 29-30 from:
More on the last three tokens in the '''JQGrid''' options below.
to:
*More on the last three tokens in the '''JQGrid''' options below.
July 16, 2013, at 08:25 PM by 75.71.120.47 -
Added lines 1-26:
!! A Different Kind of Portal for Displaying Data

SQL Explorer can be used to build a variety of queries that generate all sorts of different types of results.  This makes using a traditional FileMaker Portal, with fixed column widths and data types less than ideal.  We thought we would do some research to see if there was something we could do using a Web Viewer and some HTML 5 and Javascript code in a data url and display our results that way.  We wanted to find something that would allow the user to resize the column widths as well as load initial widths when we ran the query that made sense.

We ended up using the [[http://www.trirand.com/blog/ | JQGrid]] plug-in and found it to be a great fit for the web viewer.  You can check out the Web Viewer Portal in action [[http://www.youtube.com/watch?v=cXwDvhonG5c|here]].  Not only did we get our column resizing, but some great additional functionality as well including:

*Dynamic Column Sorting
*Ellipsis Display (indicating truncated value)
*Dynamic Column Re-Ordering via Drag and Drop

You can also view an expanded view of your results in a full browser window by exporting the Data URL and having FileMaker open it in your default browser.  This view also adds additional search functionality where you can refine your results and copy and paste the search back into your SQL Query.

!! How It Works

On start-up, SQL Explorer creates a large Data URL and stores it in a global field (SQLWizardHome::jsCodeCache[1]).  A few of the references in the HTML are set with placeholder values or Tokens.  These values are determined when the query is run and substituted into the Data URL before loading it into the Web Viewer.  The Tokens are:

*'''<<TIME>>''' The execution time of the query so it can be displayed in the Web Viewer.
*'''<<RESULTS>>''' The execution time of the query so it can be displayed in the Web Viewer.
*'''<<MYDATA>>''' The query results as CSV.

*'''<<SCROLL>>''' The type of scrolling to use based on the size of the found set.
*'''<<COLNAMES>>''' The column names or headers as an array.
*'''<<COLMODEL>>''' Additional column information such as alignment, data type, etc.

More on the last three tokens in the '''JQGrid''' options below.

(855) SEEDCODE
[email protected]
Follow us: