Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

SetFilter , text field , but case insensitive

Posted on by 171

Greetings to all of you.

How can i use Setfiter , to filter the value of a text field , but with case insensitive?

It seems that typing like the one below does not work.

    TestRecord.SetFilter(Name,' @%1', TestText);
Name is field of the testrecord which is a dummy table and TestText is just a dummy test variable.
Thank you in advance.




  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: SetFilter , text field , but case insensitive

    Thank you for sharing.

  • AntonisK Profile Picture
    AntonisK 171 on at
    RE: SetFilter , text field , but case insensitive

    Found it on my own.

    In case anyone comes up with the same problem, the right Syntax is :

    TestRecord.SetFilter(Name,'%1','@' + TestText); ( if TestText is a variable , if its just plain text then you need single quotes , 'TestText).

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans