EasyVista Discussions Data Source

Last modified on 2022/05/28 10:52

Apps - Datasource - EasyVista Discussions icon.png  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. Open url.png See the example.

Notes

   Open url.png See General remarks on data sources.

Example

You want to display all discussions on the current problem. Open url.png See the procedure for the Discussion widget.

          Apps - Widget Data Viewer example ev SAS.png

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 Apps - datasources Properties - Preview button.png 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 Apps - Edit Html icon.png 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.

Caution: The updating of data requires additional activity on the Service Apps platform.

Best Practice icon.png  

  • You should define an automatic refreshment interval only if the app is required to constantly display real-time data for long periods of time on screen.

example  View dashboard data

  •  You should not specify an automatic refreshment interval if the app is only used for displaying a snapshot of data.

example  Display a portal where catalogs can be consulted

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.
Tags:
Powered by XWiki © EasyVista 2022