Clarity

We have a process that converts an application request object to an application object. This process uses a mapping code. This mapping code is stored in the database. I can view the entry if i query my database:

select * from odf_object_mapping;

Is there a way to xog out the mapping code to see the mapping schema (which field is mapped to which field)?

bellow is the object mapping_write.xml xog file sample. I would like to get the xog out from our database. 

Any help?

Thanks,

-George

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../xog/src/webroot/WEB-INF/xog/xsd/nikuxog_objectMapping.xsd">
<Header action="write" externalSource="NIKU" objectType="objectMapping" version="8.0"/>
<objectMappings>
<objectMapping mappingCode="ideaToProjectMap" srcObjectCode="idea" destObjectCode="project">
<nls description="Map From Idea to Project" languageCode="de" name="ideaToProjectMap"/>
<nls description="Map From Idea to Project" languageCode="en" name="ideaToProjectMap"/>
<nls description="Map From Idea to Project" languageCode="es" name="ideaToProjectMap"/>
<nls description="Map From Idea to Project" languageCode="fr" name="ideaToProjectMap"/>
<nls description="Map From Idea to Project" languageCode="ja" name="ideaToProjectMap"/>
<nls description="Map From Idea to Project" languageCode="nl" name="ideaToProjectMap"/>
<attributeMappings>
<attributeMapping srcAttributeCode="name" destAttributeCode="name"/>
<attributeMapping srcAttributeCode="currency_code" destAttributeCode="currency_code"/>
<attributeMapping srcAttributeCode="schedule_start" destAttributeCode="budget_cst_start"/>
<attributeMapping srcAttributeCode="schedule_finish" destAttributeCode="budget_cst_finish"/>
</attributeMappings>
<objectMapping mappingCode="subObjectMap" srcObjectCode="sub_idea"
destObjectCode="sub_project" expression="sub_idea.is_cost == 1">
<nls description="Map From Sub Idea to Sub Project" languageCode="de" name="subMap"/>
<nls description="Map From Sub Idea to Sub Project" languageCode="en" name="subMap"/>
<nls description="Map From Sub Idea to Sub Project" languageCode="es" name="subMap"/>
<nls description="Map From Sub Idea to Sub Project" languageCode="fr" name="subMap"/>
<nls description="Map From Sub Idea to Sub Project" languageCode="ja" name="subMap"/>
<nls description="Map From Sub Idea to Sub Project" languageCode="nl" name="subMap"/>
<attributeMappings>
<attributeMapping srcAttributeCode="code" destAttributeCode="code"/>
<attributeMapping srcAttributeCode="name" destAttributeCode="name"/>
<attributeMapping srcAttributeCode="is_multi_value" destAttributeCode="ps_multi_value"/>
<attributeMapping srcAttributeCode="is_start_date" destAttributeCode="ps_start_date"/>
<attributeMapping srcAttributeCode="is_finish_date" destAttributeCode="ps_finish_date"/>
<attributeMapping srcAttributeCode="is_cost" destAttributeCode="ps_cost"/>
<attributeMapping srcAttributeCode="is_single_attach" destAttributeCode="ps_single_attach"/>
<attributeMapping srcAttributeCode="is_multi_attach" destAttributeCode="ps_multi_attach"/>
</attributeMappings>
<objectMapping mappingCode="subSubMap" srcObjectCode="sub_sub_idea"
destObjectCode="sub_sub_project" expression="sub_sub_idea.iss_cost == 1">
<nls description="Map From Sub Sub Idea to Sub Sub Project" languageCode="de"
name="subSubMap"/>
<nls description="Map From Sub Sub Idea to Sub Sub Project" languageCode="en"
name="subSubMap"/>
<nls description="Map From Sub Sub Idea to Sub Sub Project" languageCode="es"
name="subSubMap"/>
<nls description="Map From Sub Sub Idea to Sub Sub Project" languageCode="fr"
name="subSubMap"/>
<nls description="Map From Sub Sub Idea to Sub Sub Project" languageCode="ja"
name="subSubMap"/>
<nls description="Map From Sub Sub Idea to Sub Sub Project" languageCode="nl"
name="subSubMap"/>
<attributeMappings>
<attributeMapping srcAttributeCode="code" destAttributeCode="code"/>
<attributeMapping srcAttributeCode="name" destAttributeCode="name"/>
<attributeMapping srcAttributeCode="iss_start_date" destAttributeCode="pss_start_date"/>
<attributeMapping srcAttributeCode="iss_finish_date" destAttributeCode="pss_finish_date"/>
<attributeMapping srcAttributeCode="iss_cost" destAttributeCode="pss_cost"/>
</attributeMappings>
</objectMapping>
</objectMapping>
</objectMapping>
<objectMapping mappingCode="copyHandler" srcObjectCode="idea" destObjectCode="project"
className="com.ca.platform.samples.osf.test.object.copyengine.CopyProjectFromIdea">
<nls description="Map From Idea to Project Using a Handler" languageCode="de"
name="copyHandler"/>
<nls description="Map From Idea to Project Using a Handler" languageCode="en"
name="copyHandler"/>
<nls description="Map From Idea to Project Using a Handler" languageCode="es"
name="copyHandler"/>
<nls description="Map From Idea to Project Using a Handler" languageCode="fr"
name="copyHandler"/>
<nls description="Map From Idea to Project Using a Handler" languageCode="ja"
name="copyHandler"/>
<nls description="Map From Idea to Project Using a Handler" languageCode="nl"
name="copyHandler"/>
</objectMapping>
</objectMappings>
</NikuDataBus>

<?xml version="1.0" encoding="UTF-8"?>
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="13.0" action="read" objectType="objectMapping" externalSource="NIKU"/>
<Query>

<Filter name="code" criteria="EQUALS">map_test</Filter>

</Query>
</NikuDataBus>

This did the trick