Matrix Version: 188.8.131.52
Having an issue with filtering of a JSON data source. Spaces in a filter parameters value are causing some unexpected results.
I have a JSON data source whose results are displayed on a page using an asset listing. I then use a form to pass user entered data via get variables to Dynamic inputs and then use record filtering to allow searching of the data source.
As soon as I enter a search value with a space however the search fails to produce the correct results. Below are a couple of examples of the issue and the results
1st example case
Searching for an ‘Address’ of ‘38’ works, searching for an address of ‘Patterson’ works, but searching for ‘38 Patterson’ returns only the records whose address is empty (somehow matching the space to the empty value or something?).
2nd example case
Searching for a ‘District’ of ‘Canberra’ works, Searching for a ‘District’ of ‘Central’ works but searching for a ‘District’ of ‘Canberra Central’ returns zero.
In both cases, in the URL get parameter, Squiz seems to replace the space with a ‘+’ symbol. So for the second example above the URL ends up as http://www…?district=Canberra+Central.
Tried manually replacing the ‘+’ in the URL with the URL character code for a space, %20, but this fails to produce the expected result as well.
Is this a known issue and if so is there a work around?
Otherwise any suggestions on what may be causing this issue?