Create Report using Contacts and Operator table
I want to create a report/view in SM Reporting.
This report will pull source from Contacts and Operator.
For example, I want a report to show Full Name, Operator ID, Dept, User Role, Man Lockout User.
Most of the information I need is in Operator table - except Department name.
So If I build a report from Operator table, how i can 'link' to the Contacts table to extract the Dept of the user?
From my under, your attempting to create an operator table view or chart to display data from operator table, contacts table, and dept table. You should be able to pull the data from other tables by making sure you have the desired field mapping setup within the table "relatedObjectMap". You can check the current available mappings within table "relatedObjectMap" by searching Source Table "operator" and To Table "contacts". If needed, you can create a new mapping for your desired result. Within your view or chart fields, you should be able to select "Contact Name", which would give you a multiselection option to select a field from the contact table. If you select Dept from contact table, you will have another option to drill into a field into the Department table. Selecting a field on a view or chart would look similar to below selections.