Showing posts with label Filter Query Before Open the Form Based on Condition in Ax 2012. Show all posts
Showing posts with label Filter Query Before Open the Form Based on Condition in Ax 2012. Show all posts

Friday, 28 September 2018

Filter Query Before Open the Form Based on Condition in Ax 2012

Filter Query Before Open the Form Based on Condition.
-----> Init Method and
----->ExecuteQuery

this.query().dataSourceTable(tablenum(LedgerJournalTable)).addRange(fieldnum(LedgerJournalTable, JournalType)).value(queryValue(LedgerJournalType::Daily));
    this.query().dataSourceTable(tablenum(LedgerJournalTable)).addRange(fieldnum(LedgerJournalTable, Posted)).value(queryValue(NoYes::No));