Re: Delete Records from Responsible and Leave Historical Records Unchanged
Jo A Wahle <[email protected]> Wed, 14 Feb 2007 12:43:59 -0600
| Newsgroups | gmane.comp.bug-tracking.gnats.general |
|---|---|
| Message-ID | <OF3F3BD48A.9A8E58EE-ON86257282.006526A2-86257282.0066E80E@usgs.gov> |
This is a multipart message in MIME format. --===============0585657968== Content-Type: multipart/alternative; boundary="=_alternative 0066E75C86257282_=" This is a multipart message in MIME format. --=_alternative 0066E75C86257282_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable We have the same problem. I didn't delete them, but I put them at the=20 bottom of the list and their full name field becomes Invalid - was So-and-So and the e-mail address is gnats-admin, just in case any e-mails get sent=20 because the PR got updated. I've thought about setting up gnatsweb so that = the Edit form would clean all of the "Invalid - *" entries from the list,=20 but with all of them being at the bottom, it's not too bad. We've been=20 using gnats for over 10 years, so the "Invalid - *" list at the bottom is=20 getting pretty long now, though! We have a similar problem with obsolete categories - someone might want to = query them, but they shouldn't be selectable in the Create page or the=20 Edit page. The same problem would exist with any of the enum lists - it's=20 impossible to drop an entry from the enum list and maintain the integrity=20 of historical PRs that have that value. I've thought about updating my=20 dbconfig and my enum files to add a field like 'deleted' that contains=20 perhaps a date or a comment as to why that enum item was deleted, then=20 gnatsweb could exclude any entries where the 'deleted' field is non-null=20 from the edit page and create page. (And maybe on the query page, put all=20 of the 'deleted' items at the bottom of the list; maybe exclude 'deleted'=20 items from an "any" query by default, too.) Doing that in your dbconfig is = up to you; currently, however, there is nothing in gnatsweb (I assume=20 you're referring to gnatsweb forms) that would look for such a field,=20 currently. -- Jo Wahle, Software Engineer, Engineering Support, SAIC (Science Applications International Corporation ? www.saic.com) Contractor to U.S. Geological Survey ? EROS, Sioux Falls SD 57198 (Earth Resources Observation and Science ? eros.usgs.gov) Voice: 605-594-2514, FAX: 605-594-6940, E-mail: [email protected] "Imagination is more important than knowledge, for knowledge is limited=20 while imagination embraces the entire world." -- Albert Einstein "Craig Senior" <[email protected]>=20 Sent by: [email protected] 02/14/2007 12:21 PM To <[email protected]> cc Subject Delete Records from Responsible and Leave Historical Records Unchanged If we delete records from the responsible file when people leave our=20 project, it sets the value of the responsible field in current PR records=20 to "Unknown". Our desire is to remove their name from the dropdown list in = the Responsible field, selected in the Edit PR form while retaining their=20 name in Closed PR records and ideally in the Query forms (realising this=20 last bit might be impossible). =20 Our workaround is to modify the responsible field to the new person in all = PR records (even historical) before modifying the responsible file. The=20 only problem with that workaround is it changes the name even for closed=20 records and our history is incorrect ("Who controls the past controls the=20 future." Orwell: "1984"), possibly contravening some Sarbanes-Oxley=20 requirement (I'm not sure). =20 Help! Craig Senior, CMIIC=20 AIMS Configuration Manager=20 Public Works and Government Services Canada=20 Place du Portage, Ph III, 2A1, Stn 26L=20 W (819) 956-3295=20 F (819) 956-6476=20 [email protected]=20 =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F Help-gnats mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-gnats --=_alternative 0066E75C86257282_= Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable <br><font size=3D2 face=3D"sans-serif">We have the same problem. I didn't d= elete them, but I put them at the bottom of the list and their full name field becomes</font> <br><font size=3D2 face=3D"sans-serif">Invalid - was So-and-So</font> <br><font size=3D2 face=3D"sans-serif">and the e-mail address is gnats-admi= n, just in case any e-mails get sent because the PR got updated. I've thought about setting up gnatsweb so that the Edit form would clean all of the "Invalid - *" entries from the list, but with all of them being at the bottom, it's not too bad. We've been using gnats for over 10 years, so the "Invalid - *" list at the bottom is getting pretty long now, though!</font> <br> <br><font size=3D2 face=3D"sans-serif">We have a similar problem with obsol= ete categories - someone might want to query them, but they shouldn't be select= able in the Create page or the Edit page. The same problem would exist with any of the enum lists - it's impossible to drop an entry from the enum list and maintain the integrity of historical PRs that have that value. I've thought about updating my dbconfig and my enum files to add a field like 'deleted' that contains perhaps a date or a comment as to why that enum item was deleted, then gnatsweb could exclude any entries where the 'deleted' field is non-null from the edit page and create page. (And maybe on the query page, put all of the 'deleted' items at the bottom of the list; maybe exclude 'deleted' items from an "any" query by defaul= t, too.) Doing that in your dbconfig is up to you; currently, however, there is nothing in gnatsweb (I assume you're referring to gnatsweb forms) that would look for such a field, currently.</font> <br><font size=3D2 face=3D"sans-serif"><br> --<br> Jo Wahle, Software Engineer, Engineering Support, SAIC<br> (Science Applications International Corporation – www.saic.com)<br> Contractor to U.S. Geological Survey – EROS, Sioux Falls SD 57198<br> (Earth Resources Observation and Science – eros.usgs.gov)<br> Voice: 605-594-2514, FAX: 605-594-6940, E-mail: [email protected]<br> "Imagination is more important than knowledge, for knowledge is limited while imagination embraces the entire world." -- Albert Einstein<br> </font> <br> <br> <br> <table width=3D100%> <tr valign=3Dtop> <td width=3D40%><font size=3D1 face=3D"sans-serif"><b>"Craig Senior&qu= ot; <[email protected]></b> </font> <br><font size=3D1 face=3D"sans-serif">Sent by: help-gnats-bounces+wahle=3D= [email protected]</font> <p><font size=3D1 face=3D"sans-serif">02/14/2007 12:21 PM</font> <td width=3D59%> <table width=3D100%> <tr valign=3Dtop> <td> <div align=3Dright><font size=3D1 face=3D"sans-serif">To</font></div> <td><font size=3D1 face=3D"sans-serif"><[email protected]></font> <tr valign=3Dtop> <td> <div align=3Dright><font size=3D1 face=3D"sans-serif">cc</font></div> <td> <tr valign=3Dtop> <td> <div align=3Dright><font size=3D1 face=3D"sans-serif">Subject</font></div> <td><font size=3D1 face=3D"sans-serif">Delete Records from Responsible and Leave Historical Records Unchanged</font></table> <br> <table> <tr valign=3Dtop> <td> <td></table> <br></table> <br> <br> <br><font size=3D2 face=3D"Arial">If we delete records from the responsible file when people leave our project, it sets the value of the responsible field in current PR records to "Unknown". Our desire is to remove their name from the dropdown list in the Responsible field, selected in the Edit PR form while retaining their name in Closed PR records and ideally in the Query forms (realising this last bit might be impossible).</font> <br><font size=3D3> </font> <br><font size=3D2 face=3D"Arial">Our workaround is to modify the responsib= le field to the new person in all PR records (even historical) before modifying the responsible file. The only problem with that workaround is it changes the name even for closed records and our history is incorrect ("Who controls the past controls the future." Orwell: "1984"), possibly contravening some Sarbanes-Oxley requirement (I'm not sure).</font> <br><font size=3D3> </font> <br><font size=3D2 face=3D"Arial">Help!</font> <p><font size=3D2 face=3D"Arial"><b>Craig Senior</b>, CMIIC</font><font siz= e=3D3> </font><font size=3D2 face=3D"Arial"><br> AIMS Configuration Manager</font><font size=3D3> </font><font size=3D1 face= =3D"Arial"><br> Public Works and Government Services Canada</font><font size=3D3> </font><f= ont size=3D1 face=3D"Arial"><br> Place du Portage, Ph III, 2A1, Stn 26L</font><font size=3D3> </font><font s= ize=3D1 face=3D"Arial"><br> W (819) 956-3295</font><font size=3D3> </font><font size=3D1 face=3D"Arial"= ><br> F (819) 956-6476</font><font size=3D3> </font><font size=3D1 face=3D"Arial"= ><br> [email protected]</font><font size=3D3> </font> <p><font size=3D3> </font><font size=3D2><tt>=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F= =5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F<br> Help-gnats mailing list<br> [email protected]<br> http://lists.gnu.org/mailman/listinfo/help-gnats<br> </tt></font> <p> --=_alternative 0066E75C86257282_=-- --===============0585657968== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Help-gnats mailing list [email protected] http://lists.gnu.org/mailman/listinfo/help-gnats --===============0585657968==--