thanks. this will support days. what if we would like to search last 2 hours or 180 minutes. eg. requests created in last 4 hours.
Hi , I think we could add another operator HOURS or MINUTES or even SECONDS, in the same way.
Or maybe easier we could allow fractions on the DaysFrom and DaysTo and process fractions accordingly.
Fraction for days will be hard to use for average user. I think better to add a new “Times” or “Hours” operator and allows fraction for minutes (fraction should be more mangeable here). The need to search by seconds should be very very rare.
But anyways, I would like to move ahead the "Days" if possible - which from what I have heard is the most common request.
The "Hours" can be developed later in another ticket, for the "days" I'm using the adddays database function, to implement "Hours" maybe we need to implement a new db function addhours, or to do some ConvertPostgres trick.
Just noticed that AddDays function in oracle can manage decimals properly, but our PostgreSQL version is wrongly truncating the timestamp. I think we can improve that, anyways allowing using decimals (which maybe is useful just for advanced users) makes sense.