BPM Method Directive Incompatible Data Type Error

[ckrusen (Calvin Krusen)]

The Query Designer in a BPM Condition only alows you to choose Column Names. You cant edit and add the cast() part.

I think the following will work

1. Add a Variable of type DMR Processing Tableset:
   

2. Add a Fill table by query widget with:
   
   The DMRHead subset query being:
   
   With the columns
   
   the configured mapping:
   

   
   
   with the expression for PurPoint being:
   

Now you have a copy DMRHead, where the PurPoint column actually holds the DMRNum, but as a string.

3. In the condition, make the query:
   
   
   
   (note that UD06.Key1 is linked to DMRHead.PurPoint)
   And don’t forget to add the table criteria for jobNum to UD06

It saves without error, and I believe it should work. But I’m unable to test it.