[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Kyle M Hall changed: What|Removed |Added CC||k...@bywatersolutions.com Status|Pushed to master|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 --- Comment #8 from Jonathan Druart --- Pushed to master for 21.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Jonathan Druart changed: What|Removed |Added Version(s)||21.11.00 released in|| Status|Passed QA |Pushed to master -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Bug 29351 depends on bug 17600, which changed state. Bug 17600 Summary: Standardize the EXPORT https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Owen Leonard changed: What|Removed |Added Keywords|release-notes-needed| Text to go in the||This patch adds a link for release notes||the previously-hidden ||option of using a runtime ||parameter for selecting ||"Source of classification ||or shelving scheme." Now ||when composing an SQL ||report you can click the ||"Insert runtime parameter" ||button to see a menu that ||includes this option. -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Katrin Fischer changed: What|Removed |Added Attachment #127069|0 |1 is obsolete|| --- Comment #7 from Katrin Fischer --- Created attachment 127116 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127116=edit Bug 29351: Add missing cn_source parameter to reports parameter menu This patch adds an option to insert "Source of classification or shelving scheme" as a runtime parameter in SQL reports. The ability to use cn_source as a parameter seems to have always been part of this feature but wasn't documented. To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" button and select "Classification source." - Customize the parameter label if you wish and click "Insert parameter." - The parameter should be inserted like this: <> - Use it to create a valid SQL report, for example: SELECT * FROM items WHERE cn_source = <> LIMIT 10 - Confirm that upon running the report you are prompted to select a classification source. - Confirm that the report runs correctly. Signed-off-by: Andrew Fuerste-Henry Signed-off-by: Katrin Fischer -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Katrin Fischer changed: What|Removed |Added Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Bug 29351 depends on bug 17600, which changed state. Bug 17600 Summary: Standardize the EXPORT https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 What|Removed |Added Status|CLOSED |REOPENED Resolution|FIXED |--- -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Katrin Fischer changed: What|Removed |Added Depends on||17600 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 [Bug 17600] Standardize the EXPORT -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Katrin Fischer changed: What|Removed |Added Keywords||Manual, ||release-notes-needed -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 --- Comment #6 from Andrew Fuerste-Henry --- Thanks! I Was able to test successfully after I applied your patch from 17600. -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Andrew Fuerste-Henry changed: What|Removed |Added Attachment #127063|0 |1 is obsolete|| --- Comment #5 from Andrew Fuerste-Henry --- Created attachment 127069 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127069=edit Bug 29351: Add missing cn_source parameter to reports parameter menu Signed-off-by: Andrew Fuerste-Henry -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Andrew Fuerste-Henry changed: What|Removed |Added Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Owen Leonard changed: What|Removed |Added Status|Failed QA |Needs Signoff --- Comment #4 from Owen Leonard --- Sorry, I should have put this in the test plan: There is a followup on Bug 17600 which is required for GetClassSources to work: See comment 148 on that bug. -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Andrew Fuerste-Henry changed: What|Removed |Added Status|Needs Signoff |Failed QA --- Comment #3 from Andrew Fuerste-Henry --- I'm getting this error when trying to run my report: Undefined subroutine ::Compile::ROOT::kohadevbox_koha_reports_guided_reports_2epl::GetClassSources called at /kohadevbox/koha/reports/guided_reports.pl line 761 -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Heather changed: What|Removed |Added CC||heather_hernan...@nps.gov -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 --- Comment #2 from Owen Leonard --- Created attachment 127063 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127063=edit Bug 29351: Add missing cn_source parameter to reports parameter menu This patch adds an option to insert "Source of classification or shelving scheme" as a runtime parameter in SQL reports. The ability to use cn_source as a parameter seems to have always been part of this feature but wasn't documented. To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" button and select "Classification source." - Customize the parameter label if you wish and click "Insert parameter." - The parameter should be inserted like this: <> - Use it to create a valid SQL report, for example: SELECT * FROM items WHERE cn_source = <> LIMIT 10 - Confirm that upon running the report you are prompted to select a classification source. - Confirm that the report runs correctly. -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Owen Leonard changed: What|Removed |Added Patch complexity|--- |Trivial patch Status|ASSIGNED|Needs Signoff -- You are receiving this mail because: You are on the CC list for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 --- Comment #1 from Andrew Fuerste-Henry --- I didn't know this was an option! Good catch! -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 29351] Add missing cn_source parameter to reports parameter menu
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29351 Owen Leonard changed: What|Removed |Added Depends on||29352 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29352 [Bug 29352] Runtime parameter labels should not be said to be optional -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/