I am trying to develop a workflow to select a user from the OKM_USER table. Following instructions in the 6.3 CE docs with regards to workflow selector (https://docs.openkm.com/kcenter/view/ok ... field.html).
My forms.xml looks like this...
I have confirmed that using "select usr_id from OKM_USER" does extract data from SQL query
My forms.xml looks like this...
Code: Select all
However the selctor is empty when running the workflow and openkm.log shows this...<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE workflow-forms PUBLIC "-//OpenKM//DTD Workflow Forms 2.4//EN"
"http://www.openkm.com/dtd/workflow-forms-2.4.dtd">
<workflow-forms>
<workflow-form task="select-user">
<select label="user" name="user" type="simple"
optionsQuery="select usr_id from OKM_USER" />
</workflow-form>
</workflow-forms>
Code: Select all
2017-12-05 15:19:54,012 [http-bio-10.30.40.185-8180-exec-654] [] ERROR com.openkm.bean.form.Select - Unable to get key values for Select
com.openkm.core.DatabaseException: OKM_USER is not mapped [select usr_id from OKM_USER]
I have confirmed that using "select usr_id from OKM_USER" does extract data from SQL query