Offline dashboard report optimisation

[sachsk]

Optimise the offline report card To optimise queries please follow this document : https://avni.readme.io/docs/offline-reports#tips-for-writing-optimized-queries

• [x] Total Members
• [x] Total Students
• [x] Total enrolments
• [x] Total Interns
• [x] Total Alumni
• [x] Karigar Batches
• [x] Interested but not applied
• [x] Selected
• [x] Rejected
• [x] Applied
• [x] Dropped Out / Not Interested Anymore
• [x] Joined program
• [x] In process
• [x] Higher Technical Edcuation
• [x] Not contacted in this Month
• [x] Higher Education
• [x] Upskilling
• [x] Employed

[vedfordev]

created feature request in avni-model https://github.com/avniproject/avni-models/issues/50

[Dinesh2019]

Test execution video :

https://drive.google.com/drive/folders/1-hiA_zlReg4ZnTeVy-_2ej0Csw1EewpW

[vedfordev]

prod org bundle backupLend a Hand India.zip

[vedfordev]

Perfomance

Report Card	Old (ms)	New(ms)
Total Members	6	5
Total Students	8	1
Total enrolments	7	1
Total Interns	6	4
Total Alumni	16	4
Karigar Batches	10	5
Interested but not applied	207	11
Selected	190	5
Rejected	191	5
Applied	189	7
Dropped Out / Not Interested Anymore	191	8
Joined program	189	5
In process	191	6
Higher Technical Edcuation	48	11
Not contacted in this Month	11	5
Higher Education	48	11
Upskilling	31	4
Employed	35	5