Reporting SQL Views

Evolve reports work on predefined SQL Views. SQL Views are fixed; you cannot create or modify them.

When you create reports in Evolve, you can view the predefined SQL Views and their fields. And, you can write complex SQL queries to bring data into the reports.

Note:

When creating a SQL query, use only the view name in the FROM clause; do not include the database name or schema. For example: Valid query: Select Column FROM ViewInvalid query: Select Column FROM db.schema.View

SQL Views - Details

Click the links below for details on each individual SQL View.

App Group View

Assignment View

Audit Log View

Custom View

License Counter View

License Details View

Process Reporting Details View

Query ROI View

Solution Reference Entities View

Solution View

Transaction ROI View

User Group Reporting View

User Login History View

User View

Workflow Participation View