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 About Data Pickers and About User Data Pickers in the Unifier uDesigner User Guide. For more information on queries, see Queries in the Unifier General Administration Guide.)
After you have set up the query or queries for a data picker, and the picker is active, 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
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, the system 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 check box if you want to filter the list of users on the picker to show only those with project or shell membership. In operation, the system will auto-populate and reverse-auto-populate the data picker with all users or groups, regardless of this check box. However, at runtime, the system will filter the picker for the user if you select this check box. 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 the system to add these users to the shell membership, select the Add user to Project/Shell check box. 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 check box 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 check box is selected, 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 check box is deselected, the value in AND/OR column will be "AND." If the check box is selected, then records satisfying any of the query conditions would be displayed at run-time. If the check box is deselected, 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 Thursday, December 14, 2023