I like Misi's suggestion better. I've never really used GetEntry filters. I always thought it would cause too much overhead given the amount of queries ran, but if you use a display-only field it won't incur any additional database cost so it should be pretty harmless. And it will be much more efficient than pulling in the diary from the database.
Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Misi Mladoniczky Sent: Thursday, October 25, 2007 9:31 AM To: [email protected] Subject: Re: Diary Fields Hi! This suggestion would require two extra API-calls from the client, to the arserver and to the database, which is bad for performance. I would suggest that you instead create a Display-Only Selection-Field called DiaryFlag with the values Yes/No. Creat a filter that triggers on GetEntry, with the following Run If: ('Diary' = $NULL$) If Action: DiaryFlag = No Else Action: DiaryFlag = Yes Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > I think you'll have to first use a Set Field to pull in the database > value of your diary field to a display-only character field. Then use > 'displayonly_field' != $NULL$ in your active link's Run If. Otherwise > the active link will only look at the current updates to your diary > field on the screen. > > > > Chad Hall > (501) 342-2650 > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. > Sent: Thursday, October 25, 2007 9:08 AM > To: [email protected] > Subject: Diary Fields > > > > This may be a dumb question, but..... > > > > Can you use the qualification of != $NULL$ on a diary field? I want > to have an active link fire if there are any previous entries in a diary > field, but it doesn't seem to be working. > > > > Andy L. Mayfield > Sr. System Operation Specialist > Alabama Power Company > Office: 205-226-1805 > Cell: 205-288-9140 > SoLinc: 10*19140 > > > > __20060125_______________________This posting was submitted with HTML in > it___ > ************************************************************************ * > The information contained in this communication is confidential, is > intended only for the use of the recipient named above, and may be > legally privileged. > > If the reader of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or copying of this > communication is strictly prohibited. > > If you have received this communication in error, please resend this > communication to the sender and delete the original message or any copy > of it from your computer system. > > Thank you. > ************************************************************************ * > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
