xDM Workflow builder: SemQL condition with Lookup KO
A
Aubin JONCOUR
started a topic
6 months ago
Hello,
I am facing an issue with the router in the workflow builder.
There are two possible routes, depending on the value of child entity in the stepper.
Here is the code of both routes' SemQL condition:
Route 1 :
Lookup
FIRST FamilleAchat.Referent
FROM PreviousDataSet.Tiers.LienTiersBranche.LiensTiersBrancheFamilleAchat
WHERE FamillePrincipale = '1'
End = 'valid_auto'
Route 2 :
Lookup
FIRST FamilleAchat.Referent
FROM PreviousDataSet.Tiers.LienTiersBranche.LiensTiersBrancheFamilleAchat
WHERE FamillePrincipale = '1'
End <> 'valid_auto'
The problem is that it never works because the router is not able to find a "valid route", even though the value is valid_auto...
I also tried to reverse the logic: if value <> valid_auto routs to next task, else end => in all the case it ends the workflow...
I wonder if 'lookups' works in the router condition, since I've added the SemQL in the stepper's form ( without PreviousDataSet ) to check the value, and there it works.
Any help welcome!
Attached the error returned and the workflow screenshot.
Aubin JONCOUR
Hello,
I am facing an issue with the router in the workflow builder.
There are two possible routes, depending on the value of child entity in the stepper.
Here is the code of both routes' SemQL condition:
Route 1 :
Route 2 :
The problem is that it never works because the router is not able to find a "valid route", even though the value is valid_auto...
I also tried to reverse the logic: if value <> valid_auto routs to next task, else end => in all the case it ends the workflow...
I wonder if 'lookups' works in the router condition, since I've added the SemQL in the stepper's form ( without PreviousDataSet ) to check the value, and there it works.
Any help welcome!
Attached the error returned and the workflow screenshot.
Version: 2024.1