Hi,

I am having a few trouble with filtering. I have 2 tables:

Department that contains EmployeeID and Employee that contains EmloyeeID and Name. Both collections are data binded to numerous of views. Now I want to filter EmployeeCollection through Department.

I know that I can do it by using filter and SetOperation.In. Trouble is, I have to call EmployeeCollection.GetMulti(filter) and bind the new collection back to the views, which is not ideal. Is there a way to keep the old collection and just hide the filtered out values away from the views.

By the way, I am using LLBLGen ver 2.0 trial.

Use memroy filtering through EntityViews and databind to the newly filtered EntityViews.

Please refer to LLBLGen Pro manual: "Using the generated code -> SelfServicing -> Using the EntityView class"

Hi, Walaa.

The in-memory EntityView unfortunately does not support the filter FieldCompareSetPredicate which we must use in our situation.

At the moment , the filter looks like this

filter.Add( new FieldCompareSetPredicate( EmployeeFields.DepartmentId, DepartmentFields.DepartmentId, SetOperator.In, (DepartmentFields.Path == path) ) );

If there is any other way to work around this, please enlight me.

At the moment the view filtering is just 1 level deep (i.e. the view), not multiple levels deep, so the set filter isn't usable in memory. We'll investigate to add this in the future.