Unable to XOG multiple users via "OR" filter

[Devendra Jakhmola]

Hi Team,

I am unable to xog multiple users via below xog code: "PRJ PROJECTS ALLOC ACT ETC READ"

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
<Header version="15.7" action="read" objectType="project" externalSource="NIKU">
<!-- you change the order by simply swap 1 and 2 number in the name attribute -->
<args name="order_by_2" value="name"/>
<args name="order_by_1" value="projectID"/>
<args name="include_tasks" value="false"/>
<args name="include_dependencies" value="false"/>
<args name="include_subprojects" value="false"/>
<args name="include_resources" value="true"/>
<args name="include_baselines" value="false"/>
<args name="include_allocations" value="true"/>
<args name="include_estimates" value="false"/>
<args name="include_actuals" value="false"/>
<args name="include_custom" value="false"/>
</Header>
<Query>
<Filter name="projectID" criteria="EQUALS">PRJ-987310</Filter>
<Filter name="resourceID" criteria="OR">DOSSANPR, ASBERRDK</Filter>
</Query>
</NikuDataBus>


OUTPUT:

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


I need multiple resource and their allocation, so I true both (resource and allocation) in the read file and entered resource ID, however I am not getting neither resource or allocation but output saying "Success":
Kindly do the needful. 

[Martti Kinnunen]

First try a single record with EQUALS
Then set more arguments true like Tasks, ETC and Actuals

Success means that the application (XOG client) competed without crashing.not that the user's wish was fulfilled.

[Devendra Jakhmola]

1. Sure, I will try as you are saying Martti but if I need resource and allocation for multiple users only then ?
2. Yes, EQUALS is working to xog for one resource only.
3. I already tried like: 
<Filter name="resourceID" criteria="EQUALS">DOSSANPR, ASBERRDK</Filter>
but still not working

[Martti Kinnunen]

Trying EQUALS was for eliminating other things and to verify your set up and input are OK.

The only criteria I can recall are EQUALS, OR and BETWEEN.
Eg BETWEEN">A,D<

[Martti Kinnunen]

Tried your input file on my 15.8 and got the same result as ie success with zero records.
There seems to be a space or tab before ASBERRDK but removing that does not help.

Maybe with project object the OR only works with the project filter and not elsewhere.

Open a case with support.

[Devendra Jakhmola]

Yes, I also removed the space between the resources but still no help
Yes, it is showing success but no data or ZERO data

[Devendra Jakhmola]

I used BETWEEN : 
<Filter name="resourceID" criteria="BETWEEN ">DOSSANPR,ASBERRDK,ADERIYM</Filter>
But still not working



Output:

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

[Martti Kinnunen]

I tried OR when XOGing out users and it worked fine.

Maybe only EQUALS works for the second level filter.