How do I use filters to search a string with Double Quotes?

[GradDev]

I have a field in Processwire where I save JSON Data.

Something like this:

{"key1":"value1","key2":"value2"}

Now, I want to filter all the pages that have "key1":"value1".

I have tried escaping the double quotes with \ but did not work.

How do I go ahead with this?

Thanks!

Edited April 25, 2022 by horst
Typo: changed / to \

[horst]

Isn't the escape character this one: \ ?

[GradDev]

4 minutes ago, horst said:

Isn't the escape character this one: \ ?

Right. I used that one but did not work.

I corrected the question.

But now that I dig a little further, it does not seem to be the issue with double quote escaping. It seems to be the issue with the colon (:) character being surrounded by double quotes.
Now, I am trying something like following:

$pages->find("textarea_simple*=:\"value1\"")

And it returns the pages.

But this does not:

$pages->find("textarea_simple*=\":\"value1\"");

Do I need to escape the colon character as well? But simply escaping it with \: does not work.

[horst]

I never had the need to use raw text searching upon JSON objects. Looks a bit fragile to me. Have you thought about alternative storing strategies, other field types?

[Robin S]

The *= operator isn't the right one to use because it doesn't match partial strings at the start. If you use the %= operator I think it will work.