Hi,

In the "Creating Dynamic Lists" section of the Help Docs, there's an example that returns a result set of Managers and how many Employess they manage. Supose, I wanted to add a filter on Employees so that, for example, I want the result to only count employess who's last names are "Smith".

How would I do that?

I have a similar query but just can't figure out the right way to add the filter. I'm using self servicing by the way.

Thanks.

I assume you want the following query:

SELECT M.FirstName, M.LastName, Count(E.LastName) 
FROM Employee M
INNER JOIN Employee E 
ON M.EmployeeId = E.ManagerId
AND E.LastName = 'Smith'

And for this you should set the CustomFilter of the EntityRelation used:

IEntityRelation relation = EmployeeEntity.Relations.EmployeeEntityUsingEmployeeId;
relation.CustomFilter = new PredicateExpression(new FieldCompareValuePredicate(EmployeeFields.LastName, ComparisonOperator.Equal, "Smith", "Employee"));
IRelationCollection relations = new RelationCollection();
relations.Add(relation, "Employee", "Manager", JoinHint.None);

If the query I assumed is not what you want, please supply your query.