Can we have conditions or CASE statements in Matchers?
Best Answer
C
Cedric Blanc
said
over 1 year ago
A match condition in an xDM Matcher is a WHERE clause. The engine essentially looks for pairs of records by selecting * from record1, record2 where (match condition).
If, by run conditions you mean support a conditional match, the answer is yes. If you wanted to, for example, match records with the same name, with the condition that they are in the same country, you would add that condition as:
'(record1.name = record2.name) AND (record1.country = record2.country)'
"CASE" statements cannot be used in Matchers: a match condition is a WHERE clause expecting a Boolean result, so you are essentially already in a case statement, in the 'when' clause. But the logic you are looking to introduce can be realized using the appropriate combinations of AND and OR.
1 Comment
Cedric Blanc
said
over 1 year ago
Answer
A match condition in an xDM Matcher is a WHERE clause. The engine essentially looks for pairs of records by selecting * from record1, record2 where (match condition).
If, by run conditions you mean support a conditional match, the answer is yes. If you wanted to, for example, match records with the same name, with the condition that they are in the same country, you would add that condition as:
'(record1.name = record2.name) AND (record1.country = record2.country)'
"CASE" statements cannot be used in Matchers: a match condition is a WHERE clause expecting a Boolean result, so you are essentially already in a case statement, in the 'when' clause. But the logic you are looking to introduce can be realized using the appropriate combinations of AND and OR.
Cedric Blanc
Can we have conditions or CASE statements in Matchers?
A match condition in an xDM Matcher is a WHERE clause. The engine essentially looks for pairs of records by selecting * from record1, record2 where (match condition).
If, by run conditions you mean support a conditional match, the answer is yes. If you wanted to, for example, match records with the same name, with the condition that they are in the same country, you would add that condition as:
"CASE" statements cannot be used in Matchers: a match condition is a WHERE clause expecting a Boolean result, so you are essentially already in a case statement, in the 'when' clause. But the logic you are looking to introduce can be realized using the appropriate combinations of AND and OR.
Cedric Blanc
A match condition in an xDM Matcher is a WHERE clause. The engine essentially looks for pairs of records by selecting * from record1, record2 where (match condition).
If, by run conditions you mean support a conditional match, the answer is yes. If you wanted to, for example, match records with the same name, with the condition that they are in the same country, you would add that condition as:
"CASE" statements cannot be used in Matchers: a match condition is a WHERE clause expecting a Boolean result, so you are essentially already in a case statement, in the 'when' clause. But the logic you are looking to introduce can be realized using the appropriate combinations of AND and OR.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 182 topics