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 modify the SysQ...
Microsoft Dynamics AX (Archived)

How to modify the SysQueryForm (TmpSysQuery) criteria dropdown grid

(0) ShareShare
ReportReport
Posted on by Matt Sobe 7

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

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,874 Most Valuable Professional on at

    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?

  • nmaenpaa Profile Picture
    nmaenpaa 101,160 Moderator on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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,160 Moderator on at

    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 on at

    I added th post :

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

    Thank you

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans