Hi Matt,

One more thing:

This query has 2 param: start time and stop time. Ideally, I'd let to get it to behave such that if the user does not supply a value for end date, it will default to now(). however, it appears functions are not supported in the parameter syntax:

PARAMETERS(STARTDATE TIMESTAMP, ENDDATE TIMESTAMP DEFAULT curdate())

that doesnt work. do i have any options here?

also, for what it's worth, if you have a param and do not set a default in your SQL statement, labkey fails in a pretty ugly way if the user tries to load the query without providing one.

-ben