Data Sources: Age at first occurrence plot is incorrect

[alondhe]

Expected behavior

The Age at first occurrence plot for drug era is incorrect plot should match what's in AchillesWeb

Actual behavior

It does not match.

In Atlas DS:

In AchillesWeb:

Steps to reproduce behavior

Process Achilles, view Drug Era report and go to Age at first occurrence plot.

[anthonysena]

Seems symptomatic of an error with the box-and-whisker in general as noted as also noted in #850

[chrisknoll]

It appears that it is attempting to draw a bunch of box and whisker plots on top of each other, if possible, could you get a look at the report json payload, and see if there's multiple entries for that distribution?

[fdefalco]

This is an issue with WebAPI.

Concept Id is missing from the where clause in the following files:

https://github.com/OHDSI/WebAPI/blob/master/src/main/resources/resources/cdmresults/sql/report/drugera/drilldown/ageAtFirstOccurrence.sql
https://github.com/OHDSI/WebAPI/blob/master/src/main/resources/resources/cdmresults/sql/report/drugera/drilldown/lengthOfEra.sql

The following where clause is necessary to limit to the drill down concept identifier:
WHERE c1.concept_id = @conceptId