Add more values to filter when dropdown

(0) Share

Report

Posted on by Nikola Jovicic

Dear Community, I have question about filtering in web client. Our customer migrated from NAV 2009 classic to BC19 but in 2009 he could add more filters on this way:

When he choose first value for "No." and then types vertical bar (|), and choose another value from dropdown, the new chosen value is added to current filter. On this way he could add easy multiple values to the filter on every report.

But, in web client on BC19, the chosen value from Drop Down overrides current value in filter, so you cannot add filters on this way. I know that I can develop custom field on request page and develop custom code in OnLookup trigger, but I would like to find some better solution. I also tried with property on table field ValidateTableRelation = false, but it also didn't help.

Do anyone have experience with similar situation.

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Nikola Jovicic 5 on at

Like (0)

Report

RE: Add more values to filter when dropdown

Thanks to everyone, but I tried to find some solution that would be applicable on all the reports and fields.

I tried to search for global triggers in system codeunits to check if is there some trigger like GlobalOnLookup (similar to OnGlobalInsert in codeunit 49) but I didn't find anything useful.

The only thing that seemed to be useful was codeunit 2000000007 "Filter Helper Triggers", and I tried to make subscriber for triggers MakeCodeFilter and MakeTextFilter, but it didn't triggered when lookup on request page.
YUN ZHU 85,571 Super User 2025 Season 1 on at

Like (0)

Report

RE: Add more values to filter when dropdown

Hi, I think this can be done with TableRelation property.

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-tablerelation-property

For example,

My vendor list

In this dropdown

Hope this will help.

Thanks.

ZHU
Inge M. Bruvik 1,029 Moderator on at

Like (0)

Report

RE: Add more values to filter when dropdown

Maybe this is useful ?

www.youtube.com/watch
Suggested answer

MahGah 15,445 on at

Like (0)

Report

RE: Add more values to filter when dropdown

Hi

The only method that I know is to type the full value instead of selecting from drop down. But I agree that it will help if we could use the method you have described or at least use Ctrl to select multiple.