Latest posts for the topic "Active Requests with no Date Range"

Active Requests with no Date Range

zackiechan — GMT

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

Re:Active Requests with no Date Range

zackiechan — GMT

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

Re:Active Requests with no Date Range

zackiechan — GMT

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

Re:Active Requests with no Date Range

houmadath — GMT

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;