web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

How to allow multiple values for table fields

(0) ShareShare
ReportReport
Posted on by 433

Hi All,

I want to select multiple values for a field separated by commas . How to achieve this.

for example:

2016_2D00_07_2D00_27_5F00_7_2D00_58_2D00_34.png

instead of '|'(OR) i need ','(Comma). 

Thank you

Mahesh U

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alexander Ermakov Profile Picture
    28,096 on at

    I can understand some user's are making various inquiries on how to "improve" the user interface, however generally it is better to force users to use what standard functionality offers. E.g., use "|" and insist that this is how the system works. Show them manual:

    msdn.microsoft.com/.../hh879066(v=nav.90).aspx

    It would save unneeded work now and much more later during upgrades. Tell users also that if they would be bounded to very customized user interface, it will reduce their value on the market in comparison to the users who know the standard UI.

  • Mahesh U Profile Picture
    433 on at

    Thank you Experts,

    Actually i dont need that filter in Report processing i need that in a page. for better understand  i have shown from report.

    Now i have written a code in page onlookup and finally got the solution.

    Once again thanks for your help.

    Thank You 

    Mahesh

  • Suggested answer
    Amol Salvi Profile Picture
    18,698 on at

    Using '|' is standard way to filter the records and are you planing to change that in report processing ?

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    23,118 on at

    As Jonathan said you can achieve this by small modification, but before doing that can you update us on what you planning to achieve doing this?

  • Suggested answer
    Suresh Kulla Profile Picture
    50,251 Super User 2025 Season 2 on at

    Do you want to use , instead of | and then use that as filter on the field ? if you could let us know what are you planning to achieve we may provide you better solution.

  • Suggested answer
    keoma Profile Picture
    32,729 on at

    With filterstr:=getfilter (field) you get the Filter value. Replace then the , with | using convertstr. Then use setfilter to Set the correct filter.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans