2sxc: Filtering by a date in Visual Query does not work

0
votes

Working with events, I need to get the next 5 events that are not expired, to do a sort of news tiker. So I tried to apply the following filter in visual query https://snag.gy/e1nWpD.jpg

It is getting even the expired events. Tryed also without the .ToString("yyyy-MM-dd") with no luck. It is possible to do this in visual query or the only solution is doing this with LINQ? I would not like doing this with LINQ cause I would have to get all event elements in query and then filter them taking just 5 and it would be a leak about performance...

EDIT: having a look at this http://2sxc.org/en/Docs/Feature/feature/9259 I tryed the following filter

Data > [DateTime:Now]

but my element with the date "Data": "2016-10-03T00:00:00Z" is always getting out from the query. Maybe a date culture issue?

1
2sxc

1 Answers

1
votes

it's possible that it's a culture issue, but it's not likely.

Please run a few more tests using real text-values (so not a token) to compare the result with a real value and then with the token. This would help you rule out the culture issue.

Very often it's also a simple mistake like that you may be comparing "data" when your field is "date" or something.