You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In some of the export queries, they are ordering on stratum_1. In the cases where stratum_1 is an integer being cast as a varchar, this ordering is occurring incorrectly. This can be corrected by multiplying by 1.0 in the order statement.
In some of the export queries, they are ordering on stratum_1. In the cases where stratum_1 is an integer being cast as a varchar, this ordering is occurring incorrectly. This can be corrected by multiplying by 1.0 in the order statement.
Link to example: https://github.com/OHDSI/Achilles/blob/86741da9c8ad74a5be7785d7b9da24aacfa4c09e/inst/sql/sql_server/export/observationperiod/periodsperperson.sql#L1C1-L1C1
The text was updated successfully, but these errors were encountered: