web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

How to filter a View by owning user's BU and account for if the record is owned by a Team?

(0) ShareShare
ReportReport
Posted on by

This View Filter criteria works for User but I have records which could be owned by a User or a Team.  Is there a way to modify it so it would include an OR statement?

ViewFilter.png

*This post is locked for comments

I have the same question (0)
  • ashlega Profile Picture
    34,477 on at

    Hi Deb,

     see if you have "Owning Business Unit" under "Related entities" for that entity when creating a filter. It'll be set to the team BU or to the user BU, depending on who the owner is.

      For the filter, it'll be

      Related Entities-Owning Business Unit->Business Unit equals "Police" 

    PS. Not sure if you still need it considering that other question with the dashboards, but anyway.

  • Cyclefitness Profile Picture
    on at
    No Owning Business unit. Just Owning User and Owning Team.
  • ashlega Profile Picture
    34,477 on at

    It's not searchable it seems.. I've tried with a few custom entities - the field is there, but it's not searchable and CRM would not allow me to change that..

    Not sure then. You can't use "OR" for your original filter

    The only other option, it seems, would be to create a new BU lookup field and use a workflow to assign it (from the team or from the user owner) whenever a record is assigned/created. Or, still, just make it work off the security rather than off the filters

  • ashlega Profile Picture
    34,477 on at

    You might also try not equals condition instead.. it might be more difficult to maintain..

    Basically, if the team owner is not in any other bu, and use owner is not in any other bu(other than police), then it's a police business unit. But you will have to list all those bu-s, and you'll have to keep updating those views if/as you are changing the bu structure

    EDIT: Does not work that way. Just tested. Well, learning something..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans