Aras Innovator Platform

Appendix A

<export>
 <database
 server="testserver”
 name="InnovatorSulutions_1"
 uid="innovator”
 pwd="password” />
 <languages list="en, de” />
 <itemtype name="ItemType">
 <properties list="label,label_plural,help_url” />
 <where>
 ID in (
 SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’))
 </where>
 </itemtype>
 <itemtype name="Action">
 <properties list="label” />
 <where>
 ID in (
 select ia.RELATED_ID
 from item_action AS ia 
 WHERE (ia.SOURCE_ID IN
 (SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’))))
 </where>
 </itemtype>
 <itemtype name="Field">
 <properties list="label,legend” />
 <where>
 SOURCE_ID in (
 select b.ID
 from Body as b
 where b.SOURCE_ID in
 (
 SELECT f.id
 FROM FORM AS f
 INNER JOIN [VIEW] AS v ON f.ID = v.RELATED_ID
 WHERE (v.SOURCE_ID IN
 (SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’)))))
 </where>
 </itemtype>
 <itemtype name="Filter_Value">
 <properties list="label” />
 <where>
 (SOURCE_ID IN
 (SELECT ID
 FROM LIST
 WHERE (ID IN
 (SELECT DATA_SOURCE
 FROM PROPERTY AS pr
 WHERE (DATA_TYPE = ‘list’) AND (SOURCE_ID IN
 (SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’)))))))
 </where>
 </itemtype> 
 <itemtype name="Grid_Column">
 <properties list="label” />
 </itemtype>
 <itemtype name="PM_ProjectGridLayout">
 <properties list="label” />
 </itemtype>
 <itemtype name="Property">
 <properties list="label” />
 <where>
 SOURCE_ID in (
 SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’))
 </where>
 </itemtype>
 <itemtype name="RelationshipType">
 <properties list="label” />
 <where>
 (SOURCE_ID IN
 (SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’)))
 </where>
 </itemtype>
 <itemtype name="Report">
 <properties list="label” />
 <where>
 ID in (
 select ir.RELATED_ID
 from item_report AS ir
 WHERE (ir.SOURCE_ID IN
 (SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’))))
 </where>
 </itemtype>
 <itemtype name="UserMessage">
 <properties list="text” />
 </itemtype>
 <itemtype name="Value">
 <properties list="label” />
 <where>
 (SOURCE_ID IN
 (SELECT ID
 FROM LIST
 WHERE (ID IN
 (SELECT DATA_SOURCE
 FROM PROPERTY AS pr
 WHERE (DATA_TYPE = ‘list’) AND (SOURCE_ID IN
 (SELECT it.ID
 FROM ITEMTYPE AS it
 INNER JOIN TOC_ACCESS AS ta ON ta.SOURCE_ID = it.ID
 INNER JOIN [IDENTITY] AS idn ON ta.RELATED_ID = idn.ID
 WHERE (idn.NAME != ‘Innovator Admin’) AND (idn.NAME != ‘Administrators’) AND (idn.NAME != ‘Super User’)))))))
 </where>
 </itemtype>
</export>

For instructions on setting up the Configurable InBasket to handle multiple languages, please refer to Section 6.4 in the Aras Innovator 30 - Configurable InBasket guide.