List 1 "Posts", fields
Title body #comments modified
in this list #comments fields is look up from another list Comments:
List 2 "Comments", fields
title body comments post tilte modified
in this list post "title" field is look up from list 1.
Now I have to form a join
SPQuery to get a comments list modified field.
SPList listFaculty = web.Lists["Posts"]; SPQuery query = new SPQuery(); query.Query = "<where></where>"; query.Joins = "<join Type='Left' ListAlias='Comments'>" + "<eq><fieldref Name='Title' RefType='ID' />" + "<fieldref List='Comments1' Name='ID' /></eq></join>"; query.ProjectedFields = "<field Name='Modified1' Type='Lookup' List='Comments1' ShowField='Modified'/>"; query.ViewFields = "<fieldref Name='Modified1' />"; SPListItemCollection lists = listFaculty.GetItems(query);
I'm getting error
Value does not fall within the range
What am I doing wrong?