Blank stat_cat_entry in actor.stat_cat_entry_usr_map
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| Evergreen |
Medium
|
Unassigned |
Bug Description
EG2.2 & 2.2.5
Records with blank stat_cat_entry (not NULL) are created in the above-mentioned table when there is no input for stat_cats with allow_freetext set to FALSE and required set to FALSE.
Tina Ji
Sitka
Ben Shum (bshum) wrote : | #1 |
Changed in evergreen: | |
milestone: | none → 2.4.0-rc |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in evergreen: | |
milestone: | 2.4.0-rc → none |
Changed in evergreen: | |
assignee: | nobody → Ben Shum (bshum) |
no longer affects: | evergreen/2.2 |
Ben Shum (bshum) wrote : | #2 |
SQL used to find some of these bad entries:
SELECT astat.name, COUNT(*)
FROM actor.stat_cat astat
JOIN actor.stat_
WHERE astat.allow_
AND asceum.
GROUP BY 1
ORDER BY 1;
no longer affects: | evergreen/2.3 |
no longer affects: | evergreen/2.4 |
Jason Boyer (jboyer) wrote : | #3 |
Just dropping in to say this still affects 2.11. There's no way to "remove" an actor stat cat entry map like you can on assets. This causes confusion when running reports on actor stat cats and for any non-free-entry stat cat requires you to create a blank/none/
Changed in evergreen: | |
assignee: | Ben Shum (bshum) → nobody |
tags: | added: cataloging needstest |
Andrea Neiman (aneiman) wrote : | #4 |
"needstest" tag is used to indicate code that needs an automated test included
tags: |
added: statcats removed: needstest |
Elaine Hardy (ehardy) wrote : Re: [Bug 1130389] Re: Blank stat_cat_entry in actor.stat_cat_entry_usr_map | #5 |
I found that out after I used it for several of these ancient bugs. I
haven't had the time yet this morning to change them.
The tag needs to be clearer and one for testing by people would be good.
J. Elaine Hardy, PINES and Collaborative Projects Manager
-------
Georgia Public Library Service
1800 Century Place, Suite 580 | Atlanta, GA 30345
(404) 235-7128 | <email address hidden>
(404) 548-4241 | Cell
<https:/
<https:/
Join our email list <http://
of Georgia libraries making an impact in our communities.
On Fri, Mar 8, 2019 at 12:15 PM Andrea Neiman <
<email address hidden>> wrote:
> "needstest" tag is used to indicate code that needs an automated test
> included
>
> ** Tags removed: needstest
> ** Tags added: statcats
>
> --
> You received this bug notification because you are subscribed to
> Evergreen.
> Matching subscriptions: <email address hidden>
> https:/
>
> Title:
> Blank stat_cat_entry in actor.stat_
>
> Status in Evergreen:
> Confirmed
>
> Bug description:
> EG2.2 & 2.2.5
>
> Records with blank stat_cat_entry (not NULL) are created in the above-
> mentioned table when there is no input for stat_cats with
> allow_freetext set to FALSE and required set to FALSE.
>
> Tina Ji
> Sitka
>
> To manage notifications about this bug go to:
> https:/
>
Michele Morgan (mmorgan) wrote : | #6 |
Just realized this is happening on our 3.1 production system (xul client). A library staff member noticed erroneous stat cats with blank values listed in the patron summary.
This appears to be an issue in the xul client only. When creating or editing a patron record in an org unit that has Patron Statistical Categories set with allow_freetext FALSE and required FALSE, rows are created in actor.stat_
Testing in a 3.2 web client, no rows with blank stat_cat fields are created in actor.stat_
Also adding a reference to this in bug 1789263 and removing tag "cataloging" and adding "patron" since this is an issue with patron rather than item stat cats.
tags: |
added: fixedinwebby patron removed: cataloging |
Changed in evergreen: | |
status: | Confirmed → Won't Fix |
Well that's not good... confirmed for me as well.