The condition through which the
To edit the condition
-
In the Manager, select the Attestation > Basic configuration data > Approval procedures category.
-
Select an approval procedure from the result list.
-
Select Change queries for approver selection.
To create single queries
- Click Add.
This inserts a new row in the table.
- Mark this row. Enter the query properties.
- Add more queries if required.
- Save the changes.
To edit a single query
- Select the query you want to edit in the table. Edit the query's properties.
- Save the changes.
To remove single queries
- Select the query you want to remove in the table.
- Click Delete.
- Save the changes.
Property |
Description |
---|---|
Approver selection |
Query identifier that determines the attestors. |
Query |
Database query for determining the attestors. The database query must be formulated as a select statement. The column selected by the database query must return a UID_Person. Every query must return a value for UID_PWORulerOrigin. A query contains exactly one select statement. To combine several select statements, create several queries. If a DBQueue Processor task is assigned, you cannot enter a query to determine attestors. |
Query for recalculating |
Database query to determine attestation transactions that require recalculation of their attestors. |
Example 1
The attestation cases should be approved by a specific attestor.
Query:
select UID_Person, null as UID_PWORulerOrigin from Person where InternalName='User, JB' |
Example 2
All active compliance rules should be attested by the respective rule supervisor.
Query:
select pia.UID_Person, null as UID_PWORulerOrigin from AttestationCase ac |
join ComplianceRule cr on cr.XObjectKey = ac.ObjectKeyBase and cr.IsWorkingCopy = '0' |
join PersonInBaseTree pia on pia.UID_Org = cr.UID_OrgResponsible and pia.XOrigin > 0 |
where ac.UID_AttestationCase = @UID_AttestationCase |
Taking delegation into account
Determine the UID_PWORulerOrigin in order to notify delegators when the recipient of the delegation has made a decision on an attestation case and thus allow the Web Portal to show if the attestor was originally delegated.
To determine the UID_PWORulerOrigin of the delegation
-
Determine the UID_PersonWantsOrg of the delegation and copy this value as UID_PWORulerOrigin to the query. Use the dbo.QER_FGIPWORulerOrigin table function to do this.
select dbo.QER_FGIPWORulerOrigin(XObjectKey) as UID_PWORulerOrigin
select dbo.QER_FGIPWORulerOrigin(XObjectKey) as UID_PWORulerOrigin
Modified query from example 2:
select pia.UID_Person, dbo.QER_FGIPWORulerOrigin(pia.XObjectKey) as UID_PWORulerOrigin from AttestationCase ac |
join ComplianceRule cr on cr.XObjectKey = ac.ObjectKeyBase and cr.IsWorkingCopy = '0' |
join PersonInBaseTree pia on pia.UID_Org = cr.UID_OrgResponsible and pia.XOrigin > 0 |
where ac.UID_AttestationCase = @UID_AttestationCase |