But I am Required Resolution Date (date/time field) to $TIMESTAMP$+(60*60*24*$NumberOfDays$)
Required Resolution Date is on the current form, but $NumberOfDays$ is from the selected form; it is an integer field on the form I'm searching. Anne Ramey Remedy System Administrator State of North Carolina Office of Information Technology Services (ITS) Service Delivery Division ITSM & ITAM Services Office (919) 754-6521 Home Office (919) 842-5420 ITS Service Desk : (919) 754-6000 or (800) 722-3946 anne.ra...@nc.gov<mailto:anne.ra...@its.nc.gov> http://its.state.nc.us<http://its.state.nc.us/> RHCE, ITIL Foundation *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Thursday, June 03, 2010 11:58 PM To: arslist@ARSLIST.ORG Subject: Re: Curious filter issue ** Anne, The reason it's changing back to 'current transaction' is because you aren't setting a field on your form with a field from the search....it's an annoying feature, but it's there.... From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Thursday, June 03, 2010 7:24 PM To: arslist@ARSLIST.ORG Subject: Re: Curious filter issue ** The filter log is not helpful, it just shows the field being set to the current time stamp (because the value isn't being pulled from the form it's supposed to be because the filter is incorrectly changing to "current transaction" from the correct selection criteria). I didn't grab the SQL log, I'll have to do that and see what it says. Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, June 03, 2010 5:56 PM To: arslist@ARSLIST.ORG Subject: Re: Curious filter issue ** Depending on what you have used to set that field, take an active link or a filter or escalation log and see what happens when that piece of workflow fires... An SQL log might be useful too.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne Sent: Thursday, June 03, 2010 5:49 PM To: arslist@ARSLIST.ORG Subject: Re: Curious filter issue ** I checked, it's Date/Time Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Thursday, June 03, 2010 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Curious filter issue ** Anne, Make sure that the field you have created is not a Date Only field but a Date and Time field.. If its a Date Only field then your calculation should be $DATE$*$NumberOfDays$. The Date Only field type uses $DATE$ and is different from the Date and Time field type which uses $TIMESTAMP$ for setting values to it.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Ramey, Anne Sent: Thursday, June 03, 2010 3:49 PM To: arslist@ARSLIST.ORG Subject: Curious filter issue ** I have a set fields action that just doesn't like what I'm setting the field to. I'm trying to set a date field using math; I'm trying to set Required Resolution Date (date/time field) to $TIMESTAMP$+(60*60*24*$NumberOfDays$) on some custom forms and it just doesn't work. If I set it with another date/time field, it works, but if I try and calculate time using timestamp, it doesn't. According to abydos, if I put in the calucation, the other part of the action changes from selecting from my form to "current transaction"--but this is not reflected on the screen when looking at the filter in administrator. I came up with a work around, but I wonder if this is expected behavior, if I'm doing something wrong, or if I found a weird bug. Has anyone else seen this type of thing before? ARS 7.1 ITSM 7.0.3 CMDB 2.1 p4 Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
