Hi. Tell me please, how can i use Hash Variables with Database Update Tool.

I have activity ID "act-RSS-news". It is connecting with form id "RSSnew". This form use Table Name "RSSnew". Text Field ID 'fldTITLE' have been placed on this form.  Also, i have tool with plugin Database Update Tool with SQL:

INSERT INTO webref_rss_items (title,description,link)VALUES('#form.rssnew.fldtitle#','test','test');

Why it is'nt working? in my database it looks like raws with title="#form.rssnew.fldtitle#".

If i use sql like this:

INSERT INTO webref_rss_items (title,description,link)VALUES('#currentUser.email#','test','test');

I get in my database raws with title="usver@mail.ru". Thus, in this case its working. Why i cant get such result with forms variables?

If i create the same process and the same form and i use the same db BUT in CRM application witch placed after installation, everything works fine...

Help me please:(

PS sorry for my english.

1 Comment

  1. Usver

    Solution: section doesn't have to be binded.

    JSON not working definition: "properties":{"id":"section1","loadBinder":{"className":"org.joget.apps.form.lib.WorkflowFormBinder","properties":}},"visibilityControl":"","visibilityValue":"","storeBinder":{"className":"org.joget.apps.form.lib.WorkflowFormBinder","properties":{}},"label":"???????? RSS ???????"}}]}

    "properties":{"id":"section1","loadBinder":{
    "className":"org.joget.apps.form.lib.WorkflowFormBinder","properties":{}},"visibilityControl":"","visibilityValue":"","storeBinder":{"className":"org.joget.apps.form.lib.WorkflowFormBinder","properties":{}},"label":"???????? RSS ???????"}}]}

    JSON working definition: "properties":{"id":"section1","label":"???????? RSS ???????"}}]}