I am trying to create a report to show all defects received and the defect reason, however I cannot work out how to add the reason for the defect which appears against an Inspected item. Its ok if the details are in the comments box but when they are against an item, for example item 3 Saftey Zone, and the detail is listed in the Defect text I can't work out how to show this. the current items in my report are:-
TWor Works Ref
Tire Date created
Tica Category Name
Twor External Ref
Tphs Contractor Name
Tirs Site Comment Text
Tirs Slg Default Text
Tirs SLG Default flag
Tirs Site No
Tirs Sampled Site
Tirs Site Location Text
Any help would be appreciated. Thanks ali
In order to return the site item details, you will need to link the TMA_INSP_RESULTS_SITES_ALL
table (that you're already using) to the TMA_INSP_RESULT_LINES table, and collect the site item details from there. The link will need to be done using the TIRS_INSPECTION_ID and TILI_INSPECTION_ID columns.
Please have a look and let us know how you get on.
Lee Jackson | Product Manager
there are not items availible to me which start TILI, where do i find these? I have shared the report with the atlas user, it is called Failed Inspections - Test
With the help of the managed service team I have created the join Lee suggested and also added additional IMFViews which should help you in future build more detailed reports.
Please can you test and let me know if the join has now enabled you to create a report with the desired columns.
sorry i'm now more confused than i think i was to start with!
What Jodie and the MAS team have done is add the Information Manager views to your existing business area, which gives you a lot more data to choose from.
When selecting data from multiple tables or views, you need to create a join between them in order to identify which records should be returned,
In this case a join has been created between TMA_INSP_RESULTS_ALL table and the IMF_TMA_INSP_RESULT_LINES view using the inspection ID.
I have now added the inspection Item Type Name and Defect Reason Text to the report for you. I also added a condition to only select Defect Reason Text where it is not null, which should make the results clearer. I've saved this report as Failed Inspections - test 2' and shared the report with you.
Please could you review the report and let us know if it fulfils your requirements, or any further questions you have?
Answer Verified By: Alison Pyott