@pdwalker please report it in Loading... . It’s a regression caused by Loading... . It affects 13.5-rc-1 and 13.4.1. Mark it as Blocker.
I checked the live table results URL by adding &sql=1
http://localhost:8080/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=plain&transprefix=demo.livetable.&classname=Demo.Code.DemoClass&collist=doc.title%2Cdoc.location%2Cdoc.date%2Cdoc.author%2CshortText1&queryFilters=currentlanguage%2Chidden&offset=1&limit=15&reqNo=5&shortText1=u&sort=doc.title&dir=asc&sql=1
and it seems the query is properly generated:
, BaseObject as obj , StringProperty as prop_shortText1 where obj.name=doc.fullName and obj.className = :className and doc.fullName not in (:classTemplate1, :classTemplate2) and obj.id = prop_shortText1.id.id and prop_shortText1.id.name = :prop_shortText1_id_name and (upper(prop_shortText1.value) like upper(:prop_shortText1_value_1)) order by lower(doc.title) asc, doc.title asc
especially the:
upper(prop_shortText1.value) like upper(:prop_shortText1_value_1)
The problem is the value of the :prop_shortText1_value_1 parameter which is exactly the typed filter value, e.g. “u” instead of “%u%”. I commented on XWIKI-18661: Impossible to filter panel type or category with empty v… · xwiki/xwiki-platform@a5469d5 · GitHub .