Expand all | Collapse all

SW Assigned Inspections

  • 1.  SW Assigned Inspections

    Posted 12-10-2020 11:37


    I was wondering if anyone could help or already has an SQL query that shows Street works inspections allocated.
    So all assigned inspections or alternatively all assigned works to a specific officer so then you can see the type of work they have and how much further work they may need.

    This would in theory pull all street works inspections (for permit checking) showing the inspections that are still "in progress" and then once completed by the officer would be removed from the data source.

    Any help would be appreciated.

    Louis Johnston
    Hull City County Council

  • 2.  RE: SW Assigned Inspections

    Posted 15 days ago
    Hi Louis,

    Consider looking in the Database Schema at the program_insp (Programmed Inspections) table.  This contains all outstanding Street Works Inspection records and which Action Officer they're assigned to.

    I hope this helps.

    Kind regards,

    Steve Bish
    Senior Software Support Analyst