Appendix A
Copy
<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.