XOG All Users With Wildcard Filter Does Not Work
search cancel

XOG All Users With Wildcard Filter Does Not Work

book

Article ID: 234032

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

1. When xogging resources out with (rsm_resources_read.xml) 

<Filter name="resourceID" criteria="EQUALS">*</Filter>       

It works as it retrieves the resource records.

2. However, when xogging users with (cmn_users_read.xml)
<Filter name="userName" criteria="EQUALS">*</Filter>

Output : 
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">
  <Header action="write" externalSource="NIKU" objectType="user" version="16.0.0.890"/>
  <Users/>
  <XOGOutput>
    <Object type="user"/>
    <Status state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
    <Records/>
  </XOGOutput>
</NikuDataBus>

It does not retrieve any records.

 

 

Resolution

Commenting out the filters will result in all records being returned.
Due to performance, it is best to use a filter when using XOG and in batches.