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. |
||