Installing and Setting up Feature Explorer

Feature Explorer is a useful tool in the NET working environment. If the tool has been correctly configured, it supports effective working and the mapping of complex relationships in the data structure. Feature Explorer is integrated into the TKI extensions module.

mceclip0.png

 

Three predefined trees are created during installation by default: Addresses, service on cable section and customer services

mceclip1.png

  1. Selection of existing search options (of a query tree)
  2. Create New / Rename / Delete a tree
  3. Add / Delete a hierarchical sub-query
  4. Move a hierarchical sub-query
  5. Name of the selected sub-query
  6. Enable / Disable a sub-query
  7. Validate the SQL query for the sub-query
  8. SQL query for the sub-query
  9. Loads the results of the sub-query with the higher-layer element. As a rule, however, this is only necessary in the first layer
  10. Save / Cancel changes to a sub-query

Use case—Creating a new tree for trench occupancy

mceclip2.png

SQL statements

-- Trench -------------------------------------------------------------------------------------------
SELECT s.fid, l.name FROM tc_sp_segment s JOIN tc_line l ON s.fid = l.fid_attr order by 2

-- Ducts and cables in first layer ------------------------------------------------------------------
SELECT d.fid, 'Duct: ' || l.name as name from tc_sp_duct d JOIN tc_line l ON d.fid = l.fid_attr
where d.fid in (select fid_duct from tc_sp_segment_duct where fid_segment = {0:fid})
UNION
SELECT c.fid, 'Cable: ' || l.name as name from tc_fo_cable c JOIN tc_line l ON c.fid = l.fid_attr
where l.fid in (select fid_line from tc_sp_segment_cable where fid_segment = {0:fid})

-- Ducts and cables in second layer -----------------------------------------------------------------
SELECT d.fid, 'Duct: ' || l.name as name from tc_sp_duct d JOIN tc_line l ON d.FID = l.fid_attr
where d.FID in (select fid_duct from tc_sp_duct_duct where fid_outer_duct = {1:FID})
UNION
SELECT c.FID, 'Cable: ' || l.name as name from tc_fo_cable c JOIN tc_line l ON c.fid = l.fid_attr
where l.fid in (select fid_line from tc_sp_duct_cable where fid_duct = {1:fid})

 

Result

mceclip5.png