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

SetFilter , text field , but case insensitive

(0) Share

Report

Posted on by AntonisK

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.

All responses (2)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: SetFilter , text field , but case insensitive

Thank you for sharing.
AntonisK 171 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).