I have a requirement to iterate through multiple task lists under SharePoint sites and sub-sites. I am using SPSiteDataQuery to achieve this. I have an issue with fetching the data when the column is of type look-up. I am using following code:
query.ViewFields += "<FieldRef Name=\"Predecessors\" Type=\"Lookup\" Nullable=\"TRUE\" />";
This fetches all the other columns in the datatable, but the value of column Predecessors is always blank for all the rows.
Any pointers in this regard would be very helpful.
Cheers Chitranshi | SharePoint Consultant| Mindfire Solutions