how linked tickets are tracked and displayed for Preventive Maintenance Procedures
Problem:
When you create an issue report linked to a preventive maintenance (PM) ticket, the relationship is visible in the system (e.g., in the "Related Requests" section of the ticket search screen).
However, in the database, the PM ticket doesn’t show the issue report’s information (i.e., no backlink). Only the issue report contains the PM ticket's reference (parentwrid field).
Where Data is Stored:
For active tickets, the information is in the wr table.
For completed tickets, it’s in the hwr table, specifically in the parentwrid field.
To find all issue reports linked to a PM ticket, you have to search the table using the PM ticket’s code.
Finding Linked Reports:
To check all linked issue reports:
Go to the ticket search screen.
Look at the "Related Requests" section.
Alternatively, query the database tables (wr or hwr) using the PM ticket's code.
Challenge for Users:
Users without access to the database (SmartClient) must manually filter tickets by the PM procedure and review each ticket to find linked issue reports.
This process is time-consuming.
Can you suggest how Users can input a PM procedure code and see all related issue reports in one list. This would save time and eliminate manual searching.
