No data from Get Items by Query (Many Lists)

by geirmat » Fri Mar 18, 2016 8:10 am

I try to collect project tasks from task lists in various rooms.
The Plumsail action "Get Items by Query (Many Lists)" seems to be perfect for achieving this.
BUT; It does not return any results.

Action:
Get items by query ( <View Scope="RecursiveAll">
<ViewFi... ) from all lists ( Tasks ) and save to Variable: dictionary
CAML:
<View Scope="RecursiveAll">
<ViewFields>
<FieldRef Name='Title' />
</ViewFields>
</View>

Have tried various variations of setting properties fields
- Web Urls
- Site URL
- Admin login
Have also tried to get items from Tasks and DocumentLibrary.
Dictionary ends up blank in all situations.

If I run the same query using action: Get Items by Query, it returns data as expected.

Any tricks or special conditions I need to verify/do in order to get this action to work?

Thanks
Geir
User avatar
geirmat
 
Posts: 31
Joined: Fri Dec 19, 2014 12:13 pm

by Roman Rylov » Sun Mar 20, 2016 8:51 pm

Hello Geir,

Thank you for the message.
Most probably a Task list has a different Base Template number, in my environment, it is 171.
GetItemsByQuery_ManyLists.png
GetItemsByQuery_ManyLists.png (9.65 KiB) Viewed 406 times


UPD: I have just found another issue, looks like "query" and "where" parts were not empty. I think this is a bug and we will fix it for a few days. As workaround you can use some dummy query as example:

Code: Select all
<View>
<Query>
  <Where>
    <Neq>
      <FieldRef Name="ID" />
      <Value Type="Integer">-1</Value>
    </Neq>
  </Where>
</Query>
<ViewFields><FieldRef Name="Title" /></ViewFields></View>
User avatar
Roman Rylov
 
Posts: 330
Joined: Tue Nov 11, 2014 6:25 pm

by geirmat » Wed Mar 23, 2016 11:54 am

Thanks Roman !
That got me rolling again.
Please let me know when the fix is available.
Geir
User avatar
geirmat
 
Posts: 31
Joined: Fri Dec 19, 2014 12:13 pm


Return to Workflow Actions Pack for Office 365