Workflow form - Load values from database to Select box

[OpenInsight]

Hi

Is it possible to load values from the database reference table to a select input box (dropdown list) in a workflow form.

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE workflow-forms PUBLIC "-//OpenKM//DTD Workflow Forms 1.0//EN"
                                "http://www.openkm.com/dtd/workflow-forms-1.0.dtd">
<workflow-forms>
  <workflow-form task="MyTask">
    <select label="Users" name="users" >
      // option values need to populate from the database
   </select>
    <button label="Submit" />
  </workflow-form>
</workflow-forms>

Thanks in advance

Waruna

[jllort]

If I'm not wrong ! you must load values on a variable ( that must containts input values object ) and assign to the form select the data = variable name. Try first with something more simple that mapping a text value to some input.

[adolf]

I use OpenKM 6.2.1, tomcat 7 version, Windows 7. I have developed a workflow for procurement in my organisation. I would like to know how to store workflow form input data from users assigned tasks. This should be stored in MySQL database for future reference and also how to automatically generate pdf reports after each workflow.

[jllort]

You must upgrade to 6.3.x version. This feature has been introduced in this branch.