The Lists of Values
Certain fields in forms offer users a choice of values in a grid.
- The list of values is built around a parent query that accesses a set of standardized data from the database.
- You can configure the grid.
- Selection of columns displayed using the parent query fields used to define the list of values.
- Only for Ticket forms, selection of filters that enable users to restrict the display of possible values when running a search on equipment or services.
Examples
- Display a list of values for the Service field.
- Display in the form: Hover over the field and click
.
- Configuration of the grid: Click
.
- Display in the form: Hover over the field and click
- In Ticket forms, propose several filters for displaying equipment only for recipients, their department or their location.
Notes
- Only user profiles authorized to edit display presentations can configure a list of values.
See User Profiles > Edit rights and display rights.
- They can add fields manually to the parent query, as long as they are authorized to edit display presentations.
See User Profiles > Edit rights and display rights.
- Fields are displayed with their alias (or logical name).
- If the alias is not specified, the physical field name will appear.
example
- Alias: Phone, Physical Name: PHONE_NUMBER
- Alias: Serial Number, Physical Name: AM_ASSET.SERIAL_NUMBER
- Filter Management:
- Filters are available to users only in Ticket forms, e.g. quick call, incident, service request, change request, in the Equipment and Service fields.
- The list of filters is provided by EasyVista. You cannot add new ones.
Characteristics specific to versions 2016 and earlier
The configuration of lists of values in versions 2016 and earlier is different.
- Edit rights are assigned to each user profile in the module associated with the menu item using the filter.
See User Profiles.
- You can only configure filters in Quick Call forms, in the Equipment and Service fields.
Access
Click at the top of the window displaying the list of values
Screen description
Name: List of fields defined in one of the tables included in the parent query, joins with SQL views and manually added joined tables.
- Click
to enter the alias in different languages.
Field Name (Note: Non-modifiable): Physical name of the field in the data model.
(Note: Only if the key field can be deleted): Used to indicate whether the field is displayed in the grid (
) or hidden (
).
- Click the icon to toggle between displaying or hiding the field.
AddViewTableField
Add View: Used to link a field from an SQL view with a field in a table joined to the parent query. See How to modify a parent query.
- You will be able to select the SQL view just like any other table in the parent query.
- You can select the type of rows to be returned (Note: Depending on the parent query).
- OUTER option: This will return all records from the main table, even if there are no matches with the SQL view.
- INNER option: This will return only records from the main table that have a match in the joined table. Rows with no matches in the SQL view will be hidden.
- You can give the SQL view an alias when saving.
Add Table: Used to join a table in the parent query with a joined table in the data model. See How to modify a parent query.
- You will be able to select the joined table just like any other table in the parent query.
- For each joined table, the list of joins in the data model will appear as follows: joined table key field / parent query table key field.
- You can select the type of rows to be returned (Note: Depending on the parent query).
- OUTER option: This will return all records from the main table, even if there are no matches with the joined table.
- INNER option: This will return only records from the main table that have a match in the joined table. Rows with no matches in the joined table will be hidden.
- You can give the joined table an alias when saving.
Add Field: Used to add a field to those in the parent query tables, manually added joined tables or SQL views. See How to modify a parent query.
- The field will appear with its alias (or logical name) at the bottom of the list of fields in the parent query.
- It is preceded by the
icon that enables you to delete the field from the query.
- If the alias is not specified, the physical field name will appear.
example
- Alias: Phone, Physical Name: PHONE_NUMBER
- Alias: Serial Number, Physical Name: AM_ASSET.SERIAL_NUMBER
Filter Management: Used to add filters that will be available to users.
Note: Only in Ticket forms, e.g. quick call, incident, service request, change request, in the Equipment and Service fields.
Display: Used to indicate whether the filter is available to the user (box is checked) or not (box is not checked).
- Filters are available depending on the context.
example In the Quick Call screen, the list of values related to the Equipment field will appear
- The Requestor field is specified ==> The Equipment of Requesting Person filter will appear.
- The Requestor field is not specified ==> The filter will not appear.
List of filters: List of filters available for the list of values.
Default Option (Note: Only if the Display box is selected for the filter): Used to indicate whether the filter is enabled by default when the list of values is displayed the first time (box is checked) or not (box is not checked).
- When users next display the list of values, their last choice of filters will be applied instead of the default options. This will be the case until users next open their session.
Procedure: How to configure a list of values
Step 1: Open the window for configuring the list of values.
1. Move the cursor over the field related to a list of values and click .
2. Click at the top of the window displaying the list of values.
Step 2: Configure the list of values.
1. (optional) Click Add Field to make the relevant fields available in the parent query. See How to modify a parent query.
- You can select fields from tables joined to the main table as well as from tables joined to these joined tables. You must first add these tables to the scope of the parent query by clicking Add Table.
See the example in Scope of the parent query.
- You can select fields from SQL views. You must first add these views to the scope of the parent query by clicking Add View.
2. Click to select the columns to be displayed in the grid.
3.(Note: Only in Ticket forms, in the Equipment and Service fields. Select the filters that will be available to users.
- Click Filter Management.
- Select the Display box for the filters that should be proposed when the list of values is opened.
- Select the Default Option box for the filters that should be enabled when the list of values is displayed the first time.
- Click Save.
Step 3: Save and test the list of values.
1. Click Save.
The window for configuring the list of values will close.
2. Check that the results are correctly displayed.
- Move the cursor over the field that uses the list of values and click
.
- Check that the grid displays the configuration defined for the list of values.