MS Proj 2007 PSI: ReadResourceAssignments filter question

T

tfz

Hello,

I'm trying to use an XML filter for the ReadResourceAssignments method. I'd
like to find assignments where:
The resource UID is 314f055d-3698-4537-a352-a95563f7e96f
-AND- The custom field with the UID 80ca6b74-1c27-481d-bdc4-6dcdf5f7bea8 has
a text value of "ABCDE".

Listed below is the filter that I've constructed, but I get a
"ResourceFilterInvalid" error when I try to use it. Can someone please point
me in the right direction for what I'm doing wrong?

Thank You!!!!
--tfz

<?xml version="1.0" encoding="utf-16"?>
<Filter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://
www.w3.org/2001/XMLSchema" filterTableName="ResourceAssignment"
xmlns="http://mi
crosoft.com/ProjectServer/FilterSchema.xsd">
<Fields>
<Field tableName="ResourceAssignment" fieldName="RES_UID" />
<Field tableName="ResourceAssignment" fieldName="RES_NAME" />
<Field tableName="ResourceAssignment" fieldName="TASK_UID" />
<Field tableName="ResourceAssignment" fieldName="TASK_NAME" />
<Field tableName="ResourceAssignment" fieldName="ASSN_UID" />
<Field tableName="ResourceAssignment" fieldName="ASSN_START_DATE" />
<Field tableName="ResourceAssignment" fieldName="ASSN_FINISH_DATE" />
<Field tableName="ResourceAssignmentCustomFields"
fieldName="MD_PROP_UID" />
<Field tableName="ResourceAssignmentCustomFields" fieldName="TEXT_VALUE"
/>
</Fields>
<Criteria>
<LogicalOperator logicalOperationType="And">
<FieldOperator fieldOperationType="Equal">
<Field fieldName="RES_UID" />
<Operand xmlns:q1="http://microsoft.com/wsdl/types/"
xsi:type="q1:guid">
314f055d-3698-4537-a352-a95563f7e96f</Operand>
</FieldOperator>
<FieldOperator fieldOperationType="Equal">
<Field fieldName="MD_PROP_UID" />
<Operand xmlns:q2="http://microsoft.com/wsdl/types/"
xsi:type="q2:guid">
80ca6b74-1c27-481d-bdc4-6dcdf5f7bea8</Operand>
</FieldOperator>
<FieldOperator fieldOperationType="Equal">
<Field fieldName="TEXT_VALUE" />
<Operand xsi:type="xsd:string">ABCDE</Operand>
</FieldOperator>
</LogicalOperator>
</Criteria>
</Filter>
 
Top