Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to make the filter option available

(0) ShareShare
ReportReport
Posted on by 135

Hello and good day to you all, I would like to ask, is it possible to add a filter options in the following image I have provided to my custom search bar?

SEARCH2.png

Here is the form I made, it can only search for 1 item only, what I wish to do is to be able to select different items by using the filter options like *!<>.

5482.SCREEN3.png

*This post is locked for comments

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: How to make the filter option available

    Try to use SysQuery::valueLike().

    For example: SysQuery::findOrCreateRange(InventTable_ds.query().dataSourceTable(tableNum(InventTable)),fieldNum(InventTable, ItemId)).value(queryValue(SysQuery::valueLike(yourSearchString)));

  • Sean The Michael Profile Picture
    Sean The Michael 135 on at
    RE: How to make the filter option available

    I would like to rephrase my question sir, this is the real problem I am having right now. My search query can only search for 1 specific item, but I am required to allow filtering which allows my query to select multiple items at once, which means I will need to use the LIKE SQL statement In X++. which is using the *,<,> characters to multi-search. Is there any guide on how to do this? Thank you again for replying to my post and sorry for the very confusing question.

  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: How to make the filter option available

    Hi Sean The Michael!

    You can create your own context menu and call it from your custom search bar using right click.

    Take a look at tutorial_PopupMenu form for example.

  • Suggested answer
    Hassan_rulz Profile Picture
    Hassan_rulz 3,801 on at
    RE: How to make the filter option available

    You can use filter at any form by using "CTRL+G".

    Can you please explain what you are trying to ask here?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans