4.2.5.1 User Value Map

This feature allows you to create a Data Filter based on any field/column of the table you selected for designing the Form. When a user tries to access the form in the Data Entry Window, data will be filtered and displayed based on the selected field, to the users associated with that column.

Note:

The data type of field/column you select to define the filter should be NUMBER or VARCHAR. The users mapped to the DEFQ form whose assign rights are authorized through “Forms Authorization” can save the filter.

There are two types of filters, Global Data Filter and Custom Data Filter.

Global Data Filter: In this filter, the value will be fetched from the DEFQ_GLOBAL_VALUES table of the Atomic Schema, which is automatically created during information domain creation. The table needs to be populated manually through excel upload. The table contains all the entities and the users mapped to them.

Custom Data Filter: This filter enables the user to provide a custom filter for the form you design. In this filter, you should enter values for all the users mapped to the form manually.

To set a Data Filter:

1. Click User Value Map in the DEFQ- Assign Rights Window. The User Value Map Window is displayed.
2. Select the Global Data Filter option to filter the data globally.
   • Select the field based on which the data should be filtered and displayed for the user, from the Fields to the Display Section.

   Note:

   Normally the user can access all the data from the table whenever the DEFQ Form is created. Based on this filter, the user will be displayed only the data which is mapped to him.
3. Select the Custom Data Filter to provide a custom filter for a specific DEFQ Form.
   • Select User ID from the drop-down list and enter Values for that user. It is mandatory
4. Click Save.