Open Source Document Management System | OpenKM

PostPosted:**Wed Aug 31, 2011 3:50 am**

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

PostPosted:**Thu Sep 01, 2011 10:53 am**

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.

PostPosted:**Sat Nov 08, 2014 9:34 am**

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.

PostPosted:**Sun Nov 09, 2014 4:24 pm**

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

Open Source Document Management System | OpenKM

Workflow form - Load values from database to Select box

Workflow form - Load values from database to Select box

Re: Workflow form - Load values from database to Select box

Re: Workflow form - Load values from database to Select box

Re: Workflow form - Load values from database to Select box