Query Nested Data Structure
Query Nested Data Structure
Comments
-
Hi! I have a Case Data Structure which contains another Simple Data Structure (list) called Crossref (screenshot included)- what is the most efficient way to access all the Crossref IDs associated with all cases? Im using a loop now and it takes a while. Thanks!
-
I figured this out - Decisions added a column to the Crossref table that indicates which Case ID the row goes with - so it can be joined in SQL.