Support #13589
[SCP ID :##6753##] : SQL Query for Statistical Report (BVMC report)
Status: | Closed - End of life cycle | Start date: | August 05, 2023 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | General | Spent 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.