AnsweredAssumed Answered

Query List Action Filter on External Content Type Column

Question asked by janp on Jun 12, 2015
Latest reply on Jun 19, 2015 by janp

Howdy,

 

I have a question on how to use the Query List Action Filter on External Content Type Column.

 

I have a list of Project Administrators that contain two columns:

Project Admin (Person Type)

Org (External Content Type)

 

I also have another list with Leave Requests. This has a bunch of other columns but the one I'm using for the filter is once again the Org (the same External Content Type). When a user enters time off request and selects the Org in the form (on the Leave Requests), the workflow should go to the Project Admin list (via the Query List Action) and look up the Project Admin using the action filter.

 

The problem I have is that I can't seem to get a match on the Project Admin Content type. (I got it to work when I used a Calculated field of the Org and matched on that or when I changed the Query List filter CAML from <Value Type="BusinessData">A02</Value> to <Value Type="Text">A02</Value>

 

CAML:

<Query>

  <Lists>

    <List ID="{xxx}" />

  </Lists>

  <ViewFields>

    <FieldRef Name="Project_x0020_Administrator" />

  </ViewFields>

  <Where>

    <Eq>

      <FieldRef Name="Org"  />

      <Value Type="BusinessData">A02</Value> <Value Type="Text">A02</Value>

    </Eq>

  </Where>

</Query>

 

I have setup a wildcard and comparison filter Read List operation of the Org External Content Type. The comparison is Code =  Parameter.

The filtering works in searches and on the list filter.

 

There must be an issue with the datatype in the Query filter (like I said I can get it to work with changing the Type="Text") so I was hoping to get someone to point out the "Correct" way of doing this.

 

Thanks!

Outcomes