MongoDB $replaceAll not working

Support Usage Support
1

Hi
I tried to run the query where I want to replace some string of a column while selecting the records in Redash.
It’s giving Error running query: Unrecognized expression '$replaceAll’

2

As a workaround, consider:

  1. query MongoDB without using $replaceAll
  2. wrap Mongo output in a Query Results datasource in Redash https://redash.io/help/user-guide/querying/query-results-data-source
  3. manipulate the query results using SQL string manipulation functions (implemented in SQLite)
1 Like