179
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
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.
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.
thank you!
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 :-).
Share
Report
All responses (
Answers (
