Question & Answer > View Question

Hash variable #process.recordId# in Database Update Tool

Confluence User - 30 Sep, 2021

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.

plugins;hash-variables

1

Confluence User •

30 Sep, 2021 •

confluenceUser •

1 •

confluenceUser •

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"

1

CSV | Excel | XML | PDF

Your answer

Print

Hash variable #process.recordId# in Database Update Tool

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-f0b836fa-551d-417b-854f-83b76bd08af6{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-68f19e99-e905-458a-b536-dbdbe6d6ee87{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer