• Sign In
  1. Messages

create view to show 'records in past 6 months'?

LabKey Support Forum (Inactive)

View Message

view list print
create view to show 'records in past 6 months'? Ben Bimber  2010-04-15 16:15
Status: Closed
 
is there any mechanism to create a grid filter that accomplishes something like 'date within the past 6 months'? we have a table of birth records and it would be useful of have a view called 'recent births'.

i could write a separate query to do this, but the way a QWP works it would make a lot more sense to users for it to be a view. the toggle query button is rarely practical since it cannot be set to show a subset of queries in that folder.
 
 
jeckels responded:  2010-04-15 17:08
Hi Ben,

We don't have a way to do this with just a saved view right now, but if you're using a QueryWebPart through the JavaScript API, you could use a saved view for all of the configuration aside from the date filter, and then use JavaScript to calculate the desired date cutoff and pass that as a separate filter.

Thanks,
Josh