filtering date ranges in a labkey grid

LabKey Support Forum (Inactive)
filtering date ranges in a labkey grid Ben Bimber  2010-06-15 16:19
Status: Closed
 
yep, you got both.

i have thought that this sort of supplemental filter panel above a grid would be useful. perhaps future extensions of the QWP could consider something like that.

likewise for NULL dates: i dont know whether this is a good idea overall of not (depends on what other clients want); however, it would be quite useful to the EHR if labkey grids did some behind the scenes translation on any filter of a date field like you describe: if you filter on >=, then it actually searches on >= OR NULL. basically you decide whether NULL dates sort high or low.

i would have though date ranges came up more commonly in a host of database applications, but they can be quite a pain to query properly.