Expected behavior

Querying for cohort definition list should not include columns (especially large columns) that are not required for the cohort definition list view.

Actual behavior

When querying the cohort definition list, the JPQL generated causes a inner join to CohortDefinitionDetails and pulls in the VARCHAR(MAX) column. This has negative performance impacts, and has even causes queries to hang on our EC2 sql server instances.

Steps to reproduce behavior

1. Open console log in WebAPI
2. Open a browser and access /WebAPI/cohortdefinition
3. you will see a Hibernate: debug message with the query. Notice that the cohort_definition_details table is joined, and the expression column is returned.