XOG: cmn_users_read.xml produces output xml file with duplicate records if partition model is associated to object RESOURCE

Document ID : KB000048160
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When using a standard cmn_users_read.xml with a single user filter (equals criteria). It produces an XML file with 'x' records. 1 for each of the partitions available on the Settings > Default Partitions page.

Steps to Recreate:

  1. Create Partition model with for example 2 partitions

  2. Add user admin to both partitions.

  3. Add partition model to object RESOURCE

  4. Add partition model to other objects, for example, application, asset, project.

  5. Go to Account Settings -> Default Partitions tab

    Select partitions for UI Theme

    Select partitions for each object: resource, application, asset, project.

  6. XOG out user admin using provided cmn_users_read.xml. Filter only user admin.

    <?xml version="1.0" encoding="UTF-8" ?>

    • <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">

      <Header version="6.0.11" action="read" objectType="user" externalSource="NIKU" />

    • <Query>
      <Filter name="userName" criteria="EQUALS">admin</Filter>
      </Query>
      </NikuDataBus>

  7. Observe output xml file. Search by <User


Expected Results:
output xml file should produce only 1 record

Results Observed:
output xml file has 5 matches of <User. 1 for each of the partitions available on the Settings > Default Partitions page.

(UI Theme, resource, application, asset, project)

Keywords: xog, resource, cmn_users_read.xml, duplicate, records, partition model.

Solution:

Workaround: None

This has been documented as CLRT-73840 and it is targeted for resolution in future release.