0

The scene is: I've got items using caml on a list view(e.g. previewlist), and I'll have to query again from these items, is it possible using caml to query from SPListItemsCollection? as MSSQL we can do select * from(select * from tablename), but how can we finished that in caml ?

And if that impossible, i'll have to search from those items first and then add the result to a splist or a spview, anybody knows how to do this? (yeah, two diff ideas).

Abdul Rahman
  • 2,097
  • 4
  • 28
  • 36
Lawrence Wu
  • 1
  • 1
  • Did you try the [CAML Query editor](http://www.u2u.be/res/tools/camlquerybuilder.aspx) ? With this tool you can create very complex queries, I think you can do with this tool what you want. – kameny Dec 03 '12 at 13:05
  • If you already have these items fetched, why do you insist on filtering them with CAML rather than iterating over the collection with conventional LINQ or anything? – kamilk Dec 04 '12 at 22:13

1 Answers1

0

Maybe you can try using SourceQuery property, retrieve original query and build new one using operator to combine two queries?

Marek Kembrowski
  • 1,252
  • 9
  • 21