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

SetFilter , text field , but case insensitive

(0) Share

Report

Posted on by AntonisK

260

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.

I have the same question (0)

All responses (2)

Answers (0)

AntonisK 260 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Thank you for sharing.

Was this reply helpful? Yes No