Open Source Document Management System | OpenKM

select * from OKM_NODE_BASE where NBS_PARENT = '7a583384-8610-41d5-a535-9b8158a821e6';

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.0//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.0.dtd">
<property-groups>
  <property-group label="Doc State" name="okg:docstate">
    <select label="Doc State" name="okp:docstate.select" type="simple">
      <option label="Current" value="001" />
      <option label="WIP" value="002" />
      <option label="Legacy" value="003" />
     </select>
  </property-group>
    <property-group label="SubSystem" name="okg:subsystem">
    <select label="SubSystem" name="okp:subsystem.select" type="simple">
      <option label="RIG" value="001" />
      <option label="CPM" value="002" />
      <option label="SW" value="003" />
        <option label="DSC" value="004" />
        <option label="System" value="005" />
        <option label="User" value="006" />
         <option label="CHW" value="007" />
        <option label="Consumables" value="008" />
     </select>
  </property-group>
    <property-group label="Design Phase" name="okg:designphase">
    <select label="Design Phase" name="okp:designphase.select" type="simple">
      <option label="Charter" value="001" />
      <option label="Scoping" value="002" />
      <option label="Verification and Validation" value="003" />
        <option label="Design Transfer" value="004" />
        <option label="Design Output" value="005" />
     </select>
  </property-group>
    <property-group label="Status" name="okg:status">
    <select label="Status" name="okp:status.select" type="simple">
      <option label="Development" value="001" />
        <option label="Review" value="002" />
      <option label="Training" value="003" />
      <option label="Disposition" value="004" />
        <option label="Complete" value="005" />
     </select>
  </property-group>
 </property-groups>

select NBS_NAME, NPG_GROUP from OKM_NODE_DOCUMENT nd inner join OKM_NODE_BASE nb on nd.NBS_UUID = nb.NBS_UUID inner join OKM_NODE_PROPERTY np on np.NPG_NODE = nd.NBS_UUID where NBS_PARENT = '7a583384-8610-41d5-a535-9b8158a821e6' and NPG_GROUP = 'okg:docstate' and NPG_VALUE = '["001"]';