Hi Edward, I looked into it and SQL cant do the nested array of dictionaries I mentioned earlier
But I sketched a diagram of a 2 table solution, where TableA holds the client's pii's along with your internal uid for them which would map to Table B containing all cases and their is_open boolean flag
Thank you @Josh Josue That makes sense to me ! I appreciate you taking the time to share this with me including your github repo for the logger as well !
I shall see how I can implement this on Monday and/or make it part of processes that similar to this :catroombaexceptionally_fast:
Np man, glad to help 🤓
i mightbe gone by then but u left it on my desk
Oh okay I shall pick it up when no one is looking then :eyes_3d: