Skip to Main Content
Autodesk

Count of inspections query in rehab tree

Count the number of inspections in a pipe. This is a query in IAP that might be utilized to check if a pipe has had an inspection reversal or simply to check how many inspections have been conducted in a pipe.

  • Attach files
      Drop here to upload
    • Admin
      Tony Andrews
      Reply
      |
      Nov 27, 2024

      We can certainly look to include a new data field to count the number of inspections like we have for counting defects in RDT query.

      I think this raises a broader request to have more flexibility for a user to create their own reports using group by functions. For example, in InfoAsset Manager this would be equivalent to running SELECT Count(*) GROUP BY pipe.asset_id on the CCTV table or SELECT asset_id, COUNT(cctv_surveys.*) ORDER BY COUNT(cctv_surveys.*) DESC on pipe table.


    • +1