I'm trying to verify some data here with the sample database that OC kindly provided. particularly I'm looking at Discrepancy Notes. And if my understanding is correct, the three table of discrepancy_note, discrepancy_note_type and resolution_status would provide us with all the key info to us.
Here I'm looking into three things or from three angles. The data and sql queries that I construct to get on-demand data view, the existing data view such as Views that came with OC, and the OC web portal. And I'd like to see if they are all or largely consistent.
I'm a bit puzzled by the following finding.
-- run two sql queries
-- a) with the existing View about discrepancy notes
order by discrepancy_note_type_id;
3 of discrepancy_note_type_id 1 Failed Validation Check
1 of 2 Incomplete
2 of 3 Unclear/Unreadable
1 of 4 Annotation
7 Reason for Change
-- construct a straight-forward sql query to get discrepany notes, its type and status
select distinct dnt.name as note_type, dn.*
from discrepancy_note dn, discrepancy_note_type dnt
where dn.discrepancy_note_type_id = dnt.discrepancy_note_type_id
and dn.parent_dn_id is null
order by dn.discrepancy_note_type_id
Both returns identical results. However, the following baffles me.
According the sql queries,
discrepancy_note_id of 5 has data of 2 for discrepancy_note_type_id. According to the discrepany_note_type look up table, discrepancy_note_type_id of 2 is for "Incomplete" notes, but it seems the OC portal has it for "Annotation".
discrepancy_note_id of 9 has data of 3 for discrepancy_note_type_id. According to the discrepany_note_type look up table, discrepancy_note_type_id of 3 is for "Unclear/Unreadable" notes, but it seems the OC portal has it for "Query".
discrepancy_note_id of 11 has data of 4 for discrepancy_note_type_id. According to the discrepany_note_type look up table, discrepancy_note_type_id of 4 is for "Annotation" notes, but it seems the OC portal has it for "Annotation".
So, what are correct?
A note on the OC new forum, if you're using Chrome browser, the way to move from Discussion Title to [ Body ] area is to use the Tab key, attempt to use cursor directly won't work while it works fine with IE11