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>