Home
TeamSite
DD Schema for OR Container DCT
jstephan
Hi All,
How to create DB Schema with an OR Container in the DCT? The following schema doesn't work.
Please advice.
DATACATPURE.CFG
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE datacapture SYSTEM "datacapture6.0.dtd">
<data-capture-requirements name="worklist">
<ruleset name="worklist">
<root-container name="worklist" location="worklist">
<item name="position" pathid="position">
<label>Position</label>
<text size="30" />
</item>
<container name="work" location="work" refid="work" default="0" min="0" max="5" combination="or">
<container name="job_1" location="job_1">
<label>Type 1</label>
<item name="file_path" pathid="file_path">
<label>File Path</label>
<text required="t" size="65">
</text>
</item>
</container>
<container name="job_2" location="job_2">
<label>Type 2</label>
<item name="file_path" pathid="file_path">
<label>File Path</label>
<text required="t" size="65">
</text>
</item>
<item name="image_path" pathid="image_path">
<label>Image Path</label>
<text required="t" size="65">
</text>
</item>
</container>
</container>
</root-container>
</ruleset>
</data-capture-requirements>
DATA DEPLOY CONFIG FILE
<dbschema>
<group name="WORKLIST" table="WORKLIST" root-group="yes">
<attrmap>
<column name="POSITION" data-type="NUMBER(10)" value-from-field="worklist/0/position/0" allows-null="no" />
<column name="FILE_PATH" data-type="VARCHAR2(16)" value-from-field="worklist/0/work/[0-5]/job/0/file_path" allows-null="no" />
<column name="IMAGE_PATH" data-type="VARCHAR2(16)" value-from-field="worklist/0/work/[0-5]/job/0/image_path" allows-null="no" />
<keys>
<primary-key>
<key-column name="POSITION"/>
</primary-key>
</keys>
</group>
</dbschema>
Thanks in advance.
John
Find more posts tagged with
Comments
jstephan
Has any one did Datadeploy with OR Container in a DCT???
Kindly advice.
Thanks.