I think this was already replied to correctly earlier.
Diary fields, when referenced in qualifications only reference transaction data. To see if there are previous entries in a Diary field, simply set a DO integer field from direct SQL. For example, in field "diary_field" in table "mytable" with field '1' named "request_id" and field xxx being a DO integer with change off: select length(diary_field) from mytable where request_id = $request_id$ set field xxx with that value ($1$). Then, if xxx contains 0, no previous data in a diary field. Else, previous data exists in that field. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:ben.cher...@softwaretoolhouse.com> Ben.Chernys _AT_ softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall Sent: August-12-11 18:01 To: arslist@ARSLIST.ORG Subject: Re: Run If check for a Diary field ** This might be a silly answer if you've already tried, but what about 'Diary field' != "" Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com <http://www.jcp.com/> | 972.431.1518 _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt Sent: Friday, August 12, 2011 6:58 PM To: arslist@ARSLIST.ORG Subject: Re: Run If check for a Diary field Sorry it took so long to get back on this. I just assumed it would work since it seems so logical, but it does not. No errors, just no data showing up in my temporary field. I also tried LENGTHC($field$) and that didn't work either. Just stays blank. Any other suggestions? Curt A. Schryver Action Request System Administrator TE Connectivity 717-810-2109 tel 717-810-2124 fax cschry...@te.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Tuesday, August 02, 2011 4:25 PM To: arslist@ARSLIST.ORG Subject: Re: Run If check for a Diary field ** Do a setfields from the current record into a 0 length hidden char field, then run a != $NULL$ against that. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Schryver, Curt Sent: Tuesday, August 02, 2011 2:01 PM To: arslist@ARSLIST.ORG Subject: Run If check for a Diary field ** Hope this isn't TOO much of a silly question, but I can't seem to figure it out. I want to display more of an indicator that there is data in a Diary field than the built-in "there is writing" or "there isn't writing" in the little book icon. Using 'Diary field' != $NULL$ doesn't work in the Run If check - it always resolves that it's Null. Is there some way to determine that there is data in a Diary field? Curt A. Schryver Action Request System Administrator TE Connectivity 717-810-2109 tel 717-810-2124 fax cschry...@te.com 100 AMP Drive MS 161-043 Harrisburg, PA 17105 <http://www.te.com/> Description: Logo for emails _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
<<image001.jpg>>