345
I'm perplexed as to why PJNOTES places four potential join fields into one key_value.
Do I have to parse the keyvalue to do lookups on other tables?
I'm mainly interested in getting the user, hours (both embedded in key_value) and notes(in PJNOTES.notes1) for each project. Why didn't they just add project id as a field, date as a field I could perform joins on?
Or am I supposed to be using a different field in that table to do such lookups?
*This post is locked for comments
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (