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

[Dusty_H]

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

[Sven-atClient]

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)

[Dusty_H]

yeah.. i've tried a few ways and i still can't get it to work.

when i use it in the filter i receive this error

I have been successful in creating a column in the report with the data.  but can't seem to get this to work in the filter.

I have tried both 

lastNote:owner:homeGroupID     and 

lastNote:owner:homeGroup:name

I've tried notin and cine. 

everytime i get the error.
any other ideas?

[skyehansen · Accepted solution]

I don't know if you've read up on "too many hops" but you would probably want to try and use an exists filter for this.

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=too%20many%20hop...]

No promises, but the below code may (or may not) work for you.

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=NOTE
EXISTS:a:ID=FIELD:lastNoteID
EXISTS:a:owner:homeGroupID=______________

[Sven-atClient]

@Dusty_H 

@skyehansen called it. even though this is not more than 4 hops the filter won't work. 

Use her code - it works  

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=NOTE
EXISTS:a:ID=FIELD:lastNoteID
EXISTS:a:owner:homeGroupID=584eb575000bd72994a1add416e3d90f

[Dusty_H]

Thanks so much!  that worked perfectly!