How to generate partial match on a lookup enricher?
F
Fathia Jama
started a topic
over 2 years ago
Hello, Is there a way in a lookup enricher to instead of having exact match between the lookup value and the lookup column in order to have a result ,to look for a partial match. For example MATCH if the lookup column 'contains' the lookup value ? Thanks in advance
Best Answer
F
Fathia Jama
said
over 2 years ago
Hi Hammad
The Semarchy Lookup Enricher will only ever return one value. So, even it was possible to use a partial match, returning several values is not desired as you do not know which one to pick.
Have you tried using the plug-in parameter 'Custom SQL' with a WHERE clause to identify your desired output?
Regards, Peter
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
Hi Hammad
The Semarchy Lookup Enricher will only ever return one value. So, even it was possible to use a partial match, returning several values is not desired as you do not know which one to pick.
Have you tried using the plug-in parameter 'Custom SQL' with a WHERE clause to identify your desired output?
Fathia Jama
Hello, Is there a way in a lookup enricher to instead of having exact match between the lookup value and the lookup column in order to have a result ,to look for a partial match. For example MATCH if the lookup column 'contains' the lookup value ? Thanks in advance
Hi Hammad
The Semarchy Lookup Enricher will only ever return one value. So, even it was possible to use a partial match, returning several values is not desired as you do not know which one to pick.
Have you tried using the plug-in parameter 'Custom SQL' with a WHERE clause to identify your desired output?
Regards, Peter
Fathia Jama
Hi Hammad
The Semarchy Lookup Enricher will only ever return one value. So, even it was possible to use a partial match, returning several values is not desired as you do not know which one to pick.
Have you tried using the plug-in parameter 'Custom SQL' with a WHERE clause to identify your desired output?
Regards, Peter
-
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 269 topics