Provide an escape character so that single and double quotes can exist in a value simultaneously.

Question

Provide an escape character so that single and double quotes can exist in a value simultaneously.

RutledgePaulV opened this issue 9 years ago · 4 comments

Currently there doesn't seem to be a way to specify a query value that contains both a single quote and a double quote. If it contains a single quote, you can wrap the value in double quotes. If it contains a double quote, you can wrap it in single quotes. If it contains both, I don't know how to make it work!

Answer 1 · 2015-10-21T18:15:45.000Z

@jirutka any update on allowing values to be escaped in this manner?

Answer 2 · 2015-11-16T17:05:14.000Z

@jirutka any update here?

Answer 3 · 2016-02-06T23:18:26.000Z

Sorry for very long delay. I’ve just released 2.1.0 with updated grammar that supports escape character inside a quoted argument:

If you need to use both single and double quotes inside a quoted argument, then you must escape one of them using \ (backslash). If you want to use \ literally, then double it as \\. Backslash has a special meaning only inside a quoted argument, not in unquoted argument.

Answer 4 · 2020-02-25T16:22:16.000Z

@jirutka can you please help me here.
Mongo query :
{ field: { $mod: [ divisor, remainder ] } } How can we convert this to RSQL

Thanks,
Rambabu