You can use custom SQL statements get information about your existing tables and to manipulate your data.

The query builder is in Beta Mode. You can use it to generate your own custom queries for your database to return very specific resultsets or even execute UPDATE, INSERT, or DELETE statements, but of course be careful with these.

If you select a table from the query list and click "show sql," a select statement will appear. Click Run Query to return results.

You can save your queries also. If you have selected a table, then save a query, a link will appear to the right of the query list that you can click on to view the results in your browser and save a menu that will display these results for you. You can also use these results in Portals.

Sharing Information

Use this form to build a widget you can use to share your information...

Input Form Embed:

Add to Dashboard

If you would like to build your own format to display the shared data, enter the HTML template in this box, then click the Build Embed button to build your embed script. Use [square brackets] around field names to represent data elements.