I am trying to create an RSS feed that contains recently updated and newly created content items (of a certain content type). Of course there are many technical obstacles surrounding this issue. Leaving the other issues aside, there is one problem I can’t seem to find a solution to:
A handful of these content items exist in more than one folder of the site, by way of copy, then past as link. The following JSR-170 query is what I am using to find the content items:
SELECT rx:sys_contentid, rx:sys_folderid FROM rx:CLTTopic
When I run this in the Query debugger, I also add the rx:displaytitle, just to help me distinguish between them, but I can clearly see two content items, with the same title, same contentid, and different folders. I need to find a way to filter those items from the results, so I only get one instance of the content item.
Some ideas that I tried that didn’t work:
I tried to use SQL-like keywords such as distinct or group by. These did not work.
I tried to discover what fields are available by using describe, and show fields, these also failed.
doing a ‘select * from rx:CLTTopic’ shows me the fields available, but none of them seem to be related to the content item’s status as far as being a linked item rather than the real item.
So does anyone know how I can identify and remove those “linked” items, or how to group results by the contentid?