Delete Records from Responsible and Leave Historical Records Unchanged
"Craig Senior" <[email protected]> Wed, 14 Feb 2007 13:21:48 -0500
| Newsgroups | gmane.comp.bug-tracking.gnats.general |
|---|---|
| Message-ID | <9BC68B47FF9B044F802B5E9B36FA439704F7BE13@mb-ncr-022.ad.pwgsc-tpsgc.gc.ca> |
This is a multi-part message in MIME format.
--===============0421238119==
Content-class: urn:content-classes:message
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C75064.FDDD8B98"
This is a multi-part message in MIME format.
------_=_NextPart_001_01C75064.FDDD8B98
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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).
=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 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).
=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
=20
------_=_NextPart_001_01C75064.FDDD8B98
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1589" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D484470818-14022007><FONT face=3DArial size=3D2>If we =
delete records=20
from the responsible file when people leave our project, it sets the =
value of=20
the responsible field in current PR records to "Unknown". Our desire is =
to=20
remove their name from the dropdown list in the Responsible field, =
selected in=20
the Edit PR form while retaining their name in Closed PR records and =
ideally in=20
the Query forms (realising this last bit might be=20
impossible).</FONT></SPAN></DIV>
<DIV><SPAN class=3D484470818-14022007><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D484470818-14022007><FONT face=3DArial size=3D2>Our =
workaround is to=20
modify the responsible field to the new person in all PR records =
(even=20
historical) before modifying the responsible file. The only problem with =
that=20
workaround is it changes the name even for closed records and our =
history is=20
incorrect ("Who controls the past controls the future." Orwell: "1984"), =
possibly contravening some Sarbanes-Oxley requirement (I'm not=20
sure).</FONT></SPAN></DIV>
<DIV><SPAN class=3D484470818-14022007><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D484470818-14022007><FONT face=3DArial=20
size=3D2>Help!</FONT></SPAN></DIV><!-- Converted from text/rtf format =
-->
<P><B><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Craig=20
Senior</FONT></SPAN></B><SPAN lang=3Den-us><FONT face=3DArial size=3D2>, =
CMIIC</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT face=3DArial =
size=3D2>AI</FONT><FONT=20
face=3DArial size=3D2>MS Configuration Manager</FONT></SPAN> <BR><SPAN=20
lang=3Den-us><FONT face=3DArial size=3D1>Public Works and Government =
Services=20
Canada</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT face=3DArial =
size=3D1>Place du=20
Portage, Ph III, 2A1, Stn 26L</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT =
face=3DArial size=3D1>W (819) 956-3295</FONT></SPAN> <BR><SPAN =
lang=3Den-us><FONT=20
face=3DArial size=3D1>F (819) 956-6476</FONT></SPAN> <BR><SPAN =
lang=3Den-us><FONT=20
face=3DArial size=3D1>[email protected]</FONT></SPAN> </P>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C75064.FDDD8B98--
--===============0421238119==
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
--===============0421238119==--