Closed LKShankarKarthik closed 1 week ago
@LKShankarKarthik - The sort capability with Cosmos DB is supported on when the above config is updated prior to creating he database. After the data base is created, updating the config would not enable the sort capability on search parameters added.
@EXPEkesheth - Thanks for the update. Is there a way to check when it was added? As I remember, we updated the config before we loaded the data (or as part of initial deployment).
Hi @LKShankarKarthik, yes, this config only applies when it initializes the collection. We only invested minimally in sort support for Cosmos since we had much richer support for free in SQL.
As such, there isn't a UI or API for this, I'd advise its not something we're looking to expand or support beyond what's currently there. Internally, you can update the status in the DB to "Supported", restart the service, then follow the $reindex guidance which should populate the sortable index and enable it. This only works on strings and dates.
Closing with no response and question is answered
Describe the bug We have hosted this OSS in Azure App Service with appropriate configuration change to support _sort on below resources (clinical date columns). But its not behaving as expected (seems to work intermittently)
FHIR Version R4
Data provider CosmosDB
To Reproduce Steps to reproduce the behavior:
Expected behavior FHIR Response shouldnt have the above warning and it should return results.
Actual behavior Returns HTTP 200 Bundle Response, but with OperationOutcome (Warning)