Skip to Main Content
Autodesk
Status Gathering support
Product Info360 Asset
Created by Martha Nunez
Created on Nov 26, 2024

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
  • 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