MongoDB $replaceAll not working

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’

As a workaround, consider:

  1. query MongoDB without using $replaceAll
  2. wrap Mongo output in a Query Results datasource in Redash
  3. manipulate the query results using SQL string manipulation functions (implemented in SQLite)
1 Like