Hi, I'm trying to filter an EntityView with a FieldLikePredicate. My problem is the type of the field to filter (int).

In SQL I would solve this problem: ... WHERE CAST(Id as nvarchar(10)) like '25%'

I want all Ids beginning with 25

How do solve this problem?

Greetings from Germany

Sascha

You will need to use a "database function call" as an expression set to the entityfield used in the predicate.

Please check Using a function call in a predicate

Thanks for your reply. I can't use a "database function call", because I'm working with an EntityView. There is no new database-fetch possible.

Sascha

For in memory filters you can provide a delegate that does what ever you want in deciding wether the particular entity passes or fails.

arschr wrote:

can you use division? for example: x/10 = 25 or x/100 = 25 etc.

or place a work field in the entity that converts the int to string?

Thanks for your answer. - I can't use division (divisor is unknown) - the work field seems to be a good idea :-)

Sascha

It is just a workaround. I hope there is a better solution for this problem.

Sascha wrote:

It is just a workaround. I hope there is a better solution for this problem.

Use a DelegatePredicate

Wow!!! This works great. Thanks a lot Otis.

Sascha