Expand my Community achievements bar.

TextMode: way to filter a Report by Last Note Owners Home Group

Avatar

Level 3

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Level 2

Hey @Dusty_H 

 

Your textMode code looks right to me. 

 

To check, add a column that displays lastNote:owner:homeGroupID

 

I would use cine (case insensitive not equal) becasue youre' not providing a list but a single value)