AMP-SCZ / dpdash

Deep phenotyping dashboard
Other
2 stars 1 forks source link

Weird name display in configurations table #721

Closed Elkrival closed 7 months ago

Elkrival commented 7 months ago

The created by column in the Configurations table displays many names and duplicates. This is because the join we were using in the query returns an array of values and not a single result.

In this pr we stream the data, and programmatically lookup the user that owns the configuration, we have to do this because document db does not support subqueries after a join operation. We were using a subquery to reduce that array of results into one object.

To speed things along, the users are cached.

Screenshot 2024-04-01 at 12 30 31 PM
JackVCurtis commented 7 months ago

Unfortunate that DocDB doesn't allow queries on the join, but good find!