1. Oracle Migration Tool On Demand Guide
  2. Elements and Sections in the List XML Output File

Elements and Sections in the List XML Output File

The following table describes the elements and sections in the list configuration XML output file.

Table Elements and Sections in the List Configuration XML File

Description Element or Section
The <List> section contains all of the information for a single list. 
<data:List>
. . .
</data:List>

<RecordType> contains the system name of the record type for the list.

Note: You cannot change the record type in an existing list.
 
<data:List>
. . .
  <data:RecordType>Account</data:RecordType>
. . .
</data:List>

<ListName> is the name of the list.

Note: You cannot change the name of an existing list.
 
<data:List>
. . .
  <data:ListName>Western Region Accounts</data:ListName>
. . .
</data:List>

<ListType> is the type of list. The valid values are: Private, Public, Role Specific.

Note: When a new list is inserted, if the type is not specified, and if the <UserSignInId> element is also not specified, then the list is created as a private list for the currently logged-in user. You cannot change the type of an existing list.
 
<data:List>
. . .
  <data:ListType>Public</data:ListType>
. . .
</data:List>

For private lists only, <UserSignInId> contains the sign-in ID of the user who owns the list.

 
<data:List>
. . .
  <data:UserSignInId>SCompany/JLEE</data:UserSignInId>
. . .
</data:List>

<CreatedByAlias> is the alias of the user who created the list. When a new list is inserted, the CreatedByAlias field on the list is always set to the identifier of the currently logged-in user.

 
<data:List>
. . .
  <data:CreatedByAlias>jlee</data:CreatedByAlias>
. . .
</data:List>

<ModifiedByAlias> is the alias of the user who last modified the list. When a new list is inserted or an existing list is updated, the ModifiedByAlias field on the list is always set to the alias of the currently logged-in user.

 
<data:List>
. . .
  <data:ModifiedByAlias>jlee</data:ModifiedByAlias>
. . .
</data:List>

For role-specific lists only, <RoleName> is the name of the role to which the list is applicable.

 
<data:List>
. . .
  <data:RoleName>Senior Field Services</data:RoleName>
. . .
</data:List>

<CreatedById> is the identifier of the user who created the list. When a new list is inserted, the CreatedByID field on the list is always set to the identifier of the currently logged-in user.

 
<data:List>
. . .
  <data:CreatedById>IQA2-13BMET</data:CreatedById>
. . .
</data:List>

<ModifiedById> is the identifier of the user who last modified the list. When a new list is inserted or an existing list is updated, the ModifiedById field on the list is always set to the identifier of the currently logged-in user.

 
<data:List>
. . .
  <data:ModifiedById>IQD3-15BMAT</data:ModifiedById>
. . .
</data:List>

<CreatedDate> is the date and time the list was created.

 
<data:List>
. . .
  <data:CreatedDate>10/26/2020 10:12:40</data:CreatedDate>
. . .
</data:List>

<ModifiedDate> is the date and time the list was last modified.

 
<data:List>
. . .
  <data:ModifiedDate>11/10/2021 09:10:15<</data:ModifiedDate>
. . .
</data:List>

<Description> is a description of the list.

 
<data:List>
. . .
  <data:Description></data:Description>
. . .
</data:List>

<SearchIn> is the record set from which records are returned. The valid values are:

  • All records I can see

  • All records I own

  • All records where I am on the team

  • All records I or my subordinates own

  • All records where I or my subordinates are on the team

  • My Default Book

In addition to the above values, the <SearchIn> element can specify the name of a book. For Upsert operations, the book must already exist in the target environment.

 
<data:List>
. . .
  <data:SearchIn>All records I can see</data:SearchIn>
. . .
</data:List>

<CaseInsensitiveFlag> specifies whether fields are case insensitive (true) in the search or case sensitive (false).

 
<data:List>
. . .
  <data:CaseInsensitiveFlag>true</data:CaseInsensitiveFlag>
. . .
</data:List>

<LanguageCode> is the language code for the currently logged-in user, if the list is a system list. For other lists, <LanguageCode> is the language code in which the list was created. For the list of language codes, see Language Codes and Their Corresponding Language and Country. If a language code is not specified when a new list is inserted, then the language code of the currently logged-in user is used.

Note: You cannot change the language code of an existing list.
 
<data:List>
. . .
  <data:LanguageCode>ENU</data:LanguageCode>
. . .
</data:List>

The <ListOfFilterInformation> section contains the filter information for the list.

 
<data:List>
. . .
  <data:ListOfFilterInformation>
. . .
  </data:ListOfFilterInformation>
. . .
</data:List>

The <FilterInfo> section contains the information for one filter.

 
<data:List>
. . .
  <data:ListOfFilterInformation>
    <data:FilterInfo>
. . .
    </data:FilterInfo>
  </data:ListOfFilterInformation>
. . .
</data:List>

<Conjunction> is the operator, And or Or. If a conjunction is not specified when a new list is inserted, then the And conjunction is used.

 
<data:List>
. . .
  <data:ListOfFilterInformation> 
    <data:FilterInfo>
      <data:Conjunction>And</data:Conjunction>
. . .
    </data:FilterInfo>
. . .
</data:ListOfFilterInformation>
. . .
</data:List>

<FieldName> is the system name of the field.

 
<data:List>
. . .
  <data:ListOfFilterInformation>
    <data:FilterInfo>
. . .
      <data:FieldName>Name</data:FieldName>
. . .
    </data:FilterInfo>
. . .
  </data:ListOfFilterInformation>
. . .
</data:List>

<Condition> is the condition for the filter.

For information about which filter conditions are valid for the various field types, see Oracle CRM On Demand Online Help.

 
<data:List>
. . .
  <data:ListOfFilterInformation>
    <data:FilterInfo>
. . .
      <data:Condition>Equal to</data:Condition>
. . .
    </data:FilterInfo>
. . .
  </data:ListOfFilterInformation>
. . .
</data:List>

<FilterValue> is the value for the filter.

 
<data:List>
. . .
  <data:ListOfFilterInformation>
    <data:FilterInfo>
. . .
      <data:FilterValue>USD</data:FilterValue>
. . .
    </data:FilterInfo>
. . .
  </data:ListOfFilterInformation>
. . .
</data:List>

<FilterValueAssocId> is the association ID (row ID) for a filter value for association control fields such as Contact Full Name, Account Name, Owner Alias, and so on, where the condition is Equal to.

 
<data:List>
. . .
  <data:ListOfFilterInformation>
    <data:FilterInfo>
. . .
      <data:FilterValueAssocId></data:FilterValueAssocId>
    </data:FilterInfo>
. . .
  </data:ListOfFilterInformation>
. . .
</data:List>

The <ListOfSelectedFields> section contains the fields selected for display in the search results.

 
<data:List>
. . .
  <data:ListOfSelectedFields>
. . .
  </data:ListOfSelectedFields>
. . .
</data:List>

The <SelectedFieldInfo> section contains the information for one field.

 
<data:List>
. . .
  <data:ListOfSelectedFields>
. . .
    <data:SelectedFieldInfo>
. . .
    </data:SelectedFieldInfo>
</data:>
. . .
</data:List>

<SelectedField> is the system name of the field.

 
<data:List>
. . .
  <data:ListOfSelectedFields>
. . .
    <data:SelectedFieldInfo>
      <data:SelectedField>Name</data:SelectedField> 
. . .
    </data:SelectedFieldInfo>
. . .
  </data:ListOfSelectedFields>
. . .
</data:List>

<SortOrder> is the sort order of a field used for sorting the search results: ASC for ascending or DESC for descending. If the sort order is not specified, then the sort order is ascending by default.

 
<data:List>
. . .
  <data:ListOfSelectedFields>
. . .
    <data:SelectedFieldInfo>
. . .
      <data:SortOrder>ASC</data:SortOrder> 
. . .
    </data:SelectedFieldInfo>
. . .
  </data:ListOfSelectedFields>
. . .
</data:List>

<SortPosition> is the position of a field within the list of fields used for sorting.

 
<data:List>
. . .
  <data:ListOfSelectedFields>
. . .
    <data:SelectedFieldInfo>
. . .
      <data:SortPosition>1</data:SortPosition> 
    </data:SelectedFieldInfo>
. . .
  </data:ListOfSelectedFields>
. . .
</data:List>