Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

custom view - same criteria field to include all variables

Posted on by Microsoft Employee

I need to create a new custom views. The criteria is based on a text field name.

How can i query / create a new view for the same text field where i need multiple criteria.

IE -Criteria: "field name" ends with 00;01;02;03;04;05;06;07;08;09;10

The ";" does not seem to work. I tried "," as well.

I did not want to have to use the "AND" logic as I fear i will run out of rows for the # of criteria's

IE - "the field: end with   00 ....... to 99 

Any suggestions? 

*This post is locked for comments

  • Suggested answer
    Ivan Ficko Profile Picture
    Ivan Ficko 1,380 on at
    RE: custom view - same criteria field to include all variables

    There is a limit in fetchXML, but it's huge like 2000+ criterias.

    To be exact it's 2097 refering to this article: blog.halan.se/.../CRM-Fetch-XML-Size-Limit.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: custom view - same criteria field to include all variables

    Thanks. Do you know how many rows (criterias) I can add to a custom view? Is there a limit?

  • Suggested answer
    Ivan Ficko Profile Picture
    Ivan Ficko 1,380 on at
    RE: custom view - same criteria field to include all variables

    There is no other way to create view other than chain your filters with AND operator, but you can make plugin on RetrieveMultiple on pre-operation where you can filter the dataset that you want in C# code where you can achieve this, but than you will not have paging/sorting available when you present that dataset in a view.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

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