cancel
Showing results for 
Search instead for 
Did you mean: 

SQLEXEC not working in Table fields

KalashSharma
Level 4
Hi All,

I want to populate a table column cells with a Dynamic List (please note this is the table field). I have following set in the formula. When I verify using this it doesn't run.

The same SQLEXEC formula runs fine when I do it in a normal non-tabular field.
Is this feature not applicable for tabular fields? Is there something special that needs to be done for this?
36149.png
10 REPLIES 10

Ben.Lyons1
Staff
Staff
For this test I was using 1.2, so you should be okay.

If you want to have Decipher learn the selected dropdown you can set it as a virtual field, which involves selecting the flags Assignable, Virtual an Unique. There were some improvements made to this feature in v2.1, so it might be worth looking into it.

This will store the selected value in the training data and link it to the layout of the document. If you don't want to link the selection to the layout, this wouldn't be the right option.

Thanks

Ben
Ben Lyons
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based