Using HSQL Database

[rafal]

Hello,
How can I use default database OKM_APP in workflow? When I tried

Code: Select all

<suggestbox table="OKM_USER" dialogTitle="Reciver" name="Reciver" filterQuery="select $USR_ID from OKM_USER" label="reciver" valueQuery="select $USR_ID from OKM_USER" />

OpenKM says "OKM_USER is not mapped [select $USR_ID from OKM_USER]".
Can you help me?

[jllort]

Suggest box only can working with metadata tables not with other tables.

For this case you should use normal list, and values should be listed on a variable ( var=some variable ) during workflow task execution, that's the idea.