All In query

[Jason Dentler]

Hi,

I'm stuck on a query.

Each community has a list of amenities that it offers: Pool, Golf Course, etc. This is a simple array of strings.

On my search form, I list all of the amenities available and let the user check off the ones they must have. 

Among other criteria, I need to return the communities that offer all of the amenities. I haven't found a way to accomplish this.

This is part of a complicated, dynamic search form with facet search, so I can't stray too far without breaking a lot of other stuff.

Here's my code so far:

https://gist.github.com/4469669

Here's what my form looks like. (I hope this works.)

- J

[Jason Dentler]

Okay. Scratch that. I figured out a way to pull it off.

            if (searchCriteria.Amenities != null && searchCriteria.Amenities.Any())
            {
                foreach (var amenity in searchCriteria.Amenities)
                {
                    var amenity2 = amenity;
                    query = query.Where(r => r.Amenities.Any(s => s == amenity2));
                }
            }
 

[Oguzhan Topcu]

additionally you can use Session.Advanced.LuceneQuery for dynamic query build with or/and operators

foreach (var amenity in searchCriteria.Amenities)
                {
                    var 

amenity2 = amenity;
                    query = query.Where(r => r.Amenities.Any(s => s == amenity2)).Or();
                }

6 Ocak 2013 Pazar 23:08:05 UTC+2 tarihinde Jason Dentler yazdı: