I am trying to create a expression that generates the following
WHERE dbo.MatchFunction([LastNameField], @LastName1, 2) = 1
currently I am getting
WHERE dbo.MatchFunction([LastNameField], "UNKNOWN", 2) = @LastName1
Code to add the Expression
IPredicateExpression filter = new PredicateExpression();
ACSMatch2 exp = new ACSMatch2(IndividualFields.LastName, ACSMatchType.Normal);
EntityField2 field = IndividualFields.LastName.SetExpression(exp);
filter.Add(field == 1);
how do I get unknown to be the paramater and the parameter to be filter value?