I am fairly new to llblgen and am having trouble filtering. I have an employee to positions to budget year realtionship. An employee may have many positions and each position may have many budget years. What I want to do is pick up all employees, all positions for the employee, and all budgetversions still active

In tree view it would look like Employee Positions BudgetYearForPosition BudgetVersionForBudgetYear.ActiveFlag

I need all employees, all positions, any budget year for position where the budget version is still active. I added the following relations to the get multi relOtherTables.AddHrmasterEntity.Relations.EmployeePositionEntityUsingEmployeeMasterId) relOtherTables.AddEmployeePositionEntity.Relations.BudgetPrepEmployeeMasterEntityUsingEmployeePositionId)

Dim fltPos As IPredicateExpression = New PredicateExpression fltPos.AddWithAnd(BudgetVersionFields.Status <> BudgetVersionStatus.Inactive) relOtherTables.Add(BudgetPrepEmployeeMasterEntity.Relations.BudgetVersionEntityUsingBudgetVersionId).CustomFilter = fltPos

But I still get inactive budget versions. Any advice would be greatly appreciated. Thanks

Rather than adding your filter to the custom filter property, try setting it as the PredicateExpression of your relation predicate bucket.

Dim fltPos As IPredicateExpression = New PredicateExpression
fltPos.AddWithAnd(BudgetVersionFields.Status <> BudgetVersionStatus.Inactive)
relOtherTables.PredicateExpression = fltPos

CustomFilters are for specifing additional filters in ON clauses in the generated SQL x INNER JOIN y ON x.Id = y.Id AND x.Somefield = 27 --- custom filter.

Which is not really what you need - I've never actually come across the need for one in 5 years...

Matt

Will this work with self service or only the adapter method? We're using self-service.

Sorry my mistake, I assumed Adapter. In the case of SS, one of the parameters to GetMultiAsDataTable will accept a PredicateExpression as the filter to use - pass your filter to this instead.

Matt