> The app basically launches and shows the data in a DataGrid.

> User's want to be able to filter by grid columns, i.e when they click
> a grid column header, I want to display in a drop down list all the
> distinct values for that column.

> The data is stored in strong typed objects.
> currently I create a map-reduce index to select dictinc for each
> column

> public class QzBookIndex : AbstractIndexCreationTask<VmDto>
>    {
>        public QzBookIndex()
>        {
>            Map = qzList => from qzObj in qzList
>                            select new { qzObj.Book };

>            Reduce = results => from result in results
>                                group result by result.Book into g
>                                select new { Book = g.Key };
>        }

>    }

> then in the filter method I query using the index:
>  var items = (from item in docSession.Query<VMDto, QzBookIndex>()
>                             select item.CobDate);

> All works Fine.  But I need to make the index and the select statement
> dynamic.

> i.e. when the user clicks the header for a particular column in the
> grid for the first time, I want to create an index for that property
> and then dynamically select all the distinct values for that property
> and display them in the dropdown list...

> I might be aproaching this the wrong way. but the gist of what I want
> is in the paragraph above