Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / how lookup data will d...
Microsoft Dynamics NAV (Archived)

how lookup data will display in advance filter why not in normal field in page?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

i have an small issue when i filter in page with advance filter it like as in customer list page as 10000|20000| here when i given or symbol customer data will show up on lookup.

same as when i create a one text variable and i given table relation for this variable but here also i given same filter 10000|20000| but here problem is when i given OR symbol data will not show up on look up mode.

why it behaving like this please suggest any thing..

Thank you

Ramesh

-- 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: how lookup data will display in advance filter why not in normal field in page?

    Hi Tina,

    I know filtering in navision my issue was when i search by advance filter in customer list in this NO. field 10000|20000| Then lookup is showing means dropdown showing all customer no's and i will select 30000.

    But same as thing i will use in field level means i create a variable codeG with table relation Customer."No."but here when i type 10000| then field lookup is there but nothing will display. how advance filter will work like that is there any property for that.

    Thank you

    Ramesh

    --

  • Tina Menezes Profile Picture
    Tina Menezes 2,582 on at
    RE: how lookup data will display in advance filter why not in normal field in page?

    Hi the criteria 10000|20000 in filter means OR expression and are numbers with 10000 or 20000. You can refer below link:

    [View:https://msdn.microsoft.com/en-us/library/hh879066(v=nav.90).aspx]

    To setfilter on a page follow the below:

    Rec.SETFILTER("No.", '100..200|300');

    //   This filter selects all records in the range from 100 to 200 and

    //   and No. 300.

    Check the following link

    [View:https://msdn.microsoft.com/en-us/library/dd354919(v=nav.70).aspx]

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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans