Configure a Data Picker for the Manager
If your Code and Records-based manager includes a data picker or a user data picker, it must be configured to examine and extract the records that should appear on the picker list. To do this, you need to create a database query. (For more information on data pickers, see the Unifier uDesigner User Guide, and for more information on queries, see "Queries" in the Unifier General Administration Guide.
Once you have set up the query or queries for a data picker, and the picker is active in Unifier, the queries will be launched whenever:
- The user clicks the data picker field on a form
- The business process is auto-created
- A record is created or updated through integration (both CSV and Web Services)
- The data picker is updated via reverse-auto-population
For more information on data pickers, see "About Data Pickers" and "About User Data Pickers" in the Unifier uDesigner User Guide.
In addition to setting up queries to extract records for the picker, you can configure the picker to filter the records that the query returns so that only certain records appear on the picker. This is particularly convenient, for example, if the manager attribute form contains a user data picker that automatically assigns users to an object as it is created.
To configure a data picker
- Go to the Company Workspace tab and switch to Admin mode.
- Click uDesigner and select any functional sub-node.
- Open an item from the log (design object).
- Select the design and click Open > Data Picker to open the Data Picker Configuration window.
- In the left pane, click the name of the data picker.
- Create the query.
The query will search the database and extract the records to display on the data picker. The query will filter the records returned from the database according to a condition or conditions you specify. The condition(s) will "test" a field on the form to see if it passes or fails the criteria. If the field passes the criteria, Unifier will include it on the data picker.
- Click the Add button. Unifier displays the Add Query Condition window.
- In the Data Element field, select the field on the business process that you want to test with the condition.
For example, the condition might be that the status field on the shell must be "Active."
The window expands to show an active Condition field and additional fields where you can specify the query criteria.
Note: If any field in the query or queries is subsequently removed from the configurable manager attribute form, the entire query operation will be ignored. That is, if one query fails because a field was removed from the design, Unifier will ignore all the queries. If a field has been removed from a design, you must amend the query.
- In the Condition field, select the condition the value in the field must meet.
The remaining fields on this window vary, depending on the data element and the condition you specified. For help in completing these fields, use the information in the Queries section of the Unifier General Administration Guide to complete the query.
- Repeat steps a through c to include additional query conditions.
- (Optional) Filter the returned records.
This filtering option appears on configurable manager attribute forms that contain user data pickers. This option will filter the list of groups or users that appear on the picker. Use the instructions in the table below to filter the returned records.
- When you have finished, click OK.
In this field: | Do this: |
---|---|
Filter list of Users/Groups based on Project/Shell Membership | Select this checkbox if you want to filter the list of users on the picker to show only those with project or shell membership. In operation, Unifier will auto-populate and reverse-auto-populate the data picker with all users or groups, regardless of this checkbox. However, at runtime, the system will filter the picker for the user if you select this checkbox. Note: If you select this option, the rest of the filtering options will be disabled. |
Group Membership | Select the group from which you want to specify a user or users. The drop-down list shows all the groups that are at the company level. |
Project/Shell Membership. | If you want Unifier to add these users to the shell membership, select the Add user to Project/Shell checkbox. If you want to also add these users to the group under the shell, select the Add user as a member to the selected group checkbox Note: To use this option, the user data picker must be on the upper form, not the detail form. |
Show results matching any condition | If the checkbox is checked, the query conditions will be "OR." When this option is selected, the value in the AND/OR column will be updated to "OR." If the checkbox in unchecked, the value in AND/OR column will be "AND." If the checkbox is checked, then records satisfying any of the query conditions would be displayed at run-time. If the checkbox is unchecked, then records which satisfy all of the query conditions will be displayed. |
See Also
Setting up the Code and Records-based Configurable Manager
Setting Permissions to Import Configurable Managers
Importing Code and Records-Based Configurable Managers
Deleting a Material Inventory Manager
Setting Permissions to Import Classes
Importing Classes for Code and Records-based Configurable Managers
Configure configurable manager classes
Setting Template Administration Permissions
Managing Class Template Sheets (Classic view)
Managing Class Template Sheets (Standard view)
Setting User Permissions for Code and Records-Based Managers
Last Published Monday, August 28, 2023