I have a content type with a date field, and I would like to filter this to dates in the future in a data rule. Is this possible with the current code? Everything I tried just caused exceptions.

Thanks

Just a parse exception:

Conversion failed when converting date and/or time from character string.
from Kooboo.CMS.Content.Persistence.SqlServer.QueryProcessor.<List>d__0.MoveNext() +139

To clarify, I was playing around to see if there was a magic string I could put in the filter to get this behavior: 'Now', 'DateTime.Now', etc. There's nothing wrong with the way Kooboo's behaving.

I've written a workaround where I get the top 50 unfiltered results and then .Where(c => c.StartDate > DateTime.Now).Take(5) to get the results I'm after, but I was wondering if there's a 'proper' way to do this?

Thanks for the quick reply.

For anyone else with a similar problem, I had to cast the ViewBag.[DataRule] item to IEnumerable<Kooboo.CMS.Content.Models.ContentBase> as you can't(?) use LINQ directly on a dynamic object.
After that I didn't seem to be able to use the dynamic properties to get to the data, so instead of item.StartDate I had to use item["StartDate"].

Cheers

Linq uses extension methods, which aren't real methods, so the dynamic runtime cannot really discover those.

However, you can use "dynamic" for the iterated item instead of "var" to get back the dynamic functionality. Try this:

ContentHelper.TextFolder("FolderName").CreateQuery().WhereLessThan("dtStartDate", DateTime.Now).WhereGreaterThan("dtStartDate", DateTime.Now)