Looking for insight/experience on the following:

We have many scenarios where a list of records (subfiles) are presented to
the
user. In the record that is a field that holds an INTEGER representing
"relative order" of that
record compared to the others. We are looking to create a flexible
approach that can allow reordering of the records. One specific example
is:

We have a web page that has a list of ORDERS to be processed. Each ORDER
has a PRIORITY field. Orders with the highest priority get worked on 1st.
A Priority of 99 1st then priority 88, etc. The Order Manager based on
several factors such product type, customer importance, labor schedules,
etc has the ability to change the relative ORDER that ORDERS should
be fulfilled. We are looking to enable this via JQUERY sortable. Manager
will drag the most important ORDER to the top of the list and drop it. As
a result of this, we need to change the DB2 value of the PRIORITY field to
be large than any other in the list.

What are the best practices In terms of setting up the priority field to
allow easy swapping of Priorities. Leave a gap of 10 or so between
priorities to allow reordering, etc? Big things seems to the the PRIORITY
value intervals and the methodology to swap numbers.

Thanks in advance,

Paul Holm


www.planetjavainc.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.