Cannot edit reports that have a filter with data type = timestamp & operator = In List

[Christine Burns]

Evergreen 3.5, 3.6

Cannot edit reports that have a filter with data type = timestamp & operator = In List

If you try to edit the report - some filters are missing, date field is red and you cannot save your changes.

Editing other recurring reports works as expected. Templates with other fields with inlist seems fine, such as library, shelving loc, etc. Other operators with a timestamp seems fine, too.

This issue only happens if the template contains a filter with operater = in list & data type = timestamp . Perhaps EG can not handle the combination?

See attachment

[Jennifer Pringle (jpringle-u)]

Continues to be an issue in 3.9

[[e-mail] (tji)]

EG 3.9

Our commonly used Date filters for recurring reports are date transformed to Year + Month with InList operator and transformed to Date with Between operator.

With numerous test editing recurring reports using these date filters, we found that the later worked well, but not the former.

When editing recurring reports with date filter transformed to Year + Month with InList operator, usually we saw the date filter only on the Edit screen, which was default to Real Date instead of Relative Date. The other filters were missing.

When we continued to save the report using either Save as New or Save Report, we noticed that the new/edited report was not using the original template, but the one last used by the staff account. (In reality it does not make much sense to save a report that has a problem already. I hope this observation may help trace the cause of the issue.)

[Galen Charlton (gmc)]

Confirming bug. oilsRptSetWidget does not currently handle the case where its multi-select is being fed from oilsRptTruncPicker (the relative dates widget). Conversely, oilsRptTruncPicker expects to be given either no seed value or a single seed value, not an array.

[Galen Charlton (gmc)]

I haven't fully tested this, so no pull request yet, but the branch user/gmcharlt/lp1916969_rpt_datepicker_in_list has a fix that's worth some external testing.