Hello,
I would to now if it possible to personalized the fallback value parameter with some SQL?
In my case, what I want to obtain is the following :
- If the lookup does return nothing with the lookup_value, use the following fallback value instead "SPLIT_PART('lookup_value', '_', 3)"
If is not possible, what are the possibilities with custom SQL parameters? Since the documentation does not give a complete example of custom sql.
Thanks!
Hi Aubin,
hopefully, I got your question right.
Your semQL could look like this :
SPLIT_PART(coalesce(<your lookup expression>, '<you_fallback_value>'), '_', 3)
If I got it wrong, please provide a very simple case with data to help me help you!
I hope this helped.
Best regards,
Stéphanie.
Hello Stephanie,I've tried to add custom SQL in the parameter "Fallback value" but it takes the code as a string, it does take it as a code to interpret. Anyway, thanks for the help.
Aubin JONCOUR
Hello,
I would to now if it possible to personalized the fallback value parameter with some SQL?
In my case, what I want to obtain is the following :
- If the lookup does return nothing with the lookup_value, use the following fallback value instead "SPLIT_PART('lookup_value', '_', 3)"
If is not possible, what are the possibilities with custom SQL parameters? Since the documentation does not give a complete example of custom sql.
Thanks!
Hi Aubin,
hopefully, I got your question right.
Your semQL could look like this :
If I got it wrong, please provide a very simple case with data to help me help you!
I hope this helped.
Best regards,
Stéphanie.
- Oldest First
- Popular
- Newest First
Sorted by Newest FirstAubin JONCOUR
Hello Stephanie,
I've tried to add custom SQL in the parameter "Fallback value" but it takes the code as a string, it does take it as a code to interpret.
Anyway, thanks for the help.
Stéphanie FOURRIER
Hi Aubin,
hopefully, I got your question right.
Your semQL could look like this :
If I got it wrong, please provide a very simple case with data to help me help you!
I hope this helped.
Best regards,
Stéphanie.
-
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 270 topics