Join Spotlight record data with data from the Spotlight group main indicator source
table. Use this database view to examine and share Spotlight results.
To perform detailed analysis and to easily view record details along with the Spotlight weight,
create a database view between the Spotlight table and the record source table, such as incident.
Join the tables so that the Spotlight ID value matches the source record sys_id value. For
example, the Incident Spotlight solution includes the incident_spotlight database view, which
includes the following tables:
From this example, you see the following rules for creating the database view:
- Always include two tables: the spotlight table and the facts table that is the data source
for the Spotlight group main indicator.
- The Where clause for the spotlight table specifies records for which the value of the
spotlight table field is the same as the name of the facts table.
- The Where clause for the facts table specifies records where the sys_id field of the facts
table matches the id field of the spotlight table.
When you have created the database view, use it as the data source for creating reports to
visualize Spotlight results. To get an idea about what kind of reports to design, install the
Incident Spotlight solution and view the included dashboard.