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. <almay...@southernco.com> wrote: > From: Mayfield, Andy L. <almay...@southernco.com> > 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"
