X++ code to filter PurchTableListPage form ( here it filters only today's Purchase order)

Hi Folks,

Today lets say about how to filter PurchTableListPage form.

Note: here it filters only today's Purchase order 

just goto PurchTableListPageInteraction Class >>initializeQuery()

and write below code which is highlighted below,

Keep Daxing :) !!! 

public void initializeQuery(Query _query)
{
    Query                   query;
    QueryBuildDataSource    qbds;
    QueryBuildRange         rangeCompanyId;
    QueryBuildRange         rangeUserId;
    QueryBuildRange         rangeId;
    QueryBuildRange         rangeStatus,qbr;
    ProjInvoiceTable        projInvoiceTable;
    ProjTable               projTable;

    if (EP::isVendor())
    {
        EPQuery::makeMyVendorSelfServiceQuery(_query, tableNum(PurchTable));
    }

    // added by shiva
    if(this.listPage().listPageArgs().menuItemName()==menuitemDisplayStr(PurchTableListPage))
    {
        qbr = _query.dataSourceTable(tableNum(PurchTable)).addRange(fieldNum(PurchTable,CreatedDateTime));
        qbr.value(queryValue(today()));
    }

    // ended by shiva


    super(_query);

    if (this.listPage().listPageArgs() &&
        this.listPage().listPageArgs().externalRecord() &&
        this.listPage().listPageArgs().menuItemName() ==  menuitemDisplayStr(PurchTableListPage) &&
        this.listPage().listPageArgs().externalRecord().TableId == tableNum(PurchRFQTable))
    {
        purchRFQTable = this.listPage().listPageArgs().externalRecord() as PurchRFQTable;
        this.applyPurchRFQRange(_query, purchRFQTable);
    }
    else if (this.getListPageType() == PurchTableListPage::AssignedToMe)
    {
        qbds = _query.dataSourceTable(tableNum(PurchTable)).addDataSource(tableNum(WorkflowWorkItemTable));
        qbds.joinMode(JoinMode::ExistsJoin);

        qbds.addLink(fieldNum(PurchTable, RecId), fieldNum(WorkflowWorkItemTable, RefRecId));
        qbds.addLink(fieldNum(PurchTable, TableId), fieldNum(WorkflowWorkItemTable, RefTableId));

        rangeStatus = qbds.addRange(fieldNum(WorkflowWorkItemTable, Status));
        rangeStatus.value(queryValue(WorkflowWorkItemStatus::Pending));
        rangeStatus.status(RangeStatus::Locked);

        rangeCompanyId = qbds.addRange(fieldNum(WorkflowWorkItemTable, CompanyId));
        rangeCompanyId.value(queryValue(curext()));
        rangeCompanyId.status(RangeStatus::Locked);

        rangeUserId = qbds.addRange(fieldNum(WorkflowWorkItemTable, UserId));
        rangeUserId.value(queryValue(curUserId()));
        rangeUserId.status(RangeStatus::Locked);

        //The Id-range is only used to lock the query from the Ui
        rangeId = qbds.addRange(fieldNum(WorkflowWorkItemTable, Id));
        rangeId.status(RangeStatus::Locked);
        rangeId.enabled(false);
    }
    else if (this.listPage().listPageArgs() &&
             this.listPage().listPageArgs().externalRecord() &&
             this.listPage().listPageArgs().menuItemName() ==  menuitemDisplayStr(PurchTableListPageProject) &&
             this.listPage().listPageArgs().externalRecord().TableId == tableNum(ProjInvoiceTable))
    {
        projInvoiceTable = this.listPage().listPageArgs().externalRecord();
        qbds = _query.dataSourceTable(tableNum(PurchTable)).addDataSource(tableNum(ProjTable));
        qbds.relations(true);
        qbds.joinMode(JoinMode::ExistsJoin);
        qbds.addRange(fieldNum(ProjTable,ProjInvoiceProjId)).value(queryValue(projInvoiceTable.ProjInvoiceProjId));
    }
    else if (this.listPage().listPageArgs() &&
             this.listPage().listPageArgs().externalRecord() &&
             this.listPage().listPageArgs().menuItemName() ==  menuitemDisplayStr(PurchTableListPageProject) &&
             this.listPage().listPageArgs().externalRecord().TableId == tableNum(ProjTable))
    {
        qbds = _query.dataSourceTable(tableNum(PurchTable));
        qbds.clearDynalinks();

        projTable = this.listPage().listPageArgs().externalRecord();
        qbds = _query.dataSourceTable(tableNum(PurchTable)).addDataSource(tableNum(PurchLine));
        qbds.relations(true);
        qbds.joinMode(JoinMode::ExistsJoin);
        qbds.addRange(fieldNum(PurchLine,ProjId)).value(queryValue(projTable.ProjId));
    }
}

Comments

Post a Comment

Popular posts from this blog

AX7/D365/Operations: Enable/Disable form control in X++

https://dynamicsaxinsight.wordpress.com/2017/09/12/ax7-d365-operations-enable-disable-form-control-in-x-plus-plus/ Purpose: The purpose of this document is to demonstrate how we can enable/disable a form control in X++ based on a business logic. Product: Dynamics 365 for Finance and Operations, Platform Update 9. Development approach: Customization through extension. Development: Create a post event handler of a standard form method enabling/disabling the form controls. In this case, we are creating a post event handler of a standard method setFieldAccessHeader of SalesQuotationProjTable form. Please find the event handler method definition as follows. [PostHandlerFor(formStr(SalesQuotationProjTable), formMethodStr(SalesQuotationProjTable, setFieldAccessHeader))] public static void SalesQuotationProjTable_Post_setFieldAccessHeader(XppPrePostArgs args) { FormRun sender = args.getThis(); FormDataSource salesQuotationTable_ds; SalesQuot...
Read more

AX 2012: Multi-Select Lookup for SSRS Report Dialog

Image
AX 2012: Multi-Select Lookup for SSRS Report Dialog https://dynamicsaxinsight.wordpress.com/2014/12/12/ax-2012-multi-select-lookup-for-ssrs-report-dialog/   muhammadanaskhan     Development (AX 2012) ,  Dynamics AX 2012 ,  SSRS Reports ,  Technical (AX 2012)     December 12, 2014   2 Minutes Overview: In this post we’ll learn how to build multi-select lookup for SSRS report dialog. We’ll create an RDP report with an AutoDesign layout. Controller will be used to run the report. An output menu item will be created to point to the controller class. Each AOT element involved will be described in detail. You can guess the complexity of this development task by looking at the AOT elements required for it: Let’s develop them piece by piece… 1. MAKCustTable (Query): 1. Create MAKCustTable query. 2. Drag CustTable table to the data sources node. 3. Select the fields as shown in the picture. 2. Tm...
Read more

Credit limit check on Sales Quotation based on the customer credit limit in D365 FO of AX7

Credit limit check on Sales Quotation based on the customer credit limit in D365 FO of AX7 class TRG_SalesQuotationTableWriteEventHandler {     /// <summary>     ///     /// </summary>     /// <param name="sender"></param>     /// <param name="e"></param>     [FormDataSourceEventHandler(formDataSourceStr(SalesQuotationTable, SalesQuotationLine), FormDataSourceEventType::Written)]     public static void SalesQuotationLine_OnWriting(FormDataSource sender, FormDataSourceEventArgs e)     {         SalesQuotationTable salesQuotationTable;         SalesQuotationLine  salesQuotationLine,salesQuotationLineLoc;         CustTransOpenSum    custTransOpenSum;         salesQuotationLineLoc = sender.cursor();         salesQuotationTable = salesQuotationTable::find(sales...
Read more