Look up part 1

-

  SysTableLookup sysTableLookup;

        QueryBuildDataSource queryBuildDataSourceContractLease;

        QueryBuildDataSource queryBuildDataSourcePeriodTable;

        QueryBuildDataSource queryBuildDataSourceLeaseType;


        Query query = new Query();

        queryBuildDataSourceContractLease = Query.addDataSource(tableNum(FlxContractLease));

        queryBuildDataSourceContractLease.addRange(fieldNum(FlxContractLease, contractId)).value(dialogContractID.value());

        queryBuildDataSourcePeriodTable = queryBuildDataSourceContractLease.addDataSource(tableNum(FlxPeriodTable));


        queryBuildDataSourcePeriodTable.addLink(fieldNum(FlxContractLease,BillingFrequencyPeriodId), fieldNum(FlxPeriodTable ,periodid));

        queryBuildDataSourcePeriodTable.joinMode(JoinMode::InnerJoin);

        queryBuildDataSourcePeriodTable.addRange(fieldNum(FlxPeriodTable ,PricePeriod)).value(sysquery::valueNot(FlxPricePeriod::OneOff));


        queryBuildDataSourceLeaseType = queryBuildDataSourceContractLease.addDataSource(tableNum(FlxLeaseTypeTable));

        queryBuildDataSourceLeaseType.addLink(fieldNum(FlxContractLease ,LeaseTypeId), fieldNum(FlxLeaseTypeTable, LeaseTypeId));

        queryBuildDataSourceLeaseType.joinMode(JoinMode::InnerJoin);

       

        queryBuildDataSourceLeaseType.addRange(fieldNum(FlxLeaseTypeTable , PercentageRent)).value(enum2Str(NoYes::Yes));

       

        sysTableLookup = SysTableLookup::newParameters(tableNum(FlxContractLease), _control,true);

        sysTableLookup.addLookupfield(fieldNum(FlxContractLease, ContractLeaseId), true);

        

        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();

Comments

Post a Comment

Popular posts from this blog

-
Image
Contract Class: Microsoft Dynamics AX 2012 introduces the concept of attributes. Attributes provide a way to specify metadata about classes and methods. Two of these attributes are used when creating data contracts: the DataContractAttribute and DataMemberAttribute attributes.  The DataContractAttribute attribute is used to define that a class is a data contract.  The DataMemberAttribute attribute is added to methods of data contracts that represent data members that have to be exposed. Contracts are used to define what can be communicated. A data contract are used for defining parameters to the SSRS report. We can define any number of parameters using X++ statements of any data type, which can be passed on to the RDP class. A data contract class is an X++ class which contains parm methods with the DataMemberAttribute defined at the beginning of the method. RDP Class: The RDP class is a data provider that allows you to add business logic for the data that is di...
Read more
-
How to get Company information and tax information using X++ code in Ax 2012 http://axatulblogs.blogspot.com/2017/09/get-vendors-gst-number-in-ax-2012-r3.html http://axgenius.blogspot.com/2016/08/how-to-get-company-information-using-x.html https://dhruvrthakar.blogspot.com/2017/07/get-vendor-gstin-from-purchase-order-in.html
Read more
-
Image
Insert Data into Custom Table  (Based On Given Condition Like itemNumber,WareHouse,LocationId,Site ):  static void ProjectManagment1016(Args _args) {     ItemId                          itemid;     InventTable                     inventTable;     InventTrans                     inventtrans;     InventSum                       inventSum;     InventDim                       inventDim;     EcoResProductTranslation        ecoResProductTranslation;     EcoResProduct                   ecoResProduct;     DLSProjectmanagment1016 ...
Read more