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

mceclip0.png

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

Use case—Creating a new tree for trench occupancy

mceclip1.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

mceclip4.png