[Bug 21200] New: Allow default values for saved SQL report "date" parameters

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 21200] New: Allow default values for saved SQL report "date" parameters

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200

            Bug ID: 21200
           Summary: Allow default values for saved SQL report "date"
                    parameters
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: [hidden email]
          Reporter: [hidden email]
        QA Contact: [hidden email]

It would be nice to let the saved SQL report define default date values,
relative to the time the report is being run, for any "date" fields. Often such
date fields require entering a date eg. 6 months past or similar, and having
the default value in would make it much less likely for the user to choose the
wrong date.

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://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/
Reply | Threaded
Open this post in threaded view
|

[Bug 21200] Allow default values for saved SQL report "date" parameters

bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200

paxed <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Assignee|[hidden email]-commun |[hidden email]
                   |ity.org                     |

--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://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/
Reply | Threaded
Open this post in threaded view
|

[Bug 21200] Allow default values for saved SQL report "date" parameters

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200

--- Comment #1 from paxed <[hidden email]> ---
Created attachment 77643
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=77643&action=edit
Bug 21200: Allow default values for saved SQL report "date" parameters

Let the saved SQL report define default date values, relative to
the time the report is being run, for any "date" fields.

Often such date fields require entering a date eg. 6 months past
or similar, and having the default value in would make it much less
likely for the user to choose the wrong date.

The default value is put after the "date" text, separated by a pipe.

Format for the default date value is either "now", or "<value> <unit>",
where value is a positive or negative integer value, and unit is
one of "hour", "day", "week", "month", "year".

Not putting in the default value would behave the same as before,
leaving the date input field empty.

For example:

    SELECT count(*) FROM items
    WHERE DATE(dateaccessioned)
        BETWEEN <<Start|date|-6 month>>
            AND <<End|date|now>>

Would default to the last 6 months.

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://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/
Reply | Threaded
Open this post in threaded view
|

[Bug 21200] Allow default values for saved SQL report "date" parameters

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200

paxed <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |Needs Signoff

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://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/
Reply | Threaded
Open this post in threaded view
|

[Bug 21200] Allow default values for saved SQL report "date" parameters

bugzilla-daemon
In reply to this post by bugzilla-daemon
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21200

paxed <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Failed QA

--- Comment #2 from paxed <[hidden email]> ---
Failing this due to tests, and because bug 21215 will make coding this easier.

--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[hidden email]
http://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/