[{"_id":"639a60","status":"inactive","version":"0.1","configuration":{"identifier":"backfill-test","secondaryIdentifier":"platform_type","sql":"select * from test where lastupd_ts >= '2021-09-10 18:00:00' and lastupd_ts <= '2021-09-10 19:00:00'","steps":[{"service":"Publish","order":1,"configuration":{"topic":"platform-type","type":"PlatformType","action":"N","keyDeserializer":"serializers.Kafka","valueDeserializer":"serializers.Deserializer"}}]},"name":"data-exporter-svc"}]

db.collection.update({"configuration.identifier":"backfill-test"},[{"$set":{"configuration.sql":{"$replaceAll":{"input":"$configuration.sql","find":"lastupd_ts >= '2021-09-10 18:00:00' and lastupd_ts <= '2021-09-10 19:00:00'","replacement":"lastupd_ts >= '2024-00-10 18:00:00' and lastupd_ts <= '2024-00-10 19:00:00'"}}}}])