Internal Errigal Collaboration Wiki

User Tools

Site Tools

Trace: • res-p9114 • res-p1113
resolution_area:prometheus_resolutions:res-p9124

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
resolution_area:prometheus_resolutions:res-p9124 [2022/12/22 15:44] – created 10.91.110.100resolution_area:prometheus_resolutions:res-p9124 [2024/02/07 07:59] (current) – 10.91.120.100
Line 15: Line 15:
  
 <code> <code>
-SELECT * FROM network_element ne+SELECT GROUP_CONCAT(ne.id) FROM network_element ne
 WHERE (ne.network_identifier = 'n/a' WHERE (ne.network_identifier = 'n/a'
 OR ne.network_identifier IS NULL OR ne.network_identifier IS NULL
Line 24: Line 24:
 AND technology NOT IN ('NON_DAS', 'n/a') AND technology NOT IN ('NON_DAS', 'n/a')
 AND ne.parent_id != 3045 # orphan AND ne.parent_id != 3045 # orphan
-AND ne.date_added > '2022-12-01 00:00:00';+AND ne.date_added > '2022-12-01 00:00:00' 
 +GROUP BY NULL;
 </code> </code>
  
Line 33: Line 34:
 JOIN site_network_element ON site_network_element.network_element_id = network_element.id JOIN site_network_element ON site_network_element.network_element_id = network_element.id
 JOIN site ON site.id = site_network_element.site_network_elements_id  JOIN site ON site.id = site_network_element.site_network_elements_id 
-SET network_identifier = CONCAT(site.site_number, ' ', site.site_identifier) +SET network_element.network_identifier = CONCAT(site.site_number, ' ', site.site_identifier) 
-WHERE id in  +WHERE network_element.id IN (<NE_IDS>);
-  (SELECT ne.id FROM network_element ne +
-    WHERE (ne.network_identifier = 'n/a' +
-    OR ne.network_identifier IS NULL +
-    OR ne.network_identifier = '') +
-    AND ne.on_air +
-    AND ne.show_in_monitor +
-    AND ne_type != 'CUSTOMER-NETWORK' +
-    AND technology NOT IN ('NON_DAS', 'n/a') +
-    AND ne.parent_id != 3045 # orphan +
-    AND ne.date_added > '2022-12-01 00:00:00');+
 </code> </code>
  
Line 53: Line 44:
 JOIN network_element parent ON parent.id = network_element.parent_id JOIN network_element parent ON parent.id = network_element.parent_id
 SET network_element.network_identifier = parent.network_identifier SET network_element.network_identifier = parent.network_identifier
-WHERE parent_id in  +WHERE network_element.parent_id in (<NE_IDS>);
-  (SELECT ne.id FROM network_element ne +
-    WHERE (ne.network_identifier = 'n/a' +
-    OR ne.network_identifier IS NULL +
-    OR ne.network_identifier = '') +
-    AND ne.on_air +
-    AND ne.show_in_monitor +
-    AND ne_type != 'CUSTOMER-NETWORK' +
-    AND technology NOT IN ('NON_DAS', 'n/a') +
-    AND ne.parent_id != 3045 # orphan +
-    AND ne.date_added > '2022-12-01 00:00:00');+
 </code> </code>
  
 **Auto Clear:** When network identifiers are updated **Auto Clear:** When network identifiers are updated
resolution_area/prometheus_resolutions/res-p9124.1671723877.txt.gz · Last modified: 2022/12/22 15:44 by 10.91.110.100

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki