I'm looking into a requirement for a Discussion dashlet that lists
-Your topics (started by you) that has replies
-Topics you are involved in, ie you have replied to something and you want to monitor the discussion
-It should list discussions from all sites you are a member of so that you quickly can follow discussions across sites.
The site activites dashlet was thought to be to light weight as it cannot filter only replies to your topics, and is mixed with all other site activities.
This to mee looked like a trivial task at first, but the way the forum model is designed I cannot really find a way to do this. What I want to do is a Lucene search for the above. What we have is
- fm:topic with child nodes fm
ost in a flat structure
- the topic title is not stored in fm:topic, instead in the first child fmost
- fmost replies to another fmost is not a child, instead an association cm:references
- fm:topic and fmost is not only used in discussions, but also for comments in general in the system
So how would I search for "My topics with recent replies". fm:topic does not change modified time when a fmost is added. Maybe search all my fm:topic, then loop them? Another approach is to find all fmost created by me that has title not null. Then I get all my topic start, but then what, I cannot get the replies easily. Associations are not searchable, else I could have done a search for cm:references for the replies.
Also the fact that the same kind of fm:topic and fmost are used generally in the system, not only for Discussions, it would require PATH filtering, but when you are members of many sites, I guess the PATH filter will become to much for lucene.
Is there a way to do lucene query for what I want?
Maybe with queries, where the result of these queries is fed into new queries. But I'm afraid this would be to slow once the number of discussions spread across site rise, this is for a dashlet, and the loading should be prompt.
-Your topics (started by you) that has replies
-Topics you are involved in, ie you have replied to something and you want to monitor the discussion
-It should list discussions from all sites you are a member of so that you quickly can follow discussions across sites.
The site activites dashlet was thought to be to light weight as it cannot filter only replies to your topics, and is mixed with all other site activities.
This to mee looked like a trivial task at first, but the way the forum model is designed I cannot really find a way to do this. What I want to do is a Lucene search for the above. What we have is
- fm:topic with child nodes fm
ost in a flat structure- the topic title is not stored in fm:topic, instead in the first child fm
ost- fm
ost replies to another fmost is not a child, instead an association cm:references- fm:topic and fm
ost is not only used in discussions, but also for comments in general in the systemSo how would I search for "My topics with recent replies". fm:topic does not change modified time when a fm
ost is added. Maybe search all my fm:topic, then loop them? Another approach is to find all fmost created by me that has title not null. Then I get all my topic start, but then what, I cannot get the replies easily. Associations are not searchable, else I could have done a search for cm:references for the replies.Also the fact that the same kind of fm:topic and fm
ost are used generally in the system, not only for Discussions, it would require PATH filtering, but when you are members of many sites, I guess the PATH filter will become to much for lucene.Is there a way to do lucene query for what I want?
Maybe with queries, where the result of these queries is fed into new queries. But I'm afraid this would be to slow once the number of discussions spread across site rise, this is for a dashlet, and the loading should be prompt.
