Partial field deployment

System

Below is part of my data capture template:

<item name="section">
<label>Section</label>
<description>Section content</description>
<database searchable="f" deploy-column="f"/>
<replicant min="1" max="10" hide-name="f">
<item name="paragraphs">
<label>Paragraph</label>
<description>Max. 2000 chars.</description>
<database searchable="f" deploy-column="f"/>
<textarea required="t" wrap="virtual" cols="40" rows="10" validation-regex="^[\s\S]{1,2000}$"></textarea>
</item>
</replicant>
</item>

I want to deploy the first say 100 characters of the 1st. paragraph in this replicant to a database using datadeploy. What is the correct way of doing this?

Thanx, Burcin

Adam Stoller

Right now you have:
<database searchable="f" deploy-column="f"/>
Which means the particular field won't be deployed at all.

You'd have to get rid of the deploy-column="f" part to begin with and probably include data-type="VARCHAR(100)" in its place.

I'm not positive - but I believe it will automatically truncate the contents to fit within the specified column width. (you'll have to drop your DB tables and re-inialize them with iwsyncdb.ipl when you make this change)


--fish
(Interwoven Senior Technical Consultant)