Microsoft Dynamics NAV (Archived)

Multiselection in advanced filter

(0) Share

Report

Posted on by Jaime Figueras

175

Hi, there is any way to select several rows in an advanced filter? Instead of writing manually the caracter '|'

Or if it is impossible, some idea do it? Thanks!

*This post is locked for comments

All responses (6)

Answers (3)

Suggested answer

TharangaC 23,116 on at

Like (0)

Report

RE: Multiselection in advanced filter

There is no other way of doing it in Dynamics NAV. However if you have plenty of filters to apply you can use the support of excel to build your filter parameter.
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: Multiselection in advanced filter

Hi Jaime,

I have written two blog articles regarding the concatenation of strings, which in this case, I think it may help you.

Let me know if it works for you.

Link 1: https://goo.gl/yDEKaS

Link 2: https://goo.gl/XRNPAJ

Please let us know if it helps you.
Jaime Figueras 175 on at

Like (0)

Report

RE: Multiselection in advanced filter

thank you!
Verified answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Multiselection in advanced filter

There is no standard option, but you can enhance the creation of that filter using Excel if you have numerous values to add (e.g., more that 10): copypaste the list of your items to Excel, select needed, then copypaste to the Excel using "transpose" property (that's how you get a line of values instead of columns), then copypaste it to Notepad and replace separators with "|". That's how you will get ready filter value :-).
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Multiselection in advanced filter

Hi,

At the moment, there's no such feature.
Verified answer

Rashed 3,765 on at

Like (0)

Report

RE: Multiselection in advanced filter

It's not possible, but you can ask MS this as a feature on Microsoft connect.