Using lookup tables in Ensemble/Routing Rule/DTL
Does anyone have experience in creating a Business Routing Rule using Exists function?
I've used the comma delimited 'In' function, but I would like more manageability. Entering and remove items from a look up table would be much easier to manage then changing the comma delimited string.
Messages go to error state.
Any help would be appreciated.
This is my first post, so if I am doing anything wrong please let me know.
I found the solution to my problem.
The lookup table name must be in "".
I sure do wish it was documented some where... I looked, but couldn't find it.
Any reference to the documentation would greatly be appreciated!
The documentation is available both in the DTL editor when you use the Exists() method in the Expression Editor for a rule:
And in the Class Reference for Ens.Rule.FunctionSet -- the Exists() Method:
The Class reference is clearer about the table argument being a quoted string.