Showing posts with label lookup. Show all posts
Showing posts with label lookup. Show all posts

Tuesday, January 24, 2023

Add Lookup Method for Dimension fields using x++

 Add Lookup Method for Dimension fields using x++.


Division Lookup:

   #define.DimensionName("Division")  
   Query          query;  
   QueryBuildDataSource  qbds,qbds1;  
   SysTableLookup     sysTableLookup;  
   DimensionAttribute   dimAttr;  
     
   dimAttr = DimensionAttribute::findByName(#DimensionName);  
   sysTableLookup = SysTableLookup::newParameters(tablenum(DimensionFinancialTag),divisionCodeLookup);  
   sysTableLookup.addLookupfield(fieldnum(DimensionFinancialTag, Value));  
   sysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag, Description)); 
   
   query = new Query();  
   qbds = query.addDataSource(tableNum(DimensionFinancialTag));  
   qbds1 = qbds.addDataSource(tableNum(DimensionAttributeDirCategory));  
   qbds1.addLink(fieldNum(DimensionFinancialTag,FinancialTagCategory),fieldnum(DimensionAttributeDirCategory,RecId));  
   qbds1.addRange(fieldNum(DimensionAttributeDirCategory, DimensionAttribute)).value(queryvalue(dimAttr.recid)); 
   
   sysTableLookup.parmQuery(query);  
   sysTableLookup.parmUseLookupValue(False);  
   sysTableLookup.performFormLookup(); 


Branch Lookup:

#define.DimensionName("Branch")  
Query          query;  
QueryBuildDataSource  qbds,qbds1;  
SysTableLookup     sysTableLookup;  
DimensionAttribute   dimAttr;  

dimAttr = DimensionAttribute::findByName(#DimensionName);  
sysTableLookup = SysTableLookup::newParameters(tablenum(OMOperatingUnit),branchCodeLookup);  
sysTableLookup.addLookupfield(fieldnum(OMOperatingUnit, OmoperatingunitNumber));  
sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name));  

query = new Query();  
qbds = query.addDataSource(tableNum(OMOperatingUnit));  
qbds.addRange(fieldNum(OMOperatingUnit, OMOperatingUnitType)).value(queryvalue(OMOperatingUnitType::OMBusinessUnit)); 

sysTableLookup.parmQuery(query);  
sysTableLookup.parmUseLookupValue(False);  
sysTableLookup.performFormLookup();


Keep Daxing!!

Thursday, March 31, 2022

Get the recId from lookup in D365FO

 To get the recid or any other field value we can use lookupReference method in D365FO but it is only for recid relation field only.

We can achieve by 2 ways 

1. create new lookup form and calling from lookup method.

2. need to give recid relation and using lookupReference method.


Way1:

Click here

Way 2: lookupReference method

public Common lookupReference(FormReferenceControl _formReferenceControl)
{
    Common                      ret;
    
   // ret = super(_formReferenceControl);

    SysReferenceTableLookup sysReferenceTableLookup;
    Query query;
    QueryBuildDataSource queryBuildDataSource;
     
    // Add the fields that we want to display in the lookup form.
    sysReferenceTableLookup = SysReferenceTableLookup::newParameters(tableNum(WMSLocation), 
                                                                        _formReferenceControl);
    sysReferenceTableLookup.addLookupfield(fieldNum(WMSLocation, wmsLocationId));
    sysReferenceTableLookup.addLookupfield(fieldNum(WMSLocation, LocProfileId));
    sysReferenceTableLookup.addLookupMethod(tableMethodStr(WMSLocation, inventSiteId));
    sysReferenceTableLookup.addLookupfield(fieldNum(WMSLocation, InventLocationId));

    query = new query();
     
    queryBuildDataSource = query.addDataSource(tableNum(WMSLocation));
    queryBuildDataSource.addRange(fieldNum(WMSLocation, InventLocationId)).value(queryValue(InventLocation));
     
    sysReferenceTableLookup.parmQuery(query);
    
    ret = sysReferenceTableLookup.performFormLookup();

    if (ret)
    {
        InventLocationId    InventLocationId = ret.(fieldNum(WMSLocation, InventLocationId));
        
        Info(InventLocationId);
        Info(strFmt('%1',ret.RecId));
    }

    return ret;

    }
    
}

Keep Daxing!!

More than one form was opened at once for the lookup control In D365Fo.

I have added a new field in standard form and I have written lookup code by using event handler. When I click on that control I am getting " More than one form was opened at once for the lookup control" this error. To resolve this we wan use below code.

[FormControlEventHandler(formControlStr(SalesTable, InventLoaction), FormControlEventType::Lookup)] public static void InventLoaction_OnLookup(FormControl sender, FormControlEventArgs e) {

FormControlCancelableSuperEventArgs     eventArg = e as FormControlCancelableSuperEventArgs;

eventArg.CancelSuperCall();

}


Keep Daxing!!


Wednesday, March 30, 2022

Lookup method in D365FO

 Lookup method in D365FO. This lookup is developed by SysTableLookup class. Below code is the simple code.


Query query = new Query(); QueryBuildDataSource qbds; SysTableLookup syslookup; syslookup= SysTableLookup::newParameters(tableNum(InventSite), this);//Sender syslookup.addLookupfield(fieldNum(InventSite, SiteId)); syslookup.addLookupfield(fieldNum(InventSite, Name)); syslookup.addLookupMethod(tableMethodStr(InventSite, Method)); qbds = query.addDataSource(tableNum(InventSite)); qbds.addRange(fieldNum(InventSite, Active)).value(queryValue(NoYes::Yes)); syslookup.parmQuery(query); syslookup.performFormLookup();


Keep Daxing !!

Friday, November 5, 2021

Get financial dimensions lookup in control using X++ in D365fo

 Get financial dimensions lookup in control using X++ in D365fo.

    public static void lookupControl(FormControl _formControl, str _value)

{ FormStringControl control; Args args; FormRun formRun; DimensionAttribute dimAttribute; dimAttribute = DimensionAttribute::findByName(_value); args = new Args(); args.record(dimAttribute); args.caller(_formControl); args.name(formStr(DimensionLookup)); formRun = classFactory.formRunClass(args); formRun.init(); control = _formControl as FormStringControl; control.performFormLookup(formRun); }

    -------------------------------------or---------------------------------------------------------------------------

    public void lookupLocation(FormStringControl _formControl) {

        QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; DimensionAttribute dimAttr; dimAttr = DimensionAttribute::findByName("Location"); Query query = new Query(); SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(DimensionAttributeValue),
                                                                                          _formControl); query.addDataSource(tablenum(DimensionAttributeValue)).addRange(fieldNum(DimensionAttributeValue,
                                                                           DimensionAttribute)).value(
                                                                              queryValue(dimAttr.RecId)); //query.addDataSource(tablenum(DimensionAttributeValue)).addRange(fieldNum(DimensionAttributeValue,
                                                                                 IsDeleted)).value(
                                                                                  sysquery::value(NoYes::No)); sysTableLookup.addLookupfield(fieldNum(DimensionAttributeValue, DisplayValue), true);
        // pass method
        //sysTableLookup.addLookupMethod(tableMethodStr(DimensionAttributeValue, methodname), true);
         //this code is to add the ranges for filtering sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup();

}

Keep Daxing!!

Monday, September 27, 2021

Add InventLocationId Lookup based on site in D365Fo.

 I got a requirement like I want to filter the warehouse based on site. Here I have to show standard lookup. So I follow the standard code. It is already written in purchTable.


 location field:

    class InventLocationId { public void lookup(FormControl _formControl, str _filterStr) { if (purchTable.InventSiteId) { InventLocation::lookupBySiteIdAllTypes(_formControl, purchTable.InventSiteId); } } } //lookupBySiteIdAllTypes method from inventLocation table. public static void lookupBySiteIdAllTypes(FormStringControl _ctrl, InventSiteId _inventSiteId) { SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventLocation), _ctrl); ListEnumerator listEnumerator = List::create(InventLocation::standardLookupFields()).getEnumerator(); while (listEnumerator.moveNext()) { sysTableLookup.addLookupfield(fieldName2id(tableNum(InventLocation), listEnumerator.current())); } sysTableLookup.parmQuery(InventLocation::standardLookupBySiteIdQuery(_inventSiteId)); sysTableLookup.performFormLookup(); } //standardLookupFields method from InventLoaction table. Here we get the field from autoLookup group from table. public static container standardLookupFields() { List list = new List(Types::String); SysDictFieldGroup sysDictFieldGroup = new SysDictFieldGroup(tableNum(InventLocation), tableFieldgroupStr(InventLocation, AutoLookup)); Counter numberOfFields = sysDictFieldGroup.numberOfFields(); Counter i; for (i=1; i<=numberOfFields; i++) { list.addEnd(fieldId2name(tableNum(InventLocation),sysDictFieldGroup.field(i))); } return list.pack(); } //standardLookupBySiteIdQuery method is used to filer the query based on site. public static Query standardLookupBySiteIdQuery(InventSiteId _inventSiteId) { Query query = new Query(); QueryBuildDataSource queryBuildDataSource; queryBuildDataSource = query.addDataSource(tableNum(InventLocation)); if (_inventSiteId) { queryBuildDataSource.addRange(fieldNum(InventLocation,InventSiteId)).value(_inventSiteId); } return query; }


Keep daxing!!

Wednesday, June 9, 2021

How to get RecId selected from lookup method?

 How to get RecId selected from the lookup method?. 

public void lookup()
{
    FormRun lookupFormRun;
    Args args;
    MyTable    myLookup;

    args = new Args();
    args.name(formStr(MyNewLookupForm)); // args.caller(this);
    lookupFormRun = classFactory.formRunClass(args);
    lookupFormRun.init();
    this.performFormLookup(lookupFormRun);
    lookupFormRun.wait();
    if (lookupFormRun.closedOk())
    {
        myLookup= formRun.docCursor();
    }
}
Override 'MyNewLookupForm' (new lookup form) init method. Write below logic.
public void init()
{
     super();

     element.selectMode(MainField);
} //MainField -> This is grid field name. Set Auto decleration to Yes.
public void run() // Fileter the selected value in control.
{
    boolean filterLookup;
    FormStringControl callingControl = SysTableLookup::getCallerStringControl(
                                                                   element.args());
    /*filterLookup = SysTableLookup::FilterLookupPreRun(callingControl, 
                                                        Dinosaurs_DinosaurName, 
                                                                Dinosaurs_ds);*/
    super();
 
    SysTableLookup::FilterLookupPostRun(/*filterLookup*/true, 
                                        callingControl.text(), 
                                        Dinosaurs_DinosaurName, 
                                        Dinosaurs_ds);
}


Keep Daxing!!

Monday, September 14, 2020

Filtering drop down list based on another drop down on Dialog in Ax 2012 using X++

 Hi guys, Today we see how to Filtering drop down list based on another drop down.

In SysOperation we have to write code in 4 classes.

1.Contract class.

2.Controller class.

3.Service class.

4.UI builder class.


Contract class:

Mainly Contract class is for parameter Declaration Through Parm Methods.We set any Default values we implement with SysOperationInitializable. Before that we have to use SysOperationAlwaysInitializeAttribute.

For any validations we have to implement with SysOperationValidatable.


Class Declaration:

[DataContractAttribute,SysOperationAlwaysInitializeAttribute, SysOperationContractProcessingAttribute(classStr(CustDetailsUiBuilder))] public class CustDetailsContract implements SysOperationInitializable,SysOperationValidatable { CustGroupId custGroup; AccountNum accountNum; }

Parm Method1:

[DataMemberAttribute('AccountNum'), SysOperationLabelAttribute('AccountNum'), SysOperationHelpTextAttribute('AccountNum.')] public AccountNum parmAccountNum(AccountNum _accountNum= accountNum) { accountNum = _accountNum; return accountNum; }

Parm method 2:

[DataMemberAttribute('CustGroup'), SysOperationLabelAttribute('CustGroup'), SysOperationHelpTextAttribute('CustGroup.')] public CustGroupId parmCustGroup(CustGroupId _custGroup= custGroup) { custGroup = _custGroup; return custGroup; }

initialize method:

public void initialize() { custGroup='10'; accountNum=' '; }

validate method:

public boolean validate() { CustTable custTable; if(this.parmAccountNum()) { custTable=CustTable::find(this.parmAccountNum()); if (!custTable) { return checkFailed('Enter Valid accountNum'); } } else { return checkFailed('Please Enter accountNum'); } return true; }

UiBuilder Class:

    This class is mainly used for User interface Dialog changes. If we want add any lookup,enable or disable, add fields to group.


Class Declaration:

public class CustDetailsUiBuilder extends SysOperationAutomaticUIBuilder { DialogField dialogCustGroup; DialogField dialogAccountNum; CustDetailsContract contract; }

build method:

public void build() { Dialog dialogLocal = this.dialog(); contract = this.dataContractObject(); dialogLocal.addGroup('Customer Id'); this.addDialogField(methodStr(CustDetailsContract,parmAccountNum), contract); dialogLocal.addGroup('Customer Group'); this.addDialogField(methodStr(CustDetailsContract,parmCustGroup), contract); } Modified method: public boolean custGroupModified(FormStringControl _control) { dialogCustGroup.value(_control.valueStr()); return true; }

lookup method: public void lookupAccountNum(FormStringControl _control) { Query query = new Query(); SysTableLookup sysTablelookup; sysTablelookup =SysTableLookup::newParameters(tableNum(CustTable),_control); sysTablelookup.addLookupfield(fieldNum(CustTable,AccountNum)); sysTablelookup.addLookupfield(fieldnum(CustTable,Party)); query.addDataSource(tableNum(CustTable)); query.dataSourceTable(tableNum(CustTable)).addRange(fieldNum(CustTable, CustGroup)).value(dialogCustGroup.value()); sysTablelookup.parmQuery(query); sysTablelookup.performFormLookup(); }

lookup method: public void lookupCustGroup(FormStringControl _control) { SysTableLookup sysTablelookup; sysTablelookup =SysTableLookup::newParameters(tableNum(CustGroup),_control); sysTablelookup.addLookupfield(fieldNum(CustGroup,CustGroup)); sysTablelookup.addLookupfield(fieldnum(CustGroup,Name)); sysTablelookup.performFormLookup(); }

postBuild:

public void postBuild() { super(); dialogCustGroup = this.bindInfo().getDialogField(this.dataContractObject(), methodStr(CustDetailsContract,parmCustGroup)); //if (dialogCustGroup) //{ // dialogCustGroup.lookupButton(2); //} dialogCustGroup.registerOverrideMethod(methodStr(FormStringControl, lookup),methodStr(CustDetailsUiBuilder, lookupCustGroup), this); dialogCustGroup.registerOverrideMethod(methodStr(FormStringControl, modified),methodStr(CustDetailsUiBuilder, custGroupModified), this); dialogAccountNum = this.bindInfo().getDialogField(this.dataContractObject(), methodStr(CustDetailsContract,parmAccountNum)); dialogAccountNum.registerOverrideMethod(methodStr(FormStringControl, lookup),methodStr(CustDetailsUiBuilder, lookupAccountNum), this); //if (dialogAccountNum) //{ // dialogAccountNum.lookupButton(2); //} }

Controller class:

    Main logic We have to written in Controller class.

Class Declaration:

public class CustDetailsController extends SysOperationServiceController { }

new method: public void new() { super(); this.parmClassName(classStr(CustDetailsService)); this.parmMethodName(methodStr(CustDetailsService, process)); } main method: public static void main(Args args) { CustDetailsController controller; controller = new CustDetailsController(); controller.startOperation(); }

Service method:
                    We can write our own logic in Service class.

Class Declaration:

public class CustDetailsService extends SysOperationServiceBase { } process method: public void process(CustDetailsContract _contract) { CustTable custTable; AccountNum accountNum; CustGroupId custGroup; accountNum = _contract.parmAccountNum(); custGroup = _contract.parmCustGroup(); //custTable=CustTable::find(accountNum,true); select forupdate custTable where custTable.AccountNum == accountNum; ttsbegin; custTable.CustGroup=custGroup; custTable.doupdate(); ttscommit; info(strFmt('CustGroup - %1 is updated for %2-Customer',

                custTable.CustGroup, custTable.AccountNum)); }



OutPut:



Based on CustGroup Account number is filterd.





Keep Daxing!!

Monday, August 10, 2020

Lookup method in AX 2012 X++

 Hi guys, To day we see How to create lookup in AX 2012 X++


Lookup created in multiple ways

1.Table Relations

2.EDT Relations.

3.Override Lookup method(using SysTableLookup Class).


To day we see Override Lookup method

                                        

Write the Below code in Lookup Method:

Without Adding Dynamic Query (no filtering):

 Public void lookup()

{

    SysTableLookup syslookup;//class

    syslookup= SysTableLookup::newParameters(tableNum(CustTable),this);


    syslookup.addLookupfield(fieldNum(CustTable,AccountNum));

    syslookup.performFormLookup();

}


With dynamic Query:

 Public void lookup()

{

    Query query = new Query();

    QueryBuildDataSource qbds;

    QueryBuildRange qbr;


    SysTableLookup syslookup;//class


    syslookup= SysTableLookup::newParameters(tableNum(CustTable),this);


    syslookup.addLookupfield(fieldNum(CustTable,AccountNum));

    syslookup.addLookupfield(fieldNum(CustTable,CustGroup));


    qbds=query.addDataSource(tableNum(CustTable));

    qbr=qbds.addRange(fieldNum(CustTable,custgroup));

    qbr.value('10');


    //qbr.value(SysQuery::value());// Enum type

    syslookup.parmQuery(query);

    syslookup.performFormLookup();

}


OUPUT:

                            


Keep Daxing !!