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

How to check if field contains more than one filter

(0) Share

Report

Posted on by greex

102

Hello. I have record and field. This field contains 1, 2, 3 or 4 location code filters. For example:

WHITE

WHITE|GREEN

WHITE|GREEN|RED

WHITE|GREEN|RED|BLUE

What is the most optimal (and simplest) way to check if number of location code filter is greater than 1?

I do this task in this way:

FilterTemp: Text

FilterTemp := Record.GetFilter("Location Code");

if FilterTemp.contains('|');

But im not sure that this is good way.

And how can I count number of Location Code filters in this example? I think I can count '|' in FilterTemp and result+1 will be correct answer. But maybe exists easier way?

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 72,895 Super User 2024 Season 2 on at

Like (0)

Report

How to check if field contains more than one filter

Sorry for the late confirmation, hope the following helps.

Dynamics 365 Business Central: How to check if there is only one value in the filter for a field (For example, check if number of G/L Account No. filter is greater than 1)

https://yzhums.com/32054/

Thanks.

ZHU
Suggested answer

YUN ZHU 72,895 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to check if field contains more than one filter

Hi, just adding some info.

If only '|' is considered, I think a bug will occur.

In fact we can also use "..." to filter the Location Code.

For example,

EAST..OWN LOG

Hope this helps as well.

Thanks.

ZHU
Suggested answer

DAnny3211 9,272 Super User 2024 Season 1 on at

Like (0)

Report

RE: How to check if field contains more than one filter

CIao

you can use the following function

learn.microsoft.com/.../text-split-list[text]-method

check my answer if it was helpful, thanks

DAniele