Hash variable #process.recordId# in Database Update Tool

 
1
0
-1

Hello,

I have set up a Deadline on an activity and I am using "Database Update Tool" to fill some fields in the form data of the request being handled.

As advertised Hash variables are accepted in the SQL Query (#date.yyyy-MM-dd HH:mm# is replaced by currrent timestamp).
But #process.recordId# is not replaced at all (string "#process.recordId#" is sent in the SQL request), I would have expect it to be replaced by UUID of the current record allowing me to update the correct form data (or even by processId if General settings were not set properly)

Note that #process.processId# is also not replaced at all.

On the "monitor tabs"
Process ID81_sio_avis_siosrv
Record IDf2c4065a-4e36-4bdd-a2fc-8dff760980be 

I am running "Version: 7.0.21 - build e989e3b" Community Edition.

Thanks for any help or pointer.



    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      If this can help someone I managed to find one solution to my issue.

      Instead of #process.recordId# I use hash variable #form.tableName.id# to retrieve the UUID of the record, exactly the same way as I do with the "JSON Tool" on "Post Form Submission Processing"

        CommentAdd your comment...