News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... SetFilter , text field...

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

Suggested answer

SetFilter , text field , but case insensitive

(0) Share

Report

Report

Posted on by AntonisK

175

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: SetFilter , text field , but case insensitive

Thank you for sharing.
AntonisK 175 on at

Like (3)

Report

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).

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans