Add calculated field recorded_end_date to AudioRecording's filter options

[atruskie]

Request: and calculated field recorded_end_date to the filter options in the AudioRecording model.

This field would be defined as:

recorded_end_date = recorded_date + duration_seconds

This field will be useful in completing the saved search story. E.g. find all recordings that have content past a certain date.

[atruskie]

👍 - more complicated than I expected but very cool. Cheers.

[cofiem]

😃 yeah, I had to use arel to construct the query.

It's like there's a gremlin in the system that sees your issues, and fixes them.....

[cofiem]

Be aware that that dates you send must be in utc, and prefer using Z over +0000. I had trouble getting some offsets and time zone names to parse correctly, since the filter system doesn't use ActiveRecord's datetime conversion.

[atruskie]

hmm... that could represent a serious problem. Does this affect all date fields used in all filters? Or just this custom one?

[cofiem]

I think this would affect all date fields in filters (other parts of API should be fine).

[atruskie]

One last question: does it throw an error with bad timezones it fails to parse or does it silently continue?

[cofiem]

I hate to say it, but I think it silently continues with whatever it thought the datetime is 😞

[cofiem]

This... probably... definitely needs a bit more work...

[atruskie]

It is a separate issue, tracked in #263