X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Faddn_req_time.gsql;fp=mc-core%2Fmc%2Fqueries%2Faddn_req_time.gsql;h=764642d9e761a8dcbeb24f2ef6724095d1d85df3;hb=9b604aeefe0126a54dccf312cb24c2649f221a4a;hp=a36420dc9ac81b84d699baafd7e42dec97115dd8;hpb=31d238a2cba18b87e05a7d9b4820db2c5186c658;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/addn_req_time.gsql b/mc-core/mc/queries/addn_req_time.gsql index a36420d..764642d 100644 --- a/mc-core/mc/queries/addn_req_time.gsql +++ b/mc-core/mc/queries/addn_req_time.gsql @@ -29,7 +29,9 @@ from add_req_start p1, add_req_success p2 ; -DEFINE{query_name 'addreq_success_time';} +DEFINE{query_name 'addreq_success_time'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } select eUE_ID, gnb_id, TB, UINT(max(end_time)-max(start_time)) as success_time @@ -38,7 +40,9 @@ group by eUE_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 'addreq_success_stats';} +DEFINE{query_name 'addreq_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,