Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Expression Builder Help  XML
Forum Index » Analyzer/Reporting
 
Author Message
[Post New]17/04/2012 14:06:07
    Subject: Expression Builder Help
[Up]
rramalia
SysAider

SysAider from release 7.5
Joined: 01/11/2011
Messages: 2
Offline
I am trying to create a custom report to show all active tickets that have been open for longer than one week.

I was able to create a report and schedule it to run once a week, however I can not figure out how to set it so the request time is a floating 7 day prior rather that a set date.

Any help would be appreciated.
[Post New]17/04/2012 14:38:40
    Subject: Re:Expression Builder Help
[Up]
CarlH
Elite SysAider

SysAider from release 4.5 United States Pathfinder
Joined: 30/01/2009
Messages: 178
Offline
This would be pretty easy to do in SQL, but I assume you want it through the actual sysaid program?
[Post New]17/04/2012 14:41:29
    Subject: Re:Expression Builder Help
[Up]
rramalia
SysAider

SysAider from release 7.5
Joined: 01/11/2011
Messages: 2
Offline
CarlH wrote:This would be pretty easy to do in SQL, but I assume you want it through the actual sysaid program?


Unfortunately yes, our sysaid server is hosted and we do not have access to the backend.
[Post New]07/05/2012 19:11:02
    Subject: Re:Expression Builder Help
[Up]
Oded M
VP Product


Joined: 28/05/2008
Messages: 892
Offline
Here is an idea you can try :

Sysaid comes with 2 deafault times that count the elapsed time of a ticket,
Fields : time to repair and time to respond

You can easily setup a filter on time to repair larger then X depending on your operating hours to represent a week or any other fixed time, just add another condition that the Status isnt closed and you should be ok,

Good luck!

Oded
Forum Index » Analyzer/Reporting
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
    SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011 		   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use