I have a problem where an auto index is returning all revisions of a queried content type. Is there something wrong with my query?
Slot Query:
select rx:displaytitle, rx:answer from rx:eraufaqitem where jcr:path like :folderpath order by rx:displaytitle
This behavior is the result of using rx:displaytitle and rx:answer in your autoslot query. The query is meant to only pull back the item, not to return specific fields on the item. To get just the current revision of an item, select rx:sys_contentid and rx:sys_folderid in your autoslot query.
Once you’ve got the item you want and the correct revision, you can retrieve the data you want in your template using $sys.item.getProperty.