Open Source Document Management System | OpenKM

All,

Created a metadata group. One field is a simple select which gets values from okm_user to populate the drop down. It is not working.


<select label="Username" name="okp.IandT.username" type="simple" table="okm_user" optionsQuery="SELECT usr_name FROM okm_user" />

Running the above returns a list usernames from the database query tab. I am using Community Edition 6.3.

Examples show creating our own entries in okm_db_metadata_value. Is this really the case? What is preventing my metadata group from straight up pulling in the info?

I cant get the psql queries to work following the examples, pretty frustrating. Just going to input every user an an option with bothering to even use the DB. I thought this would be fairly straight forward. once again OpenKM proves me wrong..................

Only professional edition allow this kind of query in community edition currently is still not supported. You can compare difference between definition in the community https://docs.openkm.com/kcenter/view/ok ... field.html and the professional https://docs.openkm.com/kcenter/view/ok ... field.html