SETFILTER AL CODE for Wildcard search

(1) Share

Report

Posted on by Samantha73

3,124

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)

Verified answer

Alexander Drogin 262 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.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 19,072 Super User 2025 Season 2 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

Was this reply helpful? Yes No