#pickerFieldCustom Has anyone run into a problem executing a query rule as

Jin Pheh

Certified Associate Developer

over 9 years ago

#pickerFieldCustom
Has anyone run into a problem executing a query rule as part of the saveInto of a custom picker? I'm receiving an error (pasted below) whenever I try to query for an object as part as part of the saveInto of a picker even when the query rule is static (eg: rule!getSomeObjectByID(2). I have verified that the query works on the same form and that the ID passed from the picker is valid. Note: This error occurs in the interface editor and there are no bind variables in use - ie: there are no database writes taking place at the same time.

18:35:10,438 INFO [stdout] (ajp-/0.0.0.0:8009-12) 2016-03-07 18:35:10,435 [ajp-/0.0.0.0:8009-12] ERROR org.hibernate.transaction.JDBCTransaction - JDBC commit failed
18:35:10,438 INFO [stdout] (ajp-/0.0.0.0:8009-12) java.sql.SQLException: Commit can not be set while enrolled in a transaction

Discussion posts and replies are publicly visible

0 shailendras593 over 9 years ago

Hi jpheh,

Can you please elaborate what values your custom picker exactly shows? Your query rule must be returning a CDT structure whereas the custom picker only shows single values rather than a dictionary structure. Probably that's the reason, you are running in this issue. You can try saving a particular field of query rule outcome into the custom picker variable. Like a!save(local!customPick,rule!getSomeObjectByID(2).ABC)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jin Pheh
Certified Associate Developer
over 9 years ago

Hi Shailendras, Sorry I wasn't more clear above. The picker itself is working exactly as desired. What I'm trying to do though is that when a user picks an object from the picker I save not only the ID of that object but a copy of the CDT as well.
The copy of the CDT would be saved to a variable that isn't used directly by the picker at all.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@jpheh Have you had a look at the Hotfixes? I see that a resolved issue has been present with respect to the usage of CDTs under some circumstances which aren't elaborated in the hotfix:

AN-65943 - Medium
Using CDTs with the SAIL custom picker component no longer causes an error under some circumstances. This updates the behavior to be consistent with Appian 7.11 and earlier.

FYI, the resolved issue mentioned above has been listed in the latest hotfix of 7.10, 7.11 and 16.1.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel