sharepointfoundation2010 - SPSiteDataQuery and Look-up column -

i have requirement of iterating multiple tasks list under sharepoint sites , sub-sites. using spsitedataquery achieving this. having issue in fetching data when column of type look-up. using following code:

query.viewfields +=fieldref name=\"predecessors\" type=\"lookup\" nullable=\"true\" /;

(have removed < , " symbol blocking code)

this fetches other columns in datatable value of column predecessors blank rows.

any pointers in regard highly helpful.

cheers chitranshi | sharepoint consultant| mindfire solutions

spsitedataquery not support multiple value columns. however, 1 can filter results using spsitedataquery on column.

in order values of column use spquery iterate through each , every lists can through spsitedataquery.

in approach got list ids of various lists in sites , sub-sites using spsitedataquery , using list ids fetched list , corresponding values look-up column using spquery.

cheers chitranshi | sharepoint consultant| mindfire solutions