Can we have conditions or CASE statements in Matchers?
Best Answer
C
Cédric BLANC
said
about 2 years 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
Cédric BLANC
said
about 2 years 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.
Cédric 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.
Cédric 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 275 topics