| Info | ||
|---|---|---|
| ||
Please Note: This page is still a work in progress. |
Dynamic Reporting in OneGov is a very powerful tool that is primarily used to create custom data sets and reports from data within the site. It is helpful to have an understanding of dataset creation when creating datasets. The purpose of this guide is to give an overview of the core concepts and steps involved in dataset creation so that you can more easily create reports without requiring the aid of an RTVision employee.
...
| Info | ||
|---|---|---|
| ||
The Primary Key from the permitapps table is used as a Foreign Key in the contacts table. This means that there can only one application with an appid of 12 but there may be multiple contacts on that application. By writing a request to the database to see all of the records where the appid is 12 we would be able to see that there is one application and potentially several contacts. |
...
This section of the guide will cover the actual creation of a dataset. Due to the amount of customization available on OneGov, table names and fields are often times different however, there are a number of consistencies which you can view in the Consistent OneGov Tables guide.