How to filter one source to three different set using RIA?

Question

I defined a domaindatasource in the xaml

            <dds:DomainDataSource x:Name="ddsPayroll" QueryName="GetEnPrcsQ" AutoLoad="True" LoadSize="20" PageSize="20">
            <dds:DomainDataSource.DomainContext>
                <RIASrv:PayrollSrv />
            </dds:DomainDataSource.DomainContext>

            <dds:DomainDataSource.SortDescriptors>
                <filter:SortDescriptor Direction="Descending" PropertyPath="wProcessId" />
            </dds:DomainDataSource.SortDescriptors>
        </dds:DomainDataSource>

in the record set returned, there is a column named "status" I have 3 different listbox controls, I need to status=1 into the listbox1, status=2 into the listbox2, status=3 into listbox3. anyway to do this in xaml?

Answer 1

You can use three CollectionViewSource objects. Each one of them should have its Source property bound to the DataView property of the DomainDataSource. For each CollectionViewSource you will create a Filter delegate that will filter out the appropriate items for each one of your listboxes.