Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

System View Filter Properties

Posted on by Microsoft Employee

How can I change filter properties of the fields in a view.

I want to achieve something like this

This field is an optionset

The below field is a lookup

2017_2D00_11_2D00_03_5F00_10_2D00_12_2D00_40.jpg

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    2017_2D00_11_2D00_03_5F00_15_2D00_08_2D00_31.jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    no this is not what I want. I am talking about the filters on the view. Don't want to export anything.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    Thanks. I managed to do it for fields where I can see this option "Filter by specific ...."

    There are few fields where I cannot see this option.

    Is there any way to do the same for those fields.

    2017_2D00_11_2D00_03_5F00_15_2D00_02_2D00_59.jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    Hi Snitika,

    I am assuming you are not having any reports.

    I would suggest you to export the particular view data to excel using export data to excel and in excel you can put the filter.

    As far as CRM is concerned I am not sure if you can achieve this, as the lookup data can be huge it's not feasible to show it as it is in the case of optionset.

    Hope this helped.

    Thanks

    Phanidhar

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    Hi,

    Yes select the "Filter by specific Region..." and then add all your possibilties and tada. Here you are with the same look as an opitonset

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    Field         Datatype

    Region     LOOKUPS

    Status      OPTIONSET

    logically lookup data is not visible same as optionsest

    Is, there any way to view the lookup data as optionset?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    Hi Snitika,

    If you are trying to put the filter over an optionset it will directly show you the options available in the optionset.

    If I am correct you are trying to filter it by region and I can see that the region is a lookup not an optionset.

    Please verify the field type once.

    Hope this helped.

    Thanks

    Phanidhar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    2017_2D00_11_2D00_03_5F00_10_2D00_11_2D00_58.jpg

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: System View Filter Properties

    I want to achieve something like this

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans