Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
11.0.3
-
None
-
PostgreSQL
-
Unknown
-
Description
Steps to reproduce
- Create a livetable with the "doc.content" column as filterable, with partial match:
'doc.content': {"filterable":true, "match": "partial"}
- Add some extra parameters for filtering out only pages whose content matches a given string, for example: 'extraParams':
'&doc.content=loremipsum'
- Make sure that at least one of the expected livetable entries has some content containing the entered string.
- Display the corresponding livetable.
Expected behaviour
- The filtered livetable should contain at least one page: the one containing the string declared in the extra parameters.
Actual behaviour
- When the first extra parameter string occurrence has an index higher than 256 in the page content, no match is found.
Comment
- The behaviour occurs at least with PostgreSQL. It seems to be due to the fact the the str SQL function used in macro livetable_addColumnToQuery will return at most 256 characters.