![]() |
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.
Disclaimer: The development, release, and timing of any features or functionality described or discussed for our products in this User Feedback Forum for Autodesk Water Products and Services remains at our sole discretion. This User Feedback Forum for Autodesk Water Products and Services is not a commitment, promise, or legal obligation to deliver any functionality, is intended solely to outline and gather feedback about our general product direction, and should not be relied on in making purchasing decisions.
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.