TextMode: way to filter a Report by Last Note Owners Home Group | Community
Skip to main content
Dusty_H
Dusty_H
Level 3
October 11, 2024
Solved

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

  • October 11, 2024
  • 2 replies
  • 1340 views

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

Best answer by skyehansen

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%20hops&sort=relevancy&f:@el_contenttype=[Community]&f:el_product=[Workfront]

 

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=______________

2 replies

Sven-atClient
Sven-atClient
Level 3
October 11, 2024

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
    Dusty_HAuthor
    Level 3
    October 11, 2024

    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
    Community Advisor
    skyehansenCommunity AdvisorAccepted solution
    October 11, 2024

    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%20hops&sort=relevancy&f:@el_contenttype=[Community]&f:el_product=[Workfront]

     

    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
      Sven-atClient
      Level 3
      October 11, 2024

      @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
        Terms & ConditionsAccessibility statement

        Loading footer...