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
Active Requests with no Date Range  XML
Forum Index » Analyzer/Reporting
 
Author Message
[Post New]21/12/2011 23:26:00
    Subject: Active Requests with no Date Range
[Up]
zackiechan
SysAider

SysAider from release 6 United States
Joined: 21/12/2011
Messages: 5
Offline
Hello,

I am hoping I am missing something simple here. I am trying to automate a report to run at the beginning of each week showing the currently active SR's. That is ALL the current active SR's and not just a date range. If I run it manually I can make a very large date range that encompasses the entire period we have been making SR's but the date obviously wouldn't increase each week on the automated version.

Is there a way to do this?

Thank you kindly and Happy Holidays!

ZC
[Post New]29/12/2011 23:03:44
    Subject: Re:Active Requests with no Date Range
[Up]
zackiechan
SysAider

SysAider from release 6 United States
Joined: 21/12/2011
Messages: 5
Offline
Has nobody else had an issue with this? With not being able to see all active requests in an automated report? Please, any help or a point in the right direction would be greatly appreciated!

Thank you!

ZC
[Post New]14/02/2012 15:55:44
    Subject: Re:Active Requests with no Date Range
[Up]
zackiechan
SysAider

SysAider from release 6 United States
Joined: 21/12/2011
Messages: 5
Offline
For any who might be having a similar issue or would simply like to know the given solution:

SysAid support suggested I simply change my date ranges in the automated report to way back in the past as far as I would like; then select a future date that is way in the future so that it encompasses all Active tickets.

ZC
[Post New]13/07/2012 20:10:34
    Subject: Re:Active Requests with no Date Range
[Up]
houmadath
SysAider

SysAider from release 7.5 Trinidad and Tobago
Joined: 13/07/2012
Messages: 3
Offline
Ok.
For those of you have and continue to have this issue, I've found the perfect solution:

Original Selection :r.insert_time between ? and ?

Replacement :r.insert_time between ? and ? ((r.insert_time between ? and ?) or r.insert_time >'1/1/1900')

I too had tried removing the parameters, etc. but that proved to be a headache. So instead of making the selection of insert date active, I made it passive.
Of course, in the jrxml file, I also removed the dates from printing. Elementary my dear Watson.

Now, you can report on any service request that has any status using the following:
sqlStat = "select r.id id_zzz_SR,r.problem_type problem_type_zzz_SR,r.problem_sub_type problem_sub_type_zzz_SR,r.third_level_category third_level_category_zzz_SR,r.description description_zzz_SR,r.notes notes_zzz_SR,r.id activities_zzz_SR,r.request_user request_user_zzz_SR,r.insert_time insert_time_zzz_SR,r.due_date due_date_zzz_SR ,r.responsibility responsibility_zzz_SR,a.id activity_id_zzz_ASR ,a.from_time from_time_zzz_ASR, a.to_time to_time_zzz_ASR from service_req r INNER JOIN work_report a ON ( a.account_id = r.account_id and a.service_req_id = r.id ) "+ moreJoin + " where r.account_id = ? and ((r.insert_time between ? and ?) or r.insert_time > '1/1/1900') and ( not ( problem_type=N'External Projects' ) and not ( problem_type=N'IT Internal' ) and not ( problem_type=N'Programming Help Desk' ) and not ( problem_type=N'Projects' ) and not ( problem_type=N'Special Project' ) and not ( problem_type=N'Special Project' ) and not ( problem_type=N'Telephone' ) and (r.status <> 3 or r.status is null)) " + moreWhere + sqlWizardFilters;

This message was edited 2 times. Last update was at 13/07/2012 20:12:04
[Email]
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