Notifications
Announcements
I have a table Distributor worker target. with Two fields From Date and Two date (Lets take e.g. from date is 3/1/2023 and to date is 4/30/2023) now I have created a dialog form having from date and to date to select and some functionality to get data from table for that selected date range. How I can I achieve this using two different queries
Hi Sachin, you question is not clear, you need From Date and To Date parameters in a Dialog. But what's the functionality that you are trying to achieve, do you want to display those records in a form or update records. Please provide more details.
its a dialog form for excel report data export i want to get data from table , using from date and to date range on dialog
Hello Sachin ,
You can get the value from your dialogField then use it to select record from your table.
boolean getFromDialog() { fromDate = dialogfromDate.value(); toDate = dialogfromDate.value(); return super(); }
If the sole purpose is to export the data to excel based on date range then you can use SSRS report. We have similar requirement where we need to export lot of records based on date range and other filters and created a report instead of form. However, if user need to edit data before exporting then better to use forms. Happy to help you if need any input.
It won't be two different queries, it will be one query with two parameters.
Please check this article. You can leverage it to export data to excel based on FromDate and ToDate in Dialog.
kdynamics.blogspot.com/.../export-data-to-excel-ax-2009-ax-2012.html
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 791 Super User 2025 Season 2
André Arnaud de Cal... 428 Super User 2025 Season 2
Martin Dráb 333 Most Valuable Professional
