Useful Universe Filters

Document created by ftucker on Jun 20, 2014
Version 1Show Document
  • View in full screen mode

Example:

 

 

 

Additions to Request Filters Class:

 

z_Opened - Over 30 days ago

@Select(Request Detail\Open Date) <PdmToday(-1,-30)

 

z_Opened – Last Month

@Select(Request Detail\Open Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Resolved – Last Month

@Select(Request Detail\Resolve Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Closed – Last Month

@Select(Request Detail\Close Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Time Stamp –Request- Last 7 days

@Select(Request Activity\Time Stamp) BETWEEN PdmAddDays(-7) AND PdmAddDays(0)

 

 

Additions to Request Detail Class:

 

z_Affected_Service_Symbol

 

Name: z_Affected_Service_Symbol

Type: Character

Select: nr.name

Where: cr.affected_service=nr.id

 

Additions to Change Filters Class:

 

z_Scheduled End Date – Last Month

@Select(Change Detail\Schedule End Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Time Stamp –Change- Last 7 days

@Select(Change Activity\Time Stamp) BETWEEN PdmAddDays(-7) AND PdmAddDays(0)

 

 

Additions to Key Performance Indicator\KPI Filters Class:

 

z_Kpi Ticket Data End Time - Last Month

@Select(Kpi Ticket Data\End Time) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

Additions to Survey\Survey Filters Class:

 

z_Survey Answer Last_Mod_Dt - Last Month

@Select(Survey Answer\Last Mod Dt) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

Additions to Resources\Resource Filters Class:

 

z_Creation Date - Last Month

@Select(Resource Detail\Creation Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Delete Time - Last Month

@Select(Resource Detail\Delete Time) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Last Modified Date - Last Month

@Select(Resource Detail\Last Modified Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

Additions to Resources\CMDB\CI Activity Log\CI Activity Log Filters Class:

 

z_Last Mod Dt - Last Month

@Select(CI Activity Log\Last Mod Dt) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Time Stamp or System Time - Last Month

@Select(CI Activity Log\Time Stamp) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

 

z_Opened - Over 7 days ago

@Select(Request Detail\Open Date) <PdmToday(-1,-7)

 

z_Closed - in last 7 days

@Select(Request Detail\Close Date) BETWEEN PdmAddDays(-7) AND PdmAddDays(0)

 

z_Closed - Last Month

@Select(Request Detail\Close Date) BETWEEN PdmToday(-1,1,-1) AND PdmToday(1,31,-1)

3 people found this helpful

Attachments

Outcomes