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)