top of page

Why SETFILTER doesn’t work sometimes

Every AL-Developer uses “SETFILTER” on a daily basis. But did you know that there are certain situations where “SETFILTER” will refuse to work?


First let’s look at the syntax:

Rec.SETFILTER(<Field>, <Filter>, <Placeholders>);


Seems simple enough right?



This will work just fine. But what happens if we do the following?



The applied filter will look like this:



AL did not manage to replace the placeholders inside the filter string, because “*” and “@” are used.


To make this work, we must use “STRSUBSTNO”:



That way, we construct the filter-text by ourselves and pass it into the filter string of the SETFILTER function. The result will look like this:



267 Ansichten0 Kommentare

Aktuelle Beiträge

Alle ansehen

The Line Type Myth

Comments


bottom of page