Data entered into IQ is stored in an Oracle database. A query, using Oracle SQL (Structured Query Language), is required to retrieve data to be included in an IQ Report. Queries are created and defined in List Records. If a query in a List Record is designed to work with a report, the Report is created with the List identified as its Input Source.
The ability to create custom reports in Intranet Quorum is integrated with the Lists Query Builder. When creating a new Report, it is recommended you begin the process from within the List Record to ensure you have a query that will feed the required data to the Report.
To add a new List Record:
Click the module tab (People, Mail, etc.) for the type of List you want to use to create the new report.
Click the Lists submenu link.
Click the Add List action on the Actions menu.
To access an existing List Record:
Click the module tab (People, Mail, Workflow, etc.) for the type of existing list you want to access.
Click the Lists submenu link.
Enter criteria in the Lists search page and click the GO button.
Click the name link for the list you want to access.
The List Record page opens in the Review Query panel for both new and existing lists. The Edit Query panel is where you define the criteria for your query. Data elements you define in the Edit Query panel can be configured as input fields using tools in the Screen Builder panel. In the Report Builder panel, you can determine how the retrieved data is to be organized and sorted for the Report.
Once the report criteria has been defined in the List Record and is ready to be used as the input source for the custom report, then the report can be made available in IQ by creating a report record.