Advanced Conditions (pdadm6109m200)
Use this session to define advanced conditions to search for entities in PLM tables. The conditions can be grouped by AND or OR.
Note: You can use the option from the menu of this
session to import a search criteria into an open query, from the Advanced Search (pdcom0502m100) session.
Field Information
- Condition Number
- The unique number of the condition.
- And/Or
- The option to group multiple conditions.
- (
- If this check box is selected, the opening bracket is added at the beginning of the condition.
- Table
- The code of the table.
- Description
- The description or name of the code.
- Alias
- The alias used for the table.Note: You can define Alias only if the Source table and the Target table are same.
- Is Text Search
- Indicates if the condition is related to text search.
- Field
- The field for which the condition is defined.
- Operator
-
The operator that determines the action to be performed.
Allowed values
- =
- <>
- >
- >=
- <
- <=
- Starts With
- Does not Start With
- Ends With
- Does not End With
- Contains
- Does not Contain
- Exists
- Not Exists
- Value
-
The value used for the condition.
- Ignore Case
- If this check box is selected, the case (upper or lower) of an alphabet is not considered when the condition is evaluated for the advance search criteria.
- )
- If this check box is selected, the closing bracket is added at the end of the condition.