— Anna Dowling 2019/01/11 06:21

The following entry provides a breakdown of the conditions which will return Maintenance results for the 3 core Maintenance Jobs that run in the Preventative Maintenance process currently(ReadyMaintenance, Acceptance, Overdue).

Maintenance Entries will be retrieved if the following conditions are met:

maintenance.next_ticket_date < NOW()
AND
maintenance.active = true
AND
maintenance.expired = false
OR 
(
maintenance.current_open_ticket IS NULL
LEFT_JOIN
maintenance.current_open_ticket.closed_date IS NOT NULL
)

LIMIT (200)

Maintenance Entries will be retrieved if the following conditions are met:

maintenance.active = true
AND
maintenance.expired = false
OR 
(maintenance.next_ticket_date > CRAZY_DATE(9999)
AND maintenance.next_ticket_date IS NULL)

AND (external_element.acceptance_record_id(ticket).closed_date) IS NOT NULL

LIMIT (200)

Maintenance Entries will be retrieved if the following conditions are met across the 2 queries:

maintenance.last_completed < new Date() - dueInterval (dueInterval is set in config, if not set, it defaults to one year)
AND
maintenance.active = true
AND
LEFT_JOIN AutoTicketPolicy (nonQuarterlyPolicies)
LEFT JOIN maintenance.current_open_ticket on ticket_status = PM_REQUIRED
OR
(
external_element.external_table.default_acceptance_workflow_id IS NULL
AND 
(external_element.acceptance_record_id(ticket).closed_date) IS NOT NULL
)

maintenance.last_completed IS NULL
AND
maintenance.active = true
AND
LEFT_JOIN AutoTicketPolicy (nonQuarterlyPolicies)
OR
(
external_element.external_table.default_acceptance_workflow_id IS NULL
AND 
(external_element.acceptance_record_id(ticket).closed_date) IS NOT NULL
)

Maintenance Entries will be retrieved if the following conditions are met for the AutoTicketPolicy QUARTERLY:

maintenance.active = true
AND
maintenance.expired = false

LEFT JOIN
maintenance.current_open_ticket.create_date < Quarter.resolveFromDate(overdueAtThisTime).getStartDate(overdueAtThisTime) (TODAYS DATE < THE CURRENT QUARTER START DATE)
AND
maintenance.current_open_ticket.closed_date IS NULL

LEFT_JOIN 
AutoTicketPolicy (PolicyType.QUARTERLY)

LEFT JOIN
maintenance.current_open_ticket.status = PM_REQUIRED

OR
(
external_element.external_table.default_acceptance_workflow_id IS NULL
AND 
(external_element.acceptance_record_id(ticket).closed_date) IS NOT NULL
)