Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table FS_STD_CONT_TRANS (TRANS_SETTINGS) as
select to_clob('<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>') || to_clob('
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>')
from dual
1 rows affected

select TRANS_SETTINGS, x.Value
from FS_STD_CONT_TRANS
  cross join xmltable(
  xmlnamespaces(default 'http://tempuri.org/GenericSettingsDataSet.xsd'),
  '/GenericSettingsDataSet/ConfigSettings'
  passing xmltype(TRANS_SETTINGS)
  columns Value CLOB path 'Value'
  ) x
  WHERE TRANS_SETTINGS LIKE '%\\Instem\%'
;


TRANS_SETTINGS
VALUE


<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>
True

<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>
False

<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>
False

<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>
False

<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>
False

<GenericSettingsDataSet xmlns="http://tempuri.org/GenericSettingsDataSet.xsd">
  <ConfigSettings>
    <Key>ActionToggle_FilterFiles</Key>
    <SubKey />
    <Value>True</Value>
    <Required>true</Required>
    <Description>Indicates if the list of files and folders involved in the transfer is to be filtered using the substitution tokens and regex matching settings in the transfer template.</Description>
    <DefaultValue>True</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Filter File List</DisplayName>
    <IsVisible>false</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_TransferCompressedFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Transfer compressed versions of files.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Transfer Compressed Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_OverwriteFiles</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Overwrite destination files on transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Overwrite Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_DeleteDestination</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>Delete all existing files from destination before transfer.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Delete Existing Destination Files</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>ActionToggle_RemoveFolderStructure</Key>
    <SubKey />
    <Value>False</Value>
    <Required>true</Required>
    <Description>If enabled, will remove the folder structure when exporting to the external location.</Description>
    <DefaultValue>False</DefaultValue>
    <EditorType>6</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Remove Folder Structure</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>TransferActions</CategoryKey>
  </ConfigSettings>
  <ConfigSettings>
    <Key>NetworkLocationKey</Key>
    <SubKey />
    <Value>\Instem\alcon\PQ\Submit\ABC Labs</Value>
    <Required>true</Required>
    <Description>Network location for the file transfer.
The following placeholders are accepted: %STUDY_ID% (Study ID), %SPON_ID% (Sponsor ID) and %CONTRIB_ID% (Contributor ID).</Description>
    <DefaultValue />
    <EditorType>5</EditorType>
    <SettingType>1</SettingType>
    <DisplayName>Network Location</DisplayName>
    <IsVisible>true</IsVisible>
    <CategoryKey>ExternalLocation</CategoryKey>
  </ConfigSettings>
  <Categories>
    <Key>TransferActions</Key>
    <Required>false</Required>
    <Description>Actions that can be performed at various stages as part of the transfer process.</Description>
    <DisplayName>Transfer Actions</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>FileSelection</Key>
    <Required>false</Required>
    <Description>Settings that control the files that are included in the transfer.</Description>
    <DisplayName>File Selection</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>ExternalLocation</Key>
    <Required>false</Required>
    <Description>Settings that configure the remote target address or any other information required for the transfer.</Description>
    <DisplayName>External Location</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
  <Categories>
    <Key>SENDActions</Key>
    <Required>false</Required>
    <Description>submit Workflow actions that can be performed on the incoming data.</Description>
    <DisplayName>SEND Processing</DisplayName>
    <IsVisible>true</IsVisible>
  </Categories>
</GenericSettingsDataSet>
\Instem\alcon\PQ\Submit\ABC Labs


select x.Value
from FS_STD_CONT_TRANS
  cross join xmltable(
  xmlnamespaces(default 'http://tempuri.org/GenericSettingsDataSet.xsd'),
  '/GenericSettingsDataSet/ConfigSettings'
  passing xmltype(TRANS_SETTINGS)
  columns Value CLOB path 'Value'
  ) x
  WHERE TRANS_SETTINGS LIKE '%\\Instem\%'
;


VALUE


True

False

False

False

False

\Instem\alcon\PQ\Submit\ABC Labs


select x.Value
from FS_STD_CONT_TRANS
  cross join xmltable(
  xmlnamespaces(default 'http://tempuri.org/GenericSettingsDataSet.xsd'),
  '/GenericSettingsDataSet/ConfigSettings'
  passing xmltype(TRANS_SETTINGS)
  columns Value CLOB path 'Value'
  ) x
  WHERE value LIKE '%\\Instem\%'
;


VALUE


\Instem\alcon\PQ\Submit\ABC Labs


select x.Value
from FS_STD_CONT_TRANS
  cross join xmltable(
  xmlnamespaces(default 'http://tempuri.org/GenericSettingsDataSet.xsd'),
  '/GenericSettingsDataSet/ConfigSettings[Key="NetworkLocationKey"]'
  passing xmltype(TRANS_SETTINGS)
  columns Value CLOB path 'Value'
  ) x
;


VALUE


\Instem\alcon\PQ\Submit\ABC Labs