Skip to main content
Nintex Community Menu Bar

Query list filter by AssignedTo

  • April 15, 2019
  • 2 replies
  • 22 views

Forum|alt.badge.img+2

I'm trying to create a workflow which should list all open tasks from a person.

Somehow I cannot filter by the username. It always shows me an empty result, eventhough when I delete the <where> statement, I can see the the AssignedTo value, which I'm filtering for.

I have seen this post, but sadly it doesn't work for me:

Query List action by assigned to

 

Thanks for your help :)

<Query>
  <Lists>
    <List ID="{675F51CD-8654-4CB4-85E1-BE4DAAB73107}" />
  </Lists>
  <ViewFields>
    <FieldRef Name="AssignedTo" />
  </ViewFields>
  <Where>
    <Eq>
      <FieldRef Name="AssignedTo" LookupId="True" />
      <Value Type="User">: i:0#.w|DomainDomainuser</Value>
    </Eq>
  </Where>
</Query>

 

2 replies

Forum|alt.badge.img+9
  • April 15, 2019

You can filter by name as seen in User Information List (sitecollection/_catalogs/users/simple.aspx)

 

<FieldRef Name="AssignedTo" LookupId="False" />
<Value Type="user">name</Value>

 

or by id (Integer value) of User Information List

 

<FieldRef Name="AssignedTo" LookupId="TRUE" />
<Value Type="int">id</Value>


Forum|alt.badge.img+2
  • Author
  • April 24, 2019

<FieldRef Name="AssignedTo" LookupId="TRUE" />
<Value Type="int">id</Value>

 

Workfs for me perfectly. Thank you very much for your advice :)