web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... SETFILTER AL CODE for ...

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

Answered

SETFILTER AL CODE for Wildcard search

(1) Share

Report

Report

Posted on by Samantha73

3,297

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 Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,926 Super User 2026 Season 1

#2

YUN ZHU 1,158 Super User 2026 Season 1

#3

Khushbu Rajvi. 533 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans