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.

Sign In or Register to comment.