Hello , Can someone give me a brief guide how to put hash variables in mysql or/and database plugin query ?

  • No labels

4 Comments

  1. Tiensoon

    Assuming if you have 1 activity (form) follows by a tool (MySQL Plugin):

    ?| activity | --> | tool |

    In activity form, let's say you have 2 text fields with the following name in the element's "advanced property":

    • groupId
    • groupName

    When you map the tool to MySQL Plugin, you can configure the plugin query as follows (using hash variables), to create a record into dir_group table, using the groupId and groupName submitted from activity form:

    insert into dir_group (id, name) values ('#form.groupId#', '#form.groupName#')

  2. Eduardo Cabrera

    Hi Tiensoon

    I need to know how can i transfer a value of Mysql database table to a workflow variable 

    Thanks

    1. Hugo

      Hi Eduardo,

      Are you referring to the MySQL plugin in Joget v2?

      Anyway, the idea is that you need to make the regular query from your database and run the code found in Setting Workflow Variable Value in Process Tool Bean Shell. That's it!

      Cheers

      1. Eduardo Cabrera

        Hi Hugo.

        Effectively to MySql plugin in Joget v2

        But, as made ??a query to the database from an activity?

        thanks