StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Ok I found my answer : </p> <p>You can add a where clause even on the foreign list, but the targeted field can't be a Boolean :( because there are supported types (<a href="http://msdn.microsoft.com/en-us/library/ee535502.aspx" rel="nofollow">ProjectedFields</a>). Actually if you want to filter the foreign list on its specific field, you might wanna declare it in the projected fields element so that they are recognized in your where clause in the Query property of SPQuery. </p> <p>For example, in the previous case, </p> <pre><code> SPList spl = web.GetList(customers); SPQuery query = new SPQuery(); query.Query = @"<Where><And> <Eq><FieldRef Name='Suspended'/><Value Type='Boolean'>0</Value></Eq> <Eq><FieldRef Name='ContinentCountryList' List="CountryList"/><Value Type='Text'>Europe</Value></Eq> </And></Where>"; query.Joins=@"<Join Type='Inner' ListAlias='CountryList'><Eq><FieldRef Name='Country' RefType='Id'/><FieldRef List='CountryList' Name='ID'/></Eq> </Join>"; query.ProjectedFields = "<Field Name='ContinentCountryList' Type='Lookup' List='CountryList' ShowField='Continent'/> </code></pre> <p>Now this is working I'll get not suspended customers from towns in Europe only. So I must reference my foreign field in the projectedFields element. But it's only working with types listed above in the msdn link...</p> <p>too bad for me it was a boolean, I guess I must deal with temporary lists in memory unless you have any other suggestions...</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload