How to filter on expanded tables

[enchev]

Hey @RIProG,

You cannot expect to search dates as strings like this using ToString() with Contains() which is translated by EF to LIKE in SQL. Again check the generated SQL for reference.

Search for 7/15/1996:

np(i.OrderDate).ToString().Contains("${search}")

is translated to:

Here is how it looks OrderDate as string:

Or even better what ToString() will produce:

and of course it depends on my Windows/SQL Server settings.

[RIProG]

I understand, thanks for claring that out. Seems to be bit of a challenge to make it work for users wanting to make a search for a specific date in their local timezone format then.