[Koha-bugs] [Bug 10478] New: Do we need a sequential number generator?

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10478

            Bug ID: 10478
           Summary: Do we need a sequential number generator?
    Classification: Unclassified
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Tools
          Assignee: gmcharlt at gmail.com
          Reporter: m.de.rooy at rijksmuseum.nl

Copy and past from report 9921:

--- Comment #15 from Galen Charlton <gmcharlt at gmail.com> ---
(In reply to comment #14)
> 3) I feel that incrementalControlNumber is not (really) a pref. I can
> imagine more cases where we might need a sequential number. Would it be
> interesting to move it perhaps to Tools in a more general context such as a
> sequence number engine with its own table (id, keyname, seqnumber, date)? 
> There are more fields like callnumber (with plugins) that could use such an
> approach..
> This does again not block your patch, but we could trigger the discussion on
> a more general solution.

This idea (creating a sequence engine) is worth elevating to a new enhancement
bug.  There's been some chatter on #koha the past few days about this in the
context of improving how sequential patron cardnumbers are assigned.

[END-OF-QUOTE]

Note: Since this bug is not yet in assigned status, you are welcome to write
some code :)
It would probably be interesting too to add another column subkey or something
that allows you to have sequence number for the combination key, subkey.
You could e.g. have numbers then for 'shelf', '1 A' and 'shelf','2 C', etc.
But this idea could have many more applications.

-- 
You are receiving this mail because:
You are watching all bug changes.