Differences

This shows you the differences between two versions of the page.

--- start [2024/01/17 11:12] – admin
+++ start [2024/01/20 18:38] (current) – admin
@@ Line 312: / Line 312: @@
 Search is an array, and you need to find the unique text within the email that differentiates the institution from other communications originating from the From address.
-**AWARD VALUE DOCUMENTATION**
+**MONGO QUERIES FOR FIRM OFFERS**
+Query to find the offers for: VUT, UNIZULU, SPU, SMU, CUT, UFH
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 37,$or: [{ Subject: 'Application Admitted'},{ Subject: 'Application Offered'}]}
+Query for Wits:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 30, Attachments:"UW_AD_UGF0_N.pdf"}
+Query for UP:
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_A41.PDF/}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_AT4.PDF/}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_A39.PDF/}
+Query for UWC:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 31, Subject:/Offer to study at UWCCK Ref:/}
+Query for UJ:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 28, $or: [{ Subject: 'Univ. of Johannesburg - Orange Carpet Admitted'},{ Subject: 'University of Johannesburg - Admittance Letter'}]}
+Query for NWU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 14, Attachments:"PVA014.pdf"}
+Query for NWU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 14, Subject:/Final Acceptance/}
+Query for RU:
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 17, Attachments:"Offer Confirmed"}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 17, Attachments:/O1/}
+Query for UFS:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 21, $or: [{ Attachments: 'UV_ADMIT_COV.pdf'},{ Attachments: 'NAS_FINAL.pdf'}]}
+Query for UCT:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 19, Html:/OFFER/}
+Query for SU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 12, Subject:"ADMISSIONS COMMUNICATION FROM STELLENBOSCH UNIVERSITY", Attachments:/Offer_Letter_/}
+**In all the queries you'll need to amend the time and institutionId where applicable**