Confirm

Expand all | Collapse all

Feature - part of how many Inspection Routes ?

Jump to Best Answer
  • 1.  Feature - part of how many Inspection Routes ?

    Posted 08-17-2020 21:39
    Hi,

    Is there a way to check that a feature is currently a part of which Inspection Routes.

    Example - I have to end date a feature but I am not sure that feature is currently a part of how many Inspection Routes. There is an option of removing features with a dead flag from the inspection route but no option to add the new feature to the inspection routes from which the end dated feature has been removed.

    Regards,
    Lalit

    ------------------------------
    Lalit Sharma
    Westlink Services Pty Ltd
    Eastern Creek NSW
    ------------------------------


  • 2.  RE: Feature - part of how many Inspection Routes ?

    Posted 08-18-2020 03:20
    Hi Lalit

    To see what Inspection Routes a Feature is on you can create a Data Source to look at the insp_route_feat table.  This is the simplest SQL to do that.

    SELECT
      insp_route_code,
     site_code,
     plot_number
    FROM
     insp_route_feat;

    On many Confirm Client screens you can right click on a field and it will show you the database table and column it uses.  For instance on the Inspection Route screen, right clicking on the Asset Number field shows it is the insp_route_feat.plot_number in the database.  This is useful when creating Data Sources.

    ------------------------------
    Chris Wareham
    Senior Technical Support Analyst
    Confirm
    ------------------------------



  • 3.  RE: Feature - part of how many Inspection Routes ?
    Best Answer

    Posted 08-18-2020 04:28
    To build on Chris' answer above.

    On the Linked Tables tab of the Data Source screen; if you add in the Feature Table, this will give you the ability to drill-down to this report using the List button on the Feature Screen. The Data Source will also be pre-qualified to the Feature you are initiating it from.

    Might be a quick way of checking if the Feature you're currently viewing in the form is part any Inspection Route.

    You will need to expand the SQL slightly (and I've also added in the Route's Dead Flag to see if the Feature is part of a Dead Route):

    SELECT
       inspection_route.insp_route_code,
       insp_route_feat.site_code,
       insp_route_feat.plot_number,
       inspection_route.work_group_code,
       inspection_route.route_deadflag
    FROM
       inspection_route inner join insp_route_feat
          on inspection_route.insp_route_code = insp_route_feat.insp_route_code and
             inspection_route.work_group_code = insp_route_feat.work_group_code;​

    Hope this helps.

    Steve

    ------------------------------
    Steve Bish
    Senior Software Support Analyst
    Confirm
    ------------------------------



  • 4.  RE: Feature - part of how many Inspection Routes ?

    Posted 08-18-2020 21:05
    Hi Steve & Chris,

    Thanks for your inputs. It solved my problem.

    Regards,
    Lalit

    ------------------------------
    Lalit Sharma
    Westlink Services Pty Ltd
    Eastern Creek NSW
    ------------------------------