SETFILTER AL CODE for Wildcard search

(2) Share

Report

Posted on by Samantha73

2,532

Hi All

I'm trying use setfilter with wild card so for example I want to filer any records where description contains words CUSTOMER anywhere in the description

JobQueueEntry.SetFilter(Description,'%1','*CUSTOMER*")

Cannot get it work.

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (1)

Verified answer

Alexander Drogin 249 on at

Like (0)

Report

SETFILTER AL CODE for Wildcard search

And what does not work for you? Assuming that the double quote after the filter value is a typo and it's actually a single quote, this should work.
Suggested answer

Khushbu Rajvi. 7,396 Super User 2025 Season 1 on at

Like (1)

Report

SETFILTER AL CODE for Wildcard search

Try this: JobQueueEntry.SetFilter("Description", '%CUSTOMER%');

Hope this helps: https://github.com/microsoft/AL/issues/7283

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-criteria-filters