Yep - was just wondering whether anyone saw this before - wasn't sure if it was a known issue with the advanced search on the web.
----- Original Message ----- From: "LJ CTR MDA Longwing/IC" <lj.longwing....@mda.mil> To: arslist@ARSLIST.ORG Sent: Friday, June 8, 2012 1:03:05 PM Subject: Re: Question on advanced search Pritch, I would recommend doing SQL logs of the working and non working scenarios at the server level and compare the strings being sent to the server. This may help you identify the difference between the native/client. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pritch Sent: Friday, June 08, 2012 10:24 AM To: arslist@ARSLIST.ORG Subject: Question on advanced search Here's a scenario I'm running into: I'm on ARS 7.6.03 / ITSM Suite 7.6.00 Server is set to GMT Client is in Eastern timezone (-4 hours currently). User Preference locale is set to Eastern Time. Client submits ticket with a scheduled end time of 5/31/2012 @ 11:00pm (23:00). The time on the saved ticket in the database (seen via the audit log) gets converted to 6/1/2012 @ 03:00 which based on the time zones is expected since the audit log is written at the server level. Client does a query of tickets with a scheduled end date less than 6/1/2012 (placing < 6/1/2012) in the Scheduled End Date field both with the user tool and on the web. Via the user tool, the result list includes the ticket submitted with the scheduled end time of 7/31/2012 @ 11:00pm. Via the web, the result list includes the ticket submitted with the scheduled end time of 7/31/2012 @ 11:00pm. Client does a query of tickets with a scheduled end date that occured in the Month of May via an Advanced Search both with the user tool and on the web. ('Scheduled End Date' >= "5/31/2012" AND 'Scheduled End Date' < "6/01/2012") Via the user tool, the result list includes the ticket submitted with the scheduled end time of 7/31/2012 @ 11:00pm. Via the web, the result list does not include the ticket. Is this a known issue? Anyone seen this before? _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
