Brian, Thats absolutely fantastic - exactly what I was looking for :) Regards
Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Brian Bishop Sent: 07 May 2009 14:00 To: [email protected] Subject: Re: What would $--1$ relate to? ** Dave, The value $--1$ is a Remedy keyword conversion that means $NULL$. So in your case it is checking that the fields are NULL. Here is a list of keywords conversions I compiled many years ago which may have been added to since doing it. $-1$ = $USER$ $-2$ = $TIMESTAMP$ $--1$= $NULL$ $-6$ = $SERVER$ $-5$ = $SCHEMA$ $-0$=$DEFAULT$ $-4$=$DATE$ $-14$=$LASTCOUNT$ $-13$=$LASTID$ $-3$-$TIME$ $-7$=$WEEKDAY$ Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Barber, David Sent: 07 May 2009 13:44 To: [email protected] Subject: What would $--1$ relate to? ** Seen on a macro/search - field 1 = $--1$ and also a little later in the same search - field 2 = $--1$ The first field is an assignee, but the second is just a flag. Not exactly obvious what it does at all. Any ideas? Ta Dave This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.12.21/2101 - Release Date: 05/07/09 05:57:00 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
<<image001.gif>>
