web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

How to get Standard "Select" query button in custom form?

(0) ShareShare
ReportReport
Posted on by 204
Hi,
How to get Standard /Select/ query button in custom form?

For ex: 
I have the same question (0)
  • Martin Dráb Profile Picture
    237,801 Most Valuable Professional on at
    Please tell us more about your scenario.
     
    Also, it seems that this is a question about F&O, not AX, right? (This is the AX forum.)
  • GirishS Profile Picture
    27,827 Moderator on at
    Hi RSX,
     
    What does the select button do?
    Is this standard or custom form?
     
    Thanks,
    Girish S.
  • Martin Dráb Profile Picture
    237,801 Most Valuable Professional on at
    I believe that RSX wants to add a button for query modification to a custom form, but how it should be done depends on what he's doing (e.g. whether it's a SysOperation dialog or a stand-alone form).
  • GirishS Profile Picture
    27,827 Moderator on at
    Yes, I agree with martin - You will be having "Advance filter or sort options" - Here you will be able to filter the records and add tables etc.
     
    Thanks,
    Girish S.
  • RSX Profile Picture
    204 on at
    In the all shipments form, I have a dialog form with the shipment Id's that are selected. Yes, Martin, I need to add a button for query modification for the fields, similar to the one that we have in Purchase order > Purchase > Generate > Purchase inquiry.
  • Martin Dráb Profile Picture
    237,801 Most Valuable Professional on at
    I'm sorry, but I still know almost nothing about your scenario.
     
    Are you saying that you want a SysOperation dialog where users can modify a query that you then execute in code and do something with records returned by the query?
     
    If so, you don't need to add a button - the SysOperation framework will do it for you. You just need to add the query to your data contract. See details in Using a query in a SysOperation data contract class, for instance.
  • Prashun kumar Profile Picture
    2 on at
    Hello Martin
    Even i ,am also getting the same issue , this form is stand alone form (Custom form) where we want the functionality of select button ,how Rsx mentioned into his post. If you see any standard form of purchaser order confirmation or sales order confirmation you can see the select button, but here we want for our custom form . So if any idea on this please do share.
  • Martin Dráb Profile Picture
    237,801 Most Valuable Professional on at
    Okay, if you want a button, add a button. No problem.
     
    But if you want to use the button for something, you need to know what for and design a solution that meets the goal. The usual point of this is to allow users to a change a query that is used to fetch and process some records. For example, RSX wanted something "similar to the one that we have in Purchase order > Purchase > Generate > Purchase inquiry", where it's used to fetch information about orders and generate records in PurchParm* tables.
     
    But I have no idea what you want to use it for. You may, for example, use to modify the query used by the form data source, which is a completely different scenario and it would be implemented in a different way. Knowing the requirements is really crucial because there is no universal implementation for all possible requirements.

    In general, the answer to 'How to get Standard "Select" query button in custom form?' is that there is no standard "Select" button. The standard way is using SysOperation (or RunBase) framework. But you surely can implement your own "Select" button doing anything you like. What - that depends on your requirements. If you don't want to use the frameworks and just open query ranges, you need somehow obtain some query, create QueryRun object and call its prompt() method. And do something with the result if the user confirms the dialog.

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…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans