Split long filter

Dynamics 365 Business Central/NAV Developers Forum
#1

Hello Every body,

I need to make filter a filter on the item table , the problems starts when the value of the filter getting more and more long , something like this

‘item1|item2|item3|item4…’

this filter is created based on some conditions, so no previous idea about the lenght .

is there any workaround to avoid issue related to the length of field on which we apply this filter?

Thanks for help

#2

Search the forums. This has been discussed hundreds of times. You can either mark your records, use a temp table, or probably even something else. Look at the function on the Item List form, too, that creates better filter strings that the a|b|c|d|e, which could be a…e

#3

or you can create a field like item category and distinguish these items…