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.