We have a support system in which one user can request help or insight from another user by selecting that user from a dropdown list, which is an additional field in each comment. I am attempting to create a view which will display only those comments which have both:
- requested the authenticated user's attention
- have not been responded to by the authenticated user.
In essence, I want to create a view of comments which haven't been replied to by the authenticated user. (The first filter is simple and I already have working.)
The problem I'm encountering is, although Views has a Parent-Comment Relationship, it has no Child-Comment Relationship. So I can use that relationship to either gain access to comments who have or do not have parent comments, I can not use this to determine if the comment itself is a parent (that I know of).