Rock 1.6.4 Documentation

Data Toolkit

You're trying to design a simple chart but the SQL query takes a second or two to return results. This means your Dynamic Data block is keeping the page from loading quickly. Worse, you wanted to add one or two more of these charts to your dashboard. If only you could just use an API endpoint to load the data with jQuery after the page loads.

You know exactly how to build the SQL query to find the results you want. You probably already have the query built. Now they tell you it needs to be in a DataView so they can run reports, mail merges, bulk updates, etc. on that data. Well shoot, how are you going to translate this complex query into a DataView?

Feel like you need some more DataView filters? Take a gander at what we have to offer. Poke around and see if any of the filters provide the data you need. If not, you can always request a new filter - or use the SQL Filter to design your own.


Take a look at the documentation for a few examples of some SQL Endpoints and SQL Filters to get you started and to see everything else that you can do with this plugin.


Version History

Documentation

Initial Release

  • SQL API Endpoints
  • Data View Filters:
    • SQL Query
    • Giving Frequency
    • Family Attendance in Group Types
    • Recent Logins