Creating Product Validation Expression Rules
The Product Validation Expression list allows you to create rules based on expressions that are true or false. If the expression is true, the application displays the error message that you select in the Message field.
This list allows you to create a number of different types of expressions. You may create only one type of expression in each rule.
For example, you can use the Search Expression field to create an expression in Siebel Query Language, such as [Quantity] > 2. If the value in the Quantity field is greater than 2, this expression evaluates as true, and the error message is displayed.
To create product validation rules
Navigate to the Administration - Product screen, then the Products view.
Click the Product Validation view tab.
In the link bar of Product Validation view, click Product Validation Expression Rules.
Add new records to the Product Validation Expression Rules list and complete the necessary fields.
The following table includes some sample simple expression rules that you could use to validate network ordering. The first six columns contain the values you enter in each record, and the last column contains an explanation of what this rule does. For more information about network ordering, see Siebel Order Management Guide Addendum for Industry Applications.
Seq | Error Text | Search Expression | Aggregate Function | Group By Fields | Having Expression | Explanation |
---|---|---|---|---|---|---|
1 |
[Count] [Product]s are missing Service Addresses |
([Network Element Type] = "Network Node" AND [Service Address] = "") |
Count |
[Product Name] | [Count]>0 |
Validates that all Nodes have a Service Address. |
2 |
[Count] [Product] are missing a "Service Address" and/or a "To Service Address " |
([Network Element Type] = "Network Connection" AND (([Service Address] = "") OR ([To Service Address] = ""))) |
Count |
[Product Name] | [Count]>0 |
Validates that all Connections have a Service Address associated with each end of the connection. |
3 |
[Product] at [Service Address] must have a different "To Service Address " |
([Network Element Type] = "Network Connection" AND ([Service Address] = [To Service Address])) |
Not applicable. |
Not applicable. |
Not applicable. |
Validates that the Addresses for each end of a connection are different. |
4 |
[Count] [Product] are missing a From Node and/or To Node |
([Network Element Type] = "Network Connection" AND ([Node] = "" OR [To Node] = "")) |
Count |
[Product Name] | [Count]>0 | Validates that all connections have a node associated with each end of the connection. |
In addition to the fields described in the previous table, use the Message field to select a message associated with the expression.
After this is setup, whenever a customizable product is validated, for each item in that current instance of the product, each expression rule is processed once. If any expression matches the current row, then the message associated with that rule is displayed.