Re: Require Worklog Change
I know this may be old school but I would use TR.Assigned Group != DB.Assigned Group and TR.Assigned Group != $NULL$ AND TR.Worklog = $NULL$. Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 Helpful Links: | Reports |SA_Suggestion Box | SA_Trouble Ticket | -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Wednesday, March 16, 2011 8:31 AM To: arslist@ARSLIST.ORG Subject: Require Worklog Change I would like to force a worklog entry on a form anytime the assigned group changes. I wanted to get opinions on the best way to accomplish this. I was thinking you would use a filter with a "Run If" like: TR.Assigned Group != $NULL$ AND TR.Worklog = $NULL$ But I wasn't sure if this would be the best way. I thought I remember seeing this on the list before, but I didn't have any luck searching for it. Andy L. Mayfield Sr. SCADA Operation Center Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Require Worklog Change
Andy, Most people would write it like you have, but you will find many people on the ARSLIST including me, who prefer something like this: Assigned Group != DB.Assigned Group AND TR.Worklog = $NULL$ Reliance on TR value assumes the update came from a manual save from Windows or Browser client using the built-in Save button/menu choice (as opposed to from a record displayed on a dialog window and an Active Link push field action; or from an API program or Push Field filter action triggered from another record/transaction). True most of the time for most setups, so you might get away with it. But it can cause trouble, so write it the above way, if you want it "bullet proof". I do not wish to start a long thread on this topic. It has been talked to death in the past, but I can elaborate it for you, if you wish. Note that I left the TR alone for WorkLog field, because it, I am assuming, is a "diary" type of field that is treated differently by active links and filters. I think TR prefix should work for this field. --- On Wed, 3/16/11, Mayfield, Andy L. wrote: > From: Mayfield, Andy L. > Subject: Require Worklog Change > To: arslist@ARSLIST.ORG > Date: Wednesday, March 16, 2011, 9:30 AM > I would like to force a worklog entry > on a form anytime the assigned group changes. > > I wanted to get opinions on the best way to accomplish > this. > > I was thinking you would use a filter with a "Run If" > like: TR.Assigned Group != > $NULL$ AND TR.Worklog = $NULL$ > > But I wasn't sure if this would be the best way. I thought > I remember seeing this on the list before, but I didn't have > any luck searching for it. > > Andy L. Mayfield > Sr. SCADA Operation Center Technician > Alabama Power Company > Office: 205-226-1805 > Cell: 205-288-9140 > SoLinc: 10*19140 > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers > Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Require Worklog Change
Old dogs, same trick. I would agree with Roger however I don't use the TR. Rather I use (Assigned Group != DB.Assigned Group). I have an active link that puts ticket assigned to %Assigned Group$. I also have an active link that makes entry in the Work Log required. If you have something similar then the "AND TR.Worklog = $NULL$" is overkill. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nall, Roger Sent: Wednesday, March 16, 2011 1:31 PM To: arslist@ARSLIST.ORG Subject: Re: Require Worklog Change I know this may be old school but I would use TR.Assigned Group != DB.Assigned Group and TR.Assigned Group != $NULL$ AND TR.Worklog = $NULL$. Roger Nall Manager, SA Business Intelligence/Remedy Desk Phone: 972-464-3712 Mobile: 973-652-6723 Helpful Links: | Reports |SA_Suggestion Box | SA_Trouble Ticket | -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Wednesday, March 16, 2011 8:31 AM To: arslist@ARSLIST.ORG Subject: Require Worklog Change I would like to force a worklog entry on a form anytime the assigned group changes. I wanted to get opinions on the best way to accomplish this. I was thinking you would use a filter with a "Run If" like: TR.Assigned Group != $NULL$ AND TR.Worklog = $NULL$ But I wasn't sure if this would be the best way. I thought I remember seeing this on the list before, but I didn't have any luck searching for it. Andy L. Mayfield Sr. SCADA Operation Center Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Require Worklog Change
Thank you for the responses. I can see there are several ways to skin this cat. With the luck I've been having lately, I think I'll try the bullet proof method. Thanks All. Andy L. Mayfield Sr. SCADA Operation Center Technician Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rabi Tripathi Sent: Wednesday, March 16, 2011 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Require Worklog Change Andy, Most people would write it like you have, but you will find many people on the ARSLIST including me, who prefer something like this: Assigned Group != DB.Assigned Group AND TR.Worklog = $NULL$ Reliance on TR value assumes the update came from a manual save from Windows or Browser client using the built-in Save button/menu choice (as opposed to from a record displayed on a dialog window and an Active Link push field action; or from an API program or Push Field filter action triggered from another record/transaction). True most of the time for most setups, so you might get away with it. But it can cause trouble, so write it the above way, if you want it "bullet proof". I do not wish to start a long thread on this topic. It has been talked to death in the past, but I can elaborate it for you, if you wish. Note that I left the TR alone for WorkLog field, because it, I am assuming, is a "diary" type of field that is treated differently by active links and filters. I think TR prefix should work for this field. --- On Wed, 3/16/11, Mayfield, Andy L. wrote: > From: Mayfield, Andy L. > Subject: Require Worklog Change > To: arslist@ARSLIST.ORG > Date: Wednesday, March 16, 2011, 9:30 AM > I would like to force a worklog entry > on a form anytime the assigned group changes. > > I wanted to get opinions on the best way to accomplish > this. > > I was thinking you would use a filter with a "Run If" > like: TR.Assigned Group != > $NULL$ AND TR.Worklog = $NULL$ > > But I wasn't sure if this would be the best way. I thought > I remember seeing this on the list before, but I didn't have > any luck searching for it. > > Andy L. Mayfield > Sr. SCADA Operation Center Technician > Alabama Power Company > Office: 205-226-1805 > Cell: 205-288-9140 > SoLinc: 10*19140 > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers > Are" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
