- make multiple database work locally using mysql 5.7 ✅ #enocpop

- establish mysql access ✅ #enocpop

- test using bind data with latest changes ✅ #enocpop

- implement the StackOverflow answer to sanitize the query for mysql ✅ #enocpop

1. siti excel bug ✅ #enocpop

- find old PO to experiment 1 hr on for new feature #enocpop

- add in pcode updates ✅ #enocpop

1. attend the followup session for [[work.icanstudy]] ✅ (already spent 1.3 hrs of 3 hrs allocated this week) 2. follow up on finance admin under [[recurring tasks|monthly.journal.2022.01#recurring-tasks]] ✅ 4. plan the list for revision for this week [[work.icanstudy.things-to-revise]] ✅ 5. solve the data issue regarding support and pcode for package E for pricebook ✅ 6. update [[mysql.levelup]] with the new LOCATE clause and REPLACE clause i learn today ✅ 7. expired 846 prices in VQP ✅ 8. draw a UI sketch for the replacement of person in project ✅

- update the middleman server just in case ✅ #enocpop

7. 🐛 Fix the quotation typo bug ✅ for #enocpop

- fix bugs found post-test ✅ #enocpop

#enocpop 🇸🇬📬 - reconnect back to cpop server SSH for both miguel laptop and mine ✅ - deploy new cpop code changes ✅ - solved the push to PDB in SG ✅ - solved the Siti manual quote request ✅

- find a short term solution for slow retrieval ✅ #enocpop

#enocpop 🇸🇬📬 - ⭐ 🧪 test the latest 2 changes for issue MTT-513 (2/6) => (4/6) for 1pm ✅

fix issue issue-167 #enocpop

- update new pricebook with support items ✅ #enocpop

#enocpop 🇸🇬📬 - 🐛 follow up on out of memory bug (9/15) ✅ - 👨🏻‍💻 tie up loose ends for CCB suppression (2/6) => (4/6) ✅

For #enocpop 1. follow up with Jacqueline abt search not working ✅

- swapped in new middleman server running 22.04 ubuntu ✅ #enocpop

- wbs to po number linker table ✅ #enocpop