Enter the following information for a risk index function.
Property | Description |
---|---|
Table column (target) |
Table column to be calculated. |
Calculate immediately |
Specifies whether the calculation can be immediately run asynchronously triggered through the DBQueue Processor. If this option is set, the risk index is calculated immediately. For more information, see Start calculation. |
Query |
Query in SQL syntax, which finds the risk index for each object in the target table. |
The columns in the list below must be selected using the query.
-
For maximum and average value calculation types:
- 1st column: XObjectKey of the calculation object as ObjectKeyTarget
- 2nd column: RiskIndex, RiskIndexReduced, or RiskIndexCalculated from one of the source tables as SourceValue
- 3rd column: XObjectKey of the referenced object as ObjectKeySource, if RiskIndexCalculated or RiskIndexReduced is selected for the 2nd column
-
For increment and decrement calculation types:
- 1st column: XObjectKey of the calculation object as ObjectKeyTarget
- 2nd column: 1.0 as SourceValue
Query examples
select a.XObjectkey as ObjectKeyTarget, b.RiskIndex as SourceValue from BaseTreeHasADSGroup a join ADSGroup b on a.UID_ADSGroup = b.UID_ADSGroup
select p.XObjectKey as ObjectKeyTarget, g.RiskIndexCalculated as SourceValue, g.XObjectKey as ObjectKeySource from Person p join ADSAccount g on p.UID_Person = g.UID_Person