tags:

views:

123

answers:

1
Q: 

SPSiteDataQuery fails if field of type UserMulti is specified in ViewFields

Hello.

I`m trying to query all task lists. I have modified default Task content type to allow multiple choices for Assigned To field (Internal name - AssignedTo).

My SPSiteDataQuery fails if I specify <FieldRef Name='AssignedTo' /> (Returns no results) If I add Nullable='TRUE' then results are returned but AssignedTo field ends up being null for all records. If i'll add Type='UserMulti', that won't help.

Looks like a very nasty bug. Is there a workaround? (Well, besides looping all task lists and querying...)

Thankyou.

+1  A: 

We faced the same exact issue two months back, I came across this thread , after which I used the Nullable='TRUE' Type='UserMulti' Still then we were not able get it working. And my manager sat with MS support to just find out that Installing the MOSS 2007 SP2 solved the issue with out a code change. You can try out SP2 in case if you haven't already.

Kusek  2009-11-25 11:08:30
Ah, i`v already got SP2. Even the latest cumulative updates for WSS.
Janis Veinbergs  2009-11-25 14:12:20
Maybe there is some problem with cumulative update, because it WAS working before (when i had SP2). Maybe after awhile it will be ok again.
Janis Veinbergs  2009-11-25 15:11:04

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?