Details
-
Improvement
-
Resolution: Won't Fix
-
Neutral
-
None
-
None
-
None
-
None
Description
info.magnolia.ui.workbench.container.AbstractJcrContainer#findSearchableNodeTypes takes all node types into account, making the query unnecessary complicated:
select * from [nt:base] as t where (([jcr:primaryType] = 'mgnl:marketing-tag' or [jcr:primaryType] = 'mgnl:role' or [jcr:primaryType] = 'mgnl:rssAggregator' or [jcr:primaryType] = 'mgnl:contact' or [jcr:primaryType] = 'mgnl:systemMessage' or [jcr:primaryType] = 'mgnl:segment' or [jcr:primaryType] = 'mgnl:tag' or [jcr:primaryType] = 'mgnl:user' or [jcr:primaryType] = 'mgnl:componentVariants' or [jcr:primaryType] = 'mgnl:siteMap' or [jcr:primaryType] = 'mgnl:page' or [jcr:primaryType] = 'mgnl:category' or [jcr:primaryType] = 'mgnl:group' or [jcr:primaryType] = 'mgnl:persona' or [jcr:primaryType] = 'mgnl:variants' or [jcr:primaryType] = 'mgnl:content' or [jcr:primaryType] = 'mgnl:item' or [jcr:primaryType] = 'mgnl:folder') and (lower(localname()) LIKE 'tes%' or t.['tes'] IS NOT NULL or contains(t.*, 'tes')) )
Checklists
Acceptance criteria