Hi, I need to make a query in order to return a collection of cards that have been Verified but have not been issued yet, and that they match a specific CardID.
I'm trying with the following query:
PredicateExpression filter = new PredicateExpression(CardFields.CardID == cardNumber);
filter.AddWithAnd(CardFields.DateVerified != DBNull.Value);
filter.AddWithAnd(CardFields.DateIssued == DBNull.Value);
But this is not working. Am I doing something wrong?