Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

CAML Query Problem or Bug??

  Asked By: Shasta    Date: Mar 22    Category: Sharepoint    Views: 1927

I encountered some problems while trying to create a DataForm Task Roll-Up
webpart. All worked fine till i enabled multiple user selection on an task
list. After i enable this the tasks are no longer roll-upped. while the
result in @AssignTo only contains an extra name when you add an person. I
asked some collegea's and tried my friend google. But nothing that's any
help to solve this. I only found a site where someone had exactly the same
problem he also has this scenario:

> In task list in AssignTo field when "Allow multiple selections" value set
> to
> 'No", everything works fine.
> In task list in AssignTo field when "Allow multiple selections" value set
> to
> 'Yes, I get empty data.

This is the CAML Query i used to query all the task lists:

<View>
<ViewFields>
<FieldRef Name="ID"/>
<FieldRef Name="ContentType"/>
<FieldRef Name="Title"/>
<FieldRef Name="AssignedTo"/>
<FieldRef Name="Status"/>
<FieldRef Name="StartDate"/>
<FieldRef Name="DueDate"/>
<FieldRef Name="Created"/>
<FieldRef Name="FileDirRef"/>
<FieldRef Name="PermMask"/>
</ViewFields>
<Query>
<OrderBy>
<FieldRef Name="Status" />
</OrderBy>
<Where>
<Or>
<Eq>
<FieldRef Name="AssignedTo" />
<Value Type="Integer">
<UserID Type="Integer" />
</Value>
</Eq>
<IsNull>
<FieldRef Name="AssignedTo" />
</IsNull>
</Or>
</Where>
</Query>
<QueryOptions>
<ViewAttributes Scope='Recursive' />
</QueryOptions>
</View>

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on CAML Query Problem or Bug?? Or get search suggestion and latest updates.




Tagged: