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

(2) Share

Report

Posted on by Shraddha Jadav

111

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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

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

Like (3)

Report

Try with this:

xValueString := 'Oil & Gas';
Customer.SetFilter(industry, '"%1"', xValueString);

Was this reply helpful? Yes No
Shraddha Jadav 111 on at

Like (1)

Report

@Khushbu Rajvi.
xValueString contains a dynamic value. Even if we directly assign the value 'Oil & Gas', it is still treated as a string. However, it splits the value into 'Oil' and 'Gas', resulting in the same error.

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report

Have you tried "Oil & Gas"?
The 'Oil & Gas' value is enclosed in ' ', and I think it should work.

give it a try and see if it helps.

Was this reply helpful? Yes No