Support #13589

[SCP ID :##6753##] : SQL Query for Statistical Report (BVMC report)

Added by Zahir Abd Latif about 1 year ago. Updated about 1 year ago.

Status:Closed - End of life cycleStart date:August 05, 2023
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:GeneralSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:-

Request to have SQL query for Statistical Report (BVMC report). For all column

History

#1 Updated by Zahir Abd Latif about 1 year ago

  • Status changed from New - Begin Life Cycle to Pending Customer Feedback
  • Assignee changed from Hafizudin MD to Zahir Abd Latif
  • % Done changed from 0 to 100

Hafiz, Aug 7, 2023:-

As per our conversation. SQL query for Statistical Report (company only).

1) RegisteredCompany

select count(RIM_NO) as count from BIB_COMPANY;

2) ActiveCompany
select count(RIM_NO) as count from  ( select distinct(RIM_NO) from ( select USER_ID , RIM_NO from BIB_USER where RIM_NO in ( select RIM_NO from BIB_COMPANY )  and  trunc( U_DATE_LAST_LOGIN )  >=  to_date('29/04/2023', 'dd/MM/yyyy')))

3)Dormant Company
select count(RIM_NO) as count from  ( select distinct(RIM_NO) from ( select USER_ID , RIM_NO from BIB_USER where RIM_NO in ( select RIM_NO from BIB_COMPANY )  and  trunc( U_DATE_LAST_LOGIN )  <=  to_date('29/04/2023', 'dd/MM/yyyy')))

** DormantPeriod = -180 day. Please change yellow label as per DormantPeriod

#2 Updated by Zahir Abd Latif about 1 year ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle

Issue closed in SCP.

Also available in: Atom PDF