I have a Projects report that shows the last made comment on a Project.
I would like to show only comments that were NOT made by one specific group of people, SUPPORT.
The report is set up to show comments if the notes is not blank and if the project was updated last by not SUPPORT.
But this may still result in showing comments made by SUPPORT, if the SUPPORT group left the last comment and then the owner loads a document but does not leave a comment.
**Keeping this as a project report allows the Support users to "resolve" the comment by making the next update to the Project essentially clearing the comment from the report.
I was using text mode to try to get at
Last Note - Owner Home Group ID - does not equal - SUPPORT
I just can't determine what that string would be. This is what i have tried with no luck
lastNote:owner:homeGroupID=584eb575000bd72994a1add416e3d90f
lastNote:owner:homeGroupID_Mod=notin