EasyVista Discussions Data Source
This data source belongs to the Applications category in the data source library. It is used to define a dynamic data source associated with Service Manager discussions.
- Discussions are displayed using a Discussion widget.
- A filter enables you to display all discussions or only those that the logged-in user is authorized to see.
- A master-detail relationship between a Data Viewer widget and a Discussion widget linked to the data source will display only the discussions related to the current Service Manager object.
See the example.
Notes
See General remarks on data sources.
- Discussions related to the current object are displayed by specifying the master-detail relationship, i.e. the relationship between the Data Viewer widget and the Discussion widget linked to the data source.
See the procedure.
Example
You want to display all discussions on the current problem. See the procedure for the Discussion widget.
List of properties
Content
AliasConnector
Alias/Connector: easyvista IT Service Manager connector used by the data source to access Service Manager.
Filter: Filter used to restrict data from the data source.
- All Discussions: Used to display all the discussions that logged-in users are authorized to see based on their domain and the visibility of the discussion.
- My Discussions: Used to display discussions that:
- Logged-in users are authored.
- to which they contributed.
- To which they were invited by the author.
- They follow.
Preview
Configure Field Types: Used to open the field editor that enables you to select data source fields and specify the type of each field, e.g. date, integer, etc. when this is not automatically detected.
- The
button below the property shows the number of rows (max. 15) and columns extracted. Click to open the editor.
- The button will display No data available as long as you have not selected any of the mandatory elements for the data source.
- In edit mode, only the first 15 data source records are displayed.
- In execute mode, all of the data source records are displayed.
- Data in static data sources comes from the last file upload.
- Data in dynamic data sources is refreshed when you open the app in edit mode.
NoDataMessage
No Data Message: This message is displayed when the data source does not contain any data.
- Enter the code directly in the field or click
to open the text editor.
AutoRefresh
Auto Refresh (Note: Only for dynamic data sources): Used to indicate the automatic refreshment interval for data from the data source in hours/minutes.
- Data is automatically refreshed each time the app is run and each time the page is redisplayed, regardless of whether it is in execute mode or edit mode.
Master/Detail
SectionMasterDetail
Master Datasource: In a master-detail relationship, this is the name of the master data source linked to the current data source.
Master Field: Name of the primary key in the master data source used to establish the link with the current data source.
- As a general rule, it is the PK (Primary Key) column in the Service Manager) table.
Detail Field: Name of the EasyVista data source column identifying the key in the Service Manager table.
- As a general rule, it is the column whose prefix is FK (Foreign Key).
example You want to display all actions (detail data source) associated with an incident (master data source):
- Master Datasource = Incidents data source defined using the Operation > Incidents > All Incidents parent query.
- Master Field = PK identifying the Incident_ID column in the Incidents table.
- Detail Field = FK_AM_ACTION_REQUEST_ID identifying the action number related to the incident.