Hi,
I dont have the exact code but what we did recently was
"we will copy all the values in the custom sub object of Investment object and create exact copy instance.
one of the attribute in that custom object is of attachment data type.
when a document is attached we can find
1. Extension of document
2. Language
3. Name of the document in database etc.. ( query to retrieve the details is in the script)
Now we will be having the details of the documents but not the document.So we will select the required details from database and XOG in as the new object instance.
In our case the document is stored in the application server(default path-- C:\niku\clarity\filestore) . we have to know the path where it gets stored.( you can find in properties.xml)
You may get some idea when you go through the below script.
<gel:script
xmlns:x="jelly:xml"
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"
xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sql="jelly:sql"
xmlns:xog="http://www.niku.com/xog"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<gel:parameter var="XOGURL" default="http://excers-18"/>
<gel:parameter var="XOGusername" default="admin"/>
<gel:parameter secure="true" var="XOGpassword" default="Excers_18"/>
<gel:parameter var="Filestore" default="D:\niku\clarity\filestore"/>
<gel:setDataSource dbId="niku"/>
<sql:query var="data">
select i.code,
i.id,
ext.code,
ext.name,
ext.odf_cncrt_parent_id,
ext.odf_parent_id,
ext.partition_code,
ext.created_date,
ext.created_by,
ext.last_updated_by
from
(select * from niku.odf_ca_work_request ext
where ext.copy_request = 1
) ext,
niku.inv_investments i where i.id=ext.ODF_PARENT_ID
and
ext.id = ${gel_objectInstanceId}
</sql:query>
<core:forEach items="${data.rowsByIndex}" trim="true"
var="row_project_query">
<!-- QUERY TO RETRIEVE ATTACHMENT DETAILS-->
<sql:query var="sow">
select convert(VARCHAR(23),files.created_date,126) ,
files.has_all_participants, files.language,files.name, files.num_checkout_days, files.mime_type,
files.versioning_enabled,ver.id,
ver.version_number, convert(VARCHAR(23),files.file_created_date,126), folders.path_name,folders.name
from niku.clb_dms_files files, niku.clb_dms_folders folders , niku.clb_dms_versions ver, niku.clb_dms_histories history
where folders.id=files.parent_folder_id and ver.file_id=files.id and ver.id=history.version_id
and folders.name='attach_sow_doc::ODF::Attribute' and folders.assoc_obj_id = ${gel_objectInstanceId}
</sql:query>
<soap:invoke endpoint="${XOGURL}/niku/xog" var="xog_login">
<soap:message>
<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog">
<soap-env:Body>
<!-- start of XOG script -->
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">
<Header action="write" externalSource="NIKU" objectType="customObjectInstance" overrideAutoNumbering ="false" version="12.0.4"/>
<customObjectInstances objectCode="work_request">
<instance instanceCode= "-1" objectCode="work_request"
parentInstanceCode="${row_project_query[0]}" parentObjectCode="inv">
<CustomInformation>
<ColumnValue name="code">-1</ColumnValue>
<ColumnValue name="name">${row_project_query[3]}</ColumnValue>
<ColumnValue name="odf_parent_id">${row_project_query[5]}</ColumnValue>
<ColumnValue name="odf_cncrt_parent_id">${row_project_query[4]}</ColumnValue>
<ColumnValue name="partition_code">${row_project_query[6]}</ColumnValue>
<ColumnValue name="attach_sow_doc">
<core:forEach items="${sow.rowsByIndex}" trim="true" var="row_sow_query">
<Documents>
<Parent documentLocation="${Filestore}">
<Document fileCreatedDate="${row_sow_query[0]}"
hasAllParticipants="${row_sow_query[1]}" language="${row_sow_query[2]}" name="${row_sow_query[3]}"
numCheckoutDays="${row_sow_query[4]}" mimeType="${row_sow_query[5]}"
versioningEnabled="${row_sow_query[6]}">
<Version id="${row_sow_query[7]}" versionNumber="${row_sow_query[8]}" />
</Document>
</Parent>
</Documents>
</core:forEach>
</ColumnValue>
</CustomInformation>
</instance>
</customObjectInstances>
</NikuDataBus>
<xog:Login xmlns="http://www.niku.com/xog">
<xog:Username>${XOGusername}</xog:Username>
<xog:Password>${XOGpassword}</xog:Password>
</xog:Login>
</soap-env:Body>
</soap-env:Envelope>
</soap:message>
</soap:invoke>
</core:forEach>
</gel:script>