X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Frelease_req_time.gsql;h=38c3ffd294051963693eca74205c6d34e448b587;hb=c82aceb49b50fc5a94582360ed0e7ebbe10fa809;hp=91e4b5342aae1dafbfbfc19f6502dbdac4a9bd21;hpb=31d238a2cba18b87e05a7d9b4820db2c5186c658;p=ric-app%2Fmc.git

diff --git a/mc-core/mc/queries/release_req_time.gsql b/mc-core/mc/queries/release_req_time.gsql
index 91e4b53..38c3ffd 100644
--- 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,
@@ -8,10 +10,12 @@ select timestamp_ms as timestamp,
 	gnb_id,
 	0 as event_type
 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';
+	comment 'statistics on the time to delease a DC connection';
+}
 PARAM{ window uint; }
 select timestamp_ms as timestamp,
 	0ULL as start_time,
@@ -21,17 +25,20 @@ select timestamp_ms as timestamp,
 	gnb_id,
 	1 as event_type
 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 +47,10 @@ 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';
+	comment 'statistics on the time to delease a DC connection';
+}
 PARAM{ window uint; }
 select gnb_id as GNB_ID,
 	($window*(TB+1))/1000 as TS,