SETFILTER AL CODE for Wildcard search

(1) Share

Report

Posted on by Samantha73

3,247

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

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Alexander Drogin 262 on at

Like (0)

Report

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.

Was this reply helpful? Yes No