Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Filter by Item Attribu...
Microsoft Dynamics NAV (Archived)

Filter by Item Attributes ends in <>* when filtered using more than 2 attribute criteria.

(0) ShareShare
ReportReport
Posted on by Nareshwar Raju Vane... 5,596

Hi all,

Hope you all doing good.

We are using NAV 2017 - CU3 - UK. 

The problem we encounter is when we use "Filter By Item Attributes" on the Item List Page and when we input more than two filters, the final filter ends with <>*. Check screenshot.

I checked the Codeunit 7500, Function: GetItemNoFilterText(), and it is EXIT-ing the <>* filter even though we have matches, but it works fine if filtered with 2 or lesser attributes.

Can anyone confirm me as it is a bug or we have a workaround for this issue?

Thanks in advance.

68747A3C.PNG

*This post is locked for comments

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Filter by Item Attributes ends in <>* when filtered using more than 2 attribute criteria.

    I do not think it is a bug. I think it is a method of showing there is nothing filtered out (our developer Andrey Baludin gave me a good hint). If you would check your filters, this would mean that the list of items for one criteria most likely does not intersect with the list of the items for the other criteria. That is, if the result of the filtering is empty, "<>*" is substituted to show there is nothing to select... Tried with my version and it works fine.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: Filter by Item Attributes ends in <>* when filtered using more than 2 attribute criteria.

    Hi there,

    this is definitely a bug. Can't give you a workaround immediately - I have no NAV2017 repository here, and the code in CU7500 is giving me headaches. I would assume that presetting the return value of FindItemsByAttribute() with '<>*' is not the best of ideas. After setting it, every EXIT returns this value, regardless if it's a good idea or not.

    with best regards

    Jens

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans