I am in need of restricting auto slot queries by values in sys_CheckBoxTree(s). However the JSR-170 query debugger page does not seem to display any values for the sys_CheckBoxTree data when I do something like:
select rx:sys_contentid , rx:treeD from rx:mdaDetail where rx:sys_contentid = ‘2307’
Do I have to install PSOToolkit and do a real SQL query to restrict an auto slot query or am I missing something here?
In fact I know it does, because I’ve implemented autoslots to find related pages based on commonly selected keywords in a check box tree, by building a JSR-170 query with a WHERE clause that concatenates checked values together as a long list of ORs. It is slow though - adding seconds to the assembly of each page.