Page 1 of 1

Metadata expiration document

Posted: Mon Mar 20, 2017 2:46 pm
by dzwyw2
Hello,
how can I change the XML Metadata of the expiration document so as to allow the selection of the user with which they are logged in?....I have highlighted the relevant point

Code: Select all

<property-groups>
  <property-group label="Scadenza" name="okg:expiration">
    <input label="Data scadenza" name="okp:expiration.date" type="date">
      <validator type="req"/>
    </input>
    <select label="Stato" name="okp:expiration.state" type="simple">
      <option label="Notifica" value="notify"/>
      <option label="Valido" value="valid" selected="true"/>
      <option label="Scaduto" value="expired"/>
      <validator type="req"/>
    </select>
    <select label="Notifica prima della scadenza" name="okp:expiration.group.alert" type="multiple" table="group"
           optionsQuery="select $gru_name, $gru_name from DatabaseMetadataValue dmv where dmv.table='group' and [b]$gru_name=userId[/b] group by $gru_name">
      <validator type="req"/>
    </select>
    <select label="Notifica la scadenza" name="okp:expiration.group.expired" type="multiple" table="group"
            optionsQuery="select $gru_name, $gru_name from DatabaseMetadataValue dmv where dmv.table='group' group by $gru_name">
      <validator type="req"/>
    </select>
  </property-group>
</property-groups>

Re: Metadata expiration document

Posted: Tue Mar 21, 2017 7:15 pm
by jllort
I do not know if I understood you exactly, but seems you want in the list be shown only the logged users in that moment. Is that ?

Re: Metadata expiration document

Posted: Wed Jun 07, 2017 1:18 pm
by dzwyw2
I have several clients who need to access to the Document System and each customer has its own specific suppliers.
Suppliers of one customer do not have to see the suppliers of other customers. Is there a workaround to avoid this?
Example:
Customer: Pfizer - Suppliers: Coisystem, Compass
Customer: Autostar - Suppliers: Riparauto, Officinacar

When Coisystem users enter a deadline for a document, they should not see Riparauto and Officinacar users

Re: Metadata expiration document

Posted: Thu Jun 08, 2017 7:05 am
by jllort
From community version it's not possible, you need filtering the second select based in first select value. Professional version have support for it, but community version still not https://docs.openkm.com/kcenter/view/ok ... field.html