Intersection

To allow users to Intersect queries on the server-side and return only documents that match all the provided sub-queries we have introduced the query intersection feature.

Lets consider a case, where we have a T-Shirt class:

public class TShirt
{
	public string Id { get; set; }

	public int ReleaseYear { get; set; }

	public string Manufacturer { get; set; }

	public List<TShirtType> Types { get; set; }
}

public class TShirtType
{
	public string Color { get; set; }

	public string Size { get; set; }
}

Index:

public class TShirtIndex : AbstractIndexCreationTask<TShirt>
{
	public TShirtIndex()
	{
		this.Map = tshirts => from tshirt in tshirts
							  from type in tshirt.Types
							  select new
								  {
									  Manufacturer = tshirt.Manufacturer,
									  Color = type.Color,
									  Size = type.Size,
									  ReleaseYear = tshirt.ReleaseYear
								  };
	}
}

Few records:

session.Store(new TShirt
	{
		Id = "tshirts/1",
		Manufacturer = "Raven",
		ReleaseYear = 2010,
		Types = new List<TShirtType>
			{
				new TShirtType {Color = "Blue", Size = "Small"},
				new TShirtType {Color = "Black", Size = "Small"},
				new TShirtType {Color = "Black", Size = "Medium"},
				new TShirtType {Color = "Gray", Size = "Large"}
			}
	});

session.Store(new TShirt
{
	Id = "tshirts/2",
	Manufacturer = "Wolf",
	ReleaseYear = 2011,
	Types = new List<TShirtType>
			{
				new TShirtType { Color = "Blue",  Size = "Small" },                                    
				new TShirtType { Color = "Black", Size = "Large" },
				new TShirtType { Color = "Gray",  Size = "Medium" }
			}
});

session.Store(new TShirt
{
	Id = "tshirts/3",
	Manufacturer = "Raven",
	ReleaseYear = 2011,
	Types = new List<TShirtType>
			{
				new TShirtType { Color = "Yellow",  Size = "Small" },
				new TShirtType { Color = "Gray",  Size = "Large" }
			}
});

session.Store(new TShirt
{
	Id = "tshirts/4",
	Manufacturer = "Raven",
	ReleaseYear = 2012,
	Types = new List<TShirtType>
			{
				new TShirtType { Color = "Blue",  Size = "Small" },
				new TShirtType { Color = "Gray",  Size = "Large" }
			}
});

Now we want to return all the T-shirts that are manufactured by Raven and contain both Small Blue and Large Gray types. To do this, we just need to use Intersect query extension from Raven.Client namespace

session.Query<TShirt>("TShirtIndex")
	   .Where(x => x.Manufacturer == "Raven")
	   .Intersect()
	   .Where(x => x.Types.Any(t => t.Color == "Blue" && t.Size == "Small"))
	   .Intersect()
	   .Where(x => x.Types.Any(t => t.Color == "Gray" && t.Size == "Large"))
	   .ToList();

or its equivalent in Lucene syntax

session.Advanced.LuceneQuery<TShirt>("TShirtIndex")
	   .Where("Manufacturer:Raven INTERSECT Color:Blue AND Size:Small INTERSECT Color:Gray AND Size:Large")
	   .ToList();

Above query will return tshirts/1 and tshirts/4 as a result. Document tshirts/2 will not be included, because it is not manufactured by Raven and tshirts/3 is not available in Small Blue so it does not match all the sub-queries.