I would like to use a SQL query to find documents that meet a few criteria.
I can use this query to successfully find all documents in a specific folder.
I can use this query to successfully find all documents in a specific folder.
Code: Select all
I would like to additionally filter out documents that have a specific metadata. As an example I would like to additionally filter the above documents to those with metadata of okg:docstate and a value of 001.select * from OKM_NODE_BASE where NBS_PARENT = '7a583384-8610-41d5-a535-9b8158a821e6';
Code: Select all
<?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>