[Bug 41876] New: Restrict the numbering patterns available for a subscription based on its frequency
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Bug ID: 41876 Summary: Restrict the numbering patterns available for a subscription based on its frequency Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Serials Assignee: koha-bugs@lists.koha-community.org Reporter: mathsabypro@gmail.com QA Contact: testopia@bugs.koha-community.org It would be useful to restrict the numbering patterns available for a subscription based on its frequency, in order to facilitate subscription management (saving time and limiting errors). E.g, if monthly frequency, display only monthly numbering patterns -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I am sorry, but I don't think this can work as suggested. Numbering patterns have no indicator to tell you if they are monthly or not. And we can't look for "12" as we don't know: - which variable it might appear in - frequency might be monthly, but only 10 issues (counter is 10) and some irregularities recorded - frequency might be monthly, but there are 2 6 issue cycles a year and the numbering goes 1-6, 1-6 for each The current system is very flexible, but it makes it really hard to limit the pull down like you suggest. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #2 from Mathieu Saby <mathsabypro@gmail.com> --- Thanks for your feedback! The KohaLa association is considering funding a development, but we have not yet requested a cost estimate. Here are the specifications we have been working on. Does this seem realistic to you? - add an optional "frequency" field to the numbering pattern: each pattern can now be linked to a frequency (to be selected from a drop-down list). If the field remains empty, no usage restrictions will be applied to the pattern (maintaining current behavior). - When modifying or creating a subscription, only display numbering pattern that correspond to the subscription's periodicity and pattern for which no usage restrictions have been set. - When a subscription is modified the consistency of the data between the frequency and numbering pattern fields must be checked before validation, and an alert must be displayed in the event of inconsistency. E.g.: if a monthly subscription (with a numbering model that can only be used for monthly subscriptions) becomes quarterly, the librarian will have to modify the numbering model. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I understand where this comes from - the list of numbering patterns can easily get quite long and hard to manage if you don't stick to strict internally agreed naming conventions. I think what you suggest would make it an optional feature, so it would not mean a regression for libraries and might prove useful. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #4 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 198957 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=198957&action=edit Bug 41876: Add a frequency_id column to numbering patterns Patch from commit 128337c -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #5 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 198958 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=198958&action=edit Bug 41876: DBIC files Patch from commit cbbec6c -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #6 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 198959 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=198959&action=edit Bug 41876: Update the templates and forms to use the new frequency_id column Test plan: 1) Apply patch and reset_all 2) Navigate to the serials module and click into numbering patterns on the left menu 3) There should be a column in the table called Frequency restriction - all lines should show No restriction 4) Click to add a new pattern 5) There should be a dropdown called Frequency restriction 6) Select any value in that field and create your numbering pattern 7) In the table, your restriction should correctly show in the Frequency restriction column 8) Click back to the serials homepage in the breadcrumbs 9) Click to add a new subscription and navigate through until the Serials planning form 10) In the frequency field, click on the frequency that you set in your numbering pattern 11) In the Numbering pattern dropdown, the pattern you created should be an option 12) In Frequency, click any other frequency that your created pattern was not restricted to 13) Your created pattern should now not be visible 14) Select the frequency and your pattern in their respective fields 15) Now change the frequency to a different value 16) An alert should display to say that your chosen numbering pattern is not compatible and has been cleared 17) The Numbering pattern should be empty once you clear the alert 18) All existing numbering patterns with no restrictions should still be visible in the dropdown regardless of which frequency is selected -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #198959|0 |1 is obsolete| | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #7 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Created attachment 198960 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=198960&action=edit Bug 41876: Update the templates and forms to use the new frequency_id column Test plan: 1) Apply patch and reset_all 2) Navigate to the serials module and click into numbering patterns on the left menu 3) There should be a column in the table called Frequency restriction - all lines should show No restriction 4) Click to add a new pattern 5) There should be a dropdown called Frequency restriction 6) Select any value in that field and create your numbering pattern 7) In the table, your restriction should correctly show in the Frequency restriction column 8) Click back to the serials homepage in the breadcrumbs 9) Click to add a new subscription and navigate through until the Serials planning form 10) In the frequency field, click on the frequency that you set in your numbering pattern 11) In the Numbering pattern dropdown, the pattern you created should be an option 12) In Frequency, click any other frequency that your created pattern was not restricted to 13) Your created pattern should now not be visible 14) Select the frequency and your pattern in their respective fields 15) Now change the frequency to a different value 16) An alert should display to say that your chosen numbering pattern is not compatible and has been cleared 17) The Numbering pattern should be empty once you clear the alert 18) All existing numbering patterns with no restrictions should still be visible in the dropdown regardless of which frequency is selected Sponsored-by: Association KohaLa - https://koha-fr.org/ -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |matt.blenkinsop@openfifth.c | |o.uk Assignee|koha-bugs@lists.koha-commun |matt.blenkinsop@openfifth.c |ity.org |o.uk -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Nathalie SAVARIT <nathalie.savarit@univ-amu.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nathalie.savarit@univ-amu.f | |r --- Comment #8 from Nathalie SAVARIT <nathalie.savarit@univ-amu.fr> --- Hi Matt, I'm trying to set a value (point 7). But when I valid my patternumber, the value disappears. My restriction doesn't show in the Frequency restriction column. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #9 from Matt Blenkinsop <matt.blenkinsop@openfifth.co.uk> --- Hi Natalie, that sounds like the database hasn't rebuilt - when testing you need to use the option on your sandbox to refresh the database so that the new frequency_id column exsits -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 OpenFifth Sandboxes <sandboxes@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #198960|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 --- Comment #10 from OpenFifth Sandboxes <sandboxes@openfifth.co.uk> --- Created attachment 199894 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=199894&action=edit Bug 41876: Update the templates and forms to use the new frequency_id column Test plan: 1) Apply patch and reset_all 2) Navigate to the serials module and click into numbering patterns on the left menu 3) There should be a column in the table called Frequency restriction - all lines should show No restriction 4) Click to add a new pattern 5) There should be a dropdown called Frequency restriction 6) Select any value in that field and create your numbering pattern 7) In the table, your restriction should correctly show in the Frequency restriction column 8) Click back to the serials homepage in the breadcrumbs 9) Click to add a new subscription and navigate through until the Serials planning form 10) In the frequency field, click on the frequency that you set in your numbering pattern 11) In the Numbering pattern dropdown, the pattern you created should be an option 12) In Frequency, click any other frequency that your created pattern was not restricted to 13) Your created pattern should now not be visible 14) Select the frequency and your pattern in their respective fields 15) Now change the frequency to a different value 16) An alert should display to say that your chosen numbering pattern is not compatible and has been cleared 17) The Numbering pattern should be empty once you clear the alert 18) All existing numbering patterns with no restrictions should still be visible in the dropdown regardless of which frequency is selected Sponsored-by: Association KohaLa - https://koha-fr.org/ Signed-off-by: Nathalie <nathalie.savarit@univ-amu.fr> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Nathalie SAVARIT <nathalie.savarit@univ-amu.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Signed Off --- Comment #11 from Nathalie SAVARIT <nathalie.savarit@univ-amu.fr> --- Hi Matt. I tried it again. This time everything is fine. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41876 Mathieu Saby <mathsabypro@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Comma delimited| |Kohala association list of Sponsors| | Sponsorship status|--- |Sponsored -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org