Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

CAML Query Problem or Bug??

  Asked By: Shasta Fry         Date: Mar 22, 2009      Category: Sharepoint      Views: 826
 

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>


Do you know someone who can help? Share a link to this thread on twitter, or facebook.

Tagged:          

 

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].