Query (date in the past,future)

[mimusz]

Hello all,

I'a a newbie in Seam. I've generated project with seam-gen (entities from DB). The scaffold is working (searching, adding new records etc.).
Now I want do make a new pages: listing all records from DB, but filtered by date - i.e. the entity has a startDate property. I want to make 2 pages, the first one with records filtered by the date in the past, and the second with that date set in the future.

Should I add that condiotion to the RESTRICTIONS string? I've tried 'gt' but it doesn't work, additionally all examples covers only 'like' condition...

Could you give me any hints?

Regards,
Michal

[konami.bankyaw.gmail.com]

Please post your controller and view codes.

[gebuh]

If I understand what you're looking for, if you put dates into restrictions it would look something like:

restrictionString = 
{
     "lower(startDate) >= #{someDateInTheFuture}",
     "lower(startDate) <= #{someDateInThePast}",
};

this would give you all dates after someDateInTheFuture and before someDateInThePast.
Thoe lower stuff is prolly unnecessary.