Concatenation of strings to use as filters in Dynamics NAV Reporting

I have been trying to get all the Item no. in the RFQ Lines (Request For Quotes Lines) as in one string concatenating all with a pipeline(‘|’).

Let me just jump into the code how did I perform this filtration.

Variable “Filter” will concatenate all Items within the filter. Check out the screenshot.

This concept is inspired by Codeunit 41, TextManagement.

In the Codeunit, please refer to the AddToFilter() method which concats the strings.


Edit on 09th Feb 2016, I have written a Round 2 of how to generalize the string concatenation. Please check here.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.