News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to set a filter wi...

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

Unanswered

How to set a filter with a value containing "&" in Business Central?

(1) Share

Report

Report

Posted on by Shraddha Jadav

6

Hi everyone,

I'm working with Microsoft Dynamics 365 Business Central and I need to set a filter on the industry field where the value is "Oil & Gas" (as a single string). However, when I try to set the filter, Business Central interprets "Oil" and "Gas" as two separate values because of the special character & and I get the following error:

"The filter 'Oil & Gas' is not valid for the Industry field on the Customer table. 'Oil' is not an option."

Here is what I'm trying to do:

xValueString := jtoken.AsValue().AsText(); //here xValueString := 'Oil & Gas';

Customer.SetFilter(industry, Format(xValueString));

But it seems like it splits the value into two parts: "Oil" and "Gas", rather than considering them as one value.

Is there a way to properly set this filter so that "Oil & Gas" is treated as a single value, without splitting on the & character?

Any help would be appreciated!

Thanks in advance.

Categories:

Dynamics 365 Business Central

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,387 Super User 2024 Season 2

#2

Martin Dráb 230,432 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans