The Lists of Values


Some fields in the forms offer a choice of values displayed as a table. This one can be set:

  • Selection of the columns from the fields that are related to the parent query associated to the list of values;
  • Selection of the filters proposed to the user allows restricting the number of displayed values (eg.: Only the equipment of the beneficiary).

Example

In the Quick Call form, display authorized values for the field Service

1. Hover the mouse over the entry zone, then click on List open icon.png. Value list parameter - Example - Form.png
2. To set the list of values of the table, click on Edit icon.png. Value list parameter - Example - List.png

Notes

  • Only a profile owning the edit rights for the displays to the module to which is attached the related option of menu using the list of values may parametrize this one.
  • You may add other fields manually to the parent query of the list of values, under the condition to own the edit rights for the displays of the module to which is attached the related option of menu using the list of values.
  • Fields added manually appear under their alias name (eg.: Phone); if the alias is empty, the field name in the database is displayed (eg.: PHONE_NUMBER).
  • Filters management is only available on the Quick Call form, on fields Equipment and Service.

Screen description

       Value list parameter.png

Menu access: On any field related to a list of values, Edit icon.png on top of the window

Name: List of fields related to the parent query attached to the list of values, and possible additional fields added manually.

  • You may change the labels of each field.
  • To add others fields: [ ADD VIEW ] or [ ADD TABLE ] then [ ADD FIELD ].

Field Name (Note: Cannot be changed): Physical name of the field in the database model.

Open eye icon.png (Note: Only if the key field can be disabled): The field is visible in the table displaying the list of values; click on the icon to disable it.

Delete icon.png: The field is invisible in the table displaying the list of values; click on the icon to reactivate it.

[ FILTER MANAGEMENT ]

Note: Only available on the Quick Call form, on fields Equipment and Service.
        Value list parameter - Filter.png

Visible: Indicates if the filter is proposed to the user (box is checked) or not (box is not checked). Note: The filters are displayed to the user depending of the context.
         Example documentation icon EN.png Quick Call form, opening the list of values on the field Equipment:

  • The field Requester is entered --> the filter Equipment of Requesting Person is available
  • The field Requester is not entered --> the filter Equipment of Requesting Person is not available

List of Filters (Note: Cannot be changed, delivered by the Logo - EasyVista.png): List of available filters for the list of values.

Default Option (Note: Only available if the box Visible is checked for the filter): Indicates if the filter is enabled by default when the list of values is displayed for the first time (box is checked) or not (box is not checked). Note: When the user displays the list of values the next time, his last filter selections will be used and not the one defined as default option, until the session is closed.

[ ADD VIEW ], [ ADD TABLE ], [ ADD FIELD ]

Allows to add other fields to the parent query.

Procedure: How to set a list of values

1. In a form, hover the mouse over the entry zone of the field related to a list of values, then click on List open icon.png.

2. Click on Edit icon.png to the top of the window of the list of values.

3. If you want to add other fields to the parent query (Note: You need to own a profile with the display rights to the module), click on:

  • [ ADD VIEW ] for fields belonging to SQL views;
  • [ ADD TABLE ] for fields belonging to related tables;
  • [ ADD FIELD ] to select the desired fields;
  • Delete icon.png to clean the list of available fields.

4. Define the characteristics of the list of values:

  • Specify the columns to be displayed: click on Open eye icon.png to delete the display of the field or on Delete icon.png to reactivate it;
  • click on [ FILTER MANAGEMENT ] then check the filters available at the opening of the list of values.

5. Click on [ SAVE ] and close the window.

Tags:
Last modified by Unknown User on 2017/01/09 11:09
Created by Administrator XWiki on 2013/06/05 14:28

Shortcuts

Recent changes
•  Service Manager
•  Service Apps
•  Self Help

Glossary

Powered by XWiki ©, EasyVista 2020