Hello! If we are trying to use our concept set in an SQL query that we have written and are using to manually query our database (i.e. not using the webAPI), should be copying our "Concept Identifier List" or our "Included Concept Identifier List" into our SQL query. For example:
Select patient_id From concept_occurrence where concept_id in (Concept Identifier List)
Select patient_id From concept_occurrence where concept_id in (Included Concept Identifier List)
My issue is arising because I tried to use "Included Concept Identifier List" but with 68K included concept IDs (I need to include all descendants in a medication list), the list is too long for SQL to process the text string.