Incorrect Relationship in BPM Query; Works in BAQ Designer

,

Something like this should work:

image

Add the var tempTable as shown above

Fill By Query widget

image

Just the ttTable you want to relate to TranGLC, with all fields, no criteria.
image

On the configured mapping, use the Bind Automatically, and then change three fields to expressions:

In the condition’s query, relate like:

image

2 Likes