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
------------------------------
Original Message:
Sent: 08-18-2020 03:19
From: Chris Wareham
Subject: Feature - part of how many Inspection Routes ?
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
Original Message:
Sent: 08-17-2020 21:38
From: Lalit Sharma
Subject: Feature - part of how many Inspection Routes ?
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
------------------------------