Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

Posted on by 5

1) Is there a way to modify the SysQueryForm criteria grid to show more relevant columns (See Example1) ?

Just putting the relevant fields to the - MyTable --> Field Groups --> Autolookup - does not work with SysQueryForm. 

1452.Example.jpg

2) Is there a way to hide the table name in the dialog (See example 2 below) ?

6888.Example2.JPG

Code used:

0068.Example3.JPG

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

    I added th post :

    community.dynamics.com/.../how-to-modify-the-sysqueryform-criteria-dropdown-grid-in-saleseditlines-form

    Thank you

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

    Hi,

    the old discussion is about AX2012, I suggest to post your question to D365 Supply Chain Management form.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

    Hello,

    I am working on the same issue On d365 F&O.

    I want to add the address as a column in the criteria of SySQueryForm in the SalesEditLines Form:

    Could you exlain me how to do this? To add code in which method or form exactly ?

    Thank you in advance

  • nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

    Also it's worth remembering that the user can add new related tables to the query, so if you would not show the table name in the dialog it would become very confusing.

  • Martin Dráb Profile Picture
    Martin Dráb 230,214 Most Valuable Professional on at
    RE: How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

    You could modify SysQueryForm, but what you're asking for would be a massive change. I don't think it would be worth the investment.

    Your second question doesn't really belong to this thread, which has the title "How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid". And your description doesn't make clear what you want exactly - for instance, do you want to hide all fields or just some, and if some, how do you want to decide which fields should be hidden? By the way, do you understand the current logic displaying these fields?

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans