Adding additional KPIs, adding required documentation

[ric-app/mc.git] / mc-core / mc / queries / release_req_time.gsql

diff --git a/mc-core/mc/queries/release_req_time.gsql b/mc-core/mc/queries/release_req_time.gsql
index 91e4b53..9b4c64d 100644 (file)
--- a/mc-core/mc/queries/release_req_time.gsql
+++ b/mc-core/mc/queries/release_req_time.gsql
@@ -1,4 +1,6 @@
-DEFINE{query_name 'release_req_start';}
+DEFINE{query_name 'release_req_start';
+       max_lfta_disorder '1'; max_hfta_disorder '1';
+}
 PARAM{ window uint; }
 select timestamp_ms as timestamp,
        non_temporal(timestamp_ms) as start_time,
@@ -11,7 +13,9 @@ from RELREQ.release_req
 where schemaId=801
 ;
 
-DEFINE{query_name 'release_req_success';}
+DEFINE{query_name 'release_req_success';
+       max_lfta_disorder '1'; max_hfta_disorder '1';
+}
 PARAM{ window uint; }
 select timestamp_ms as timestamp,
        0ULL as start_time,
@@ -24,14 +28,18 @@ from CONRELEASE.dc_release
 where schemaId=201
 ;
 
-DEFINE{query_name 'release_req_events';}
+DEFINE{query_name 'release_req_events';
+       max_lfta_disorder '1'; max_hfta_disorder '1';
+}
 PARAM{ window uint; }
 merge p1.timestamp : p2.timestamp
 from release_req_start p1, release_req_success p2
 ;
 
 
-DEFINE{query_name 'release_req_success_time';}
+DEFINE{query_name 'release_req_success_time';
+       max_lfta_disorder '1'; max_hfta_disorder '1';
+}
 PARAM{ window uint; }
 select gUE_ID, gnb_id, TB,
        UINT(max(end_time)-max(start_time)) as success_time
@@ -40,7 +48,9 @@ group by gUE_ID, gnb_id, timestamp / $window as TB
 having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
 ;
 
-DEFINE{query_name 'release_req_success_stats';}
+DEFINE{query_name 'release_req_success_stats';
+       max_lfta_disorder '1'; max_hfta_disorder '1';
+}
 PARAM{ window uint; }
 select gnb_id as GNB_ID,
        ($window*(TB+1))/1000 as TS,