Hi DAX Community,
I am trying to create a new Custom Sales Order Enquiry form, which must have 2 filters FromDateTime and ToDateTime. This filter must run on the SalesTable.createdDateTime field and retrieve the records from SalesTable.
May I know how can i achieve this?
What steps I took:'
I created the form, create the 2 filters, Created A new table TestTable with 3 fields: SalesId, Sales Name and Created Date Time and this TestTable is being used as a DataSource in the New Sales Order enquiry form.
I can see that the data is being inserted in TestTable but not refecting in the form's grid.
To try fixing this, i tried TestTable_ds.research(true); in the form after the insertion took place - But this didn't fetch me any expected outputs.
Hi Martin Dráb,
Now I have all the data with required fields in View and those I am able to see in the Form.
Fields i can view in form:
Now i have created 2 new filter fields Date from Time and Date To Time. How can i utilize these fields when entered by user to filter records in my form. I mean where i should write the code for this filtering
In executeQuery(). Just search for examples, it has been discussed here many times and AX is also full of examples.