Hi There

I can't figure out what the issue is here. I am using Adapter. I am obviously overlooking something fundamental. The issue is with the field ActransactionFields.TransactionDate ( Which is an Entityfield2 I guess ) .

Your help is much appreciated. Marty

Argument '1': cannot convert from 'SD.LLBLGen.Pro.ORMSupportClasses.EntityField2' to 'SD.LLBLGen.Pro.ORMSupportClasses.IEntityField'

EntityCollection<ActransactionEntity> transactions = new EntityCollection<ActransactionEntity>();

filter.PredicateExpression.Add(new FieldBetweenPredicate(ActransactionFields.TransactionDate ,import.DateFrom,import.DateTo)); adapter.FetchEntityCollection(transactions, filter);

Try using two compare predicates.

filter.PredicateExpression.Add(ActransactionFields.TransactionDate > import.DateFrom);
filter.PredicateExpression.AddWithAnd(ActransactionFields.TransactionDate < import.DateTo);
adapter.FetchEntityCollection(transactions, filter);

bclubb wrote:

Try using two compare predicates.

filter.PredicateExpression.Add(ActransactionFields.TransactionDate > import.DateFrom);
filter.PredicateExpression.AddWithAnd(ActransactionFields.TransactionDate < import.DateTo);
adapter.FetchEntityCollection(transactions, filter);

Nice one thanks. Seems odd that the between predicate doesn't work though- I implemented as per documentation.

Marty

FieldCompareBetweenPredicate works fine too.

The problem was that you used an overload specific to SelfServicing. The following should work:

filter.PredicateExpression.Add(new FieldBetweenPredicate(ActransactionFields.TransactionDate, null, import.DateFrom, import.DateTo));
adapter.FetchEntityCollection(transactions, filter);

Just take care of the extra null parameter.

Walaa wrote:

FieldCompareBetweenPredicate works fine too.

The problem was that you used an overload specific to SelfServicing. The following should work:

filter.PredicateExpression.Add(new FieldBetweenPredicate(ActransactionFields.TransactionDate, null, import.DateFrom, import.DateTo));
adapter.FetchEntityCollection(transactions, filter);

Just take care of the extra null parameter.

Nice one
Thx

much better