web client reporter: can't hard code a list of filter values

Bug #1785061 reported by Chris Sharp on 2018-08-02
26
This bug affects 5 people
Affects Status Importance Assigned to Milestone
Evergreen
High
Unassigned

Bug Description

When creating a reports template, it is often useful to enter ("hard code") values into a filter. Current example is a report on the Atlanta Zoo DVD/Pass that is available for Georgia libraries. As there are two editions of the DVD that are valid, we would prefer to enter both bib IDs into a filter so those running the reports don't have to look them up.

In the web client reporter UI, if you create a filter and change the operator to "In list", then click "Change Filter Value", you're presented with a "Value:" modal where you can enter your values. However, if you enter a comma-separated list (e.g., "5487517,5628015"), the resulting SQL uses that literal value ("5487517,5628015") rather than the desired list of each value separately.

Evergreen 3.0-ish through master
OpenSRF 3.0.1
Ubuntu 16.04 LTS
All browsers

Anna Goben (agoben) wrote :

Ooo, yes. This is another thing about the wc reporter that is really, really frustrating!!! I've tried every workaround I could come up with for added punctuation to force the entries to be distinct, but no luck.

Remington Steed (rjs7) on 2018-08-02
Changed in evergreen:
status: New → Confirmed
Beth Willis (willis-a) wrote :

confirmed

EG 3.0.9
Browser: Chrome
OpenSRF 3.0.1

Terran McCanna (tmccanna) wrote :

Bumping this up to "High" - we're still having to go into the XUL client to create these reports.

EG 3.0

Changed in evergreen:
importance: Undecided → High
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers