Querying
This plugin allows you to perform any SELECT SQL query that you would like to against the Jive application and analytics databases. With this power comes great responsibility. This plugin allows the following to occur once installed:
- You can only perform SELECT queries against the database.
- You will not see more than 50 rows on a single page of results. Otherwise, your application would have the great opportunity to crash.
- Exporting a CSV file in the application will only return the first 1,000 rows. This is to prevent the application from crashing from memory issues.
You can perform a query against the application database by simply going to System > Run Database Queries > Application Database. You will then see a screen similar to the following, where you can run your query:
To perform the query and view the results on the same page, select Query. To export the query to a CSV format, select Export.
The same operations can be applied to the Analytics database by navigating to System > Run Database Queries > Analytics Database. It is required that you have your application configured with Jive's out of the box analytics package.
The results of the query performed can be seen in sets of 10, 20, 30, 40, or 50. You can change the number of rows to see per page at the bottom of the result set window. Here is what a sample result set of options will look like:
