Create lookup method for multiple datasource with no direct relation

-

 Today we have a requiremnt to create look up metho which shows the postion id on the bases of the job . but on the 2 table there is no direct relation so we can see how we join 


1) create a look up method on table level.

2) create a lookup method and pass the refernce on datasource filed level.


1) create a look up method on table level. :- 


 static public void lookupPostionID(FormStringControl _formStringControl, str _jobID)

    {

        

        Query                   query = new Query();


        QueryBuildDataSource    qbds_HcmPostion;

        QueryBuildDataSource    qbds_HcmPositionActionLine;

        QueryBuildDataSource    qbds_HcmPositionActionDetail;

        QueryBuildDataSource    qbds_Hcmjob;


        QueryBuildRange         qbr_Name;

        SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tablenum(HcmPosition), _formStringControl); //EntAssetObjectTable

        

        // initial

        qbds_HcmPostion             = query.addDataSource(tableNum(HcmPosition));


        qbds_HcmPositionActionLine  = qbds_HcmPostion.addDataSource( tableNum(HcmPositionActionLine));

        qbds_HcmPositionActionLine.relations( true);

        qbds_HcmPositionActionLine.fields().dynamic(NoYes::Yes);

        qbds_HcmPositionActionLine.joinMode(JoinMode::InnerJoin);


        qbds_HcmPositionActionDetail = qbds_HcmPositionActionLine.addDataSource( tableNum(HcmPositionActionDetail));

        qbds_HcmPositionActionDetail.relations(false);

        qbds_HcmPositionActionDetail.addLink(fieldNum(HcmPositionActionLine, ActionState), fieldNum(HcmPositionActionDetail, ActionState));

        qbds_HcmPositionActionDetail.fields().dynamic(NoYes::Yes);

        qbds_HcmPositionActionDetail.joinMode(JoinMode::InnerJoin);


        qbds_Hcmjob = qbds_HcmPositionActionDetail.addDataSource( tableNum(HcmJob));

        qbds_Hcmjob.relations( true);

        qbds_Hcmjob.fields().dynamic(NoYes::Yes);

        qbds_Hcmjob.joinMode(JoinMode::InnerJoin);


        qbr_Name = qbds_Hcmjob.addRange(fieldNum(HcmJob, RecId));

        // define query range value

        qbr_Name.value(SysQuery::value(HcmJob::findByJob(_jobID).RecId));


        // perform lookup

        sysTableLookup.addLookupField(fieldNum(HcmPosition, PositionId));

        sysTableLookup.parmQuery(query);

        sysTableLookup.performFormLookup();


    }

=======================================================================

2) create a lookup method and pass the refernce on datasource filed level.


/// <summary>

            ///

            /// </summary>

            /// <param name = "_formControl"></param>

            /// <param name = "_filterStr"></param>

            public void lookup(FormControl _formControl, str _filterStr)

            {

                NGOfferLetterHeader::lookupPostionID(_formControl, HcmJob::find(callerHRMApplication.Job).JobId);

            }



==================xxxxxxxxxxxxxxxxxx=========================


Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more