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

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

[vedfordev]

created feature request in avni-model
avniproject/avni-models#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