web
You’re offline. This is a read only version of the page.
close
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 AX (Archived) / How to make the filter...
Microsoft Dynamics AX (Archived)

How to make the filter option available

(0) ShareShare
ReportReport
Posted on by Sean The Michael 139

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

I have the same question (0)
  • Suggested answer
    Hassan_rulz Profile Picture
    Hassan_rulz 3,801 on at

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

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

  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    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.

  • Sean The Michael Profile Picture
    Sean The Michael 139 on at

    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.

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at

    Try to use SysQuery::valueLike().

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

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans