Showing posts with label Multi Select Lookup. Show all posts
Showing posts with label Multi Select Lookup. Show all posts

Friday, January 13, 2023

Modified method is not triggering for Multi Select control in form Level in D365FO.

Hello everyone, I have received a requirement to add a multi-select control at the form level. However, after adding it, the Modified method is not triggering. 

I have added the control to the dialog form.

 

As per user selection I need to showcase those fields.


         To display specific fields based on user selection, I plan to write the code in the control's Modified event. However, the system is not triggering that method. To achieve this, I have followed the process below:


Lookup method in the form control.

public void lookup()
{
    MultiSelect multiSelectGrid = MultiSelect ::construct(Temp_Genders, Temp_Genders);

    Query query = new Query();
    QueryBuildDataSource queryBuildDataSource;
    queryBuildDataSource = query.addDataSource(tableNum(Temp));// My Table
    queryBuildDataSource.addSelectionField(fieldNum(Temp, Genders));

    multiSelectGrid.parmQuery(query);
    multiSelectGrid.parmCallingControl(this);
    multiSelectGrid.run();
}


  • For a multi-select lookup, the 'SysLookupMultiSelectGrid' class needs to be used. 
  • When the user selects values in the lookup, the 'SetSelected' method is triggered.
  •  To achieve this, I have created a new class, extending from 'SysLookupMultiSelectGrid,' and overridden the necessary methods.

class MultiSelect extends SysLookupMultiSelectGrid
{
    #Characters
    public void setSelected()
    {
        dictfield          dictField;
        Common             currentDSRecord;
        FormDataSource     formdatasource;
        container          con = this.selectedStr;
        callingControlId.text(SysOperationHelper::convertMultiSelectedValueString(selectedId));

        formdatasource = callingControlId.dataSourceObject();
      
        FormRun  FormRunLoc= formdatasource.formRun();

        // My custom code
        if (formHasMethod(FormRunLoc,  identifierStr(visibilityValidation)))
        {
            FormRunLoc.visibilityValidation(con);
        }

        if(formdatasource && callingControlStr.dataField())
        {
            dictfield = new dictfield(formdatasource.table(),callingControlStr.dataField());
            currentDSRecord = formdatasource.cursor();
            currentDSRecord.(dictfield.id()) = currentDSRecord.(dictfield.id()) 
                            + SysOperationHelper::convertMultiSelectedValueString(selectedStr);
            callingControlStr.update();
        }
        else
        {
            callingControlStr.text(SysOperationHelper::convertMultiSelectedValueString(selectedStr));
        }
    }

    public static MultiSelect construct(FormControl ctrlId, FormControl ctrlStr)
    {
        MultiSelect lookupMS = new MultiSelect ();

        lookupMS.parmCallingControlId(_ctrlId);
        lookupMS.parmCallingControlStr(_ctrlStr);

        return lookupMS;
    }
}


From the above code, I am triggering the form method. That code you can find below.

Public TestForm extend FormRun
{
    public void visibilityValidation()
    {
        boolean     isMale, isFemale, isOthers;

	isMale   = conFind(_con, 'Male');
	isFemale = conFind(_con, 'Female');
	isOthers = conFind(_con, 'Others');
		
	if (conFind(_con, 'Both'))
	{
	    isMale = true;
	    isFemale = true;
	}

	Temp_Male.visible(isMale);
	Temp_Female.visible(isFemale);
	Temp_Others.visible(isOthers);
    }
}

If you have used "SysLookupMultiSelectCtrl" class. You can follow the above process.


Thank you, Yasin, For your support. 

Keep Daxing!! 

Friday, October 22, 2021

Multi select lookup parameter using UI Builder class In D365fo using x++

 Today we see how to get multi-select lookup in the report dialog.  This is used to sys operation Framework also. We have to fetch selected records in dp class or service class. For this, I wrote logic in the below classes.


Contract Class :

    [ DataContractAttribute, SysOperationContractProcessingAttribute(classstr(TestUIBuilderClass)) ] class TestContractClass { List vendAccountList; [ DataMemberAttribute("Vendor"), AifCollectionTypeAttribute("Vendor", Types::String), SysOperationLabelAttribute(literalstr("Vend account")), SysOperationHelpTextAttribute(literalstr("Vend account.")), //SysOperationGroupMemberAttribute('Group'), SysOperationDisplayOrderAttribute('1') ] public List parmVendorList(List _vendAccountList = vendAccountList) { vendAccountList = _vendAccountList; return vendAccountList; } }

-------------------------------------------------------------------------------------------------------------

UI Builder Class:

    class TestUIBuilderClass extends SrsReportDataContractUIBuilder { TestContractClass myContractClass; DialogField dialogField; container con; public void build() { // super(); // Add group to dialog //Dialog dialogObject = this.dialog(); // dialogObject.addGroup('Group'); myContractClass = this.dataContractObject() as TestContractClass; dialogField = this.addDialogField(methodStr(TestContractClass, parmVendorList), TestContractClass); } public void postBuild() //or postRun() we can use any method. { super(); myContractClass = this.dataContractObject() as TestContractClass; dialogField = this.bindInfo().getDialogField(TestContractClass, methodStr(TestContractClass, parmVendorList)); dialogField.registerOverrideMethod(methodStr(FormStringControl, lookup), methodStr(TestUIBuilderClass, VendorLookup), this); //dialogField.registerOverrideMethod(methodStr(FormStringControl, modified), methodStr(TestUIBuilderClass, Vendormodified), this); // modified method. //if (dialogField) //{ // dialogField.lookupButton(2); //} } public void VendorLookup(FormStringControl _control) { Query query = new Query(); QueryBuildDataSource vendQBD; // QueryBuildFieldList fieldList; vendQBD = query.addDataSource(tableNum(VendTable)); //qbds1 = qbds.addDataSource(tableNum(DirPartyTable)); //qbds1.relations(True); //qbds1.fields().clearFieldList(); //fieldList = qbds.fields(); //fieldList.addField(fieldNum(DirPartyTable, Name)); //fieldList.dynamic(QueryFieldListDynamic::No); vendQBD.addSelectionField(fieldNum(VendTable, AccountNum)); SysLookupMultiSelectGrid::lookup(query, _control, _control, _control, con); } }

-------------------------------------------------------------------------------------------------------------

DP Class

    [ SRSReportQueryAttribute (querystr(Myquery)), SRSReportParameterAttribute(classstr(TestContractClass)) ] class TestDPClass extends SRSReportDataProviderBase //SrsReportDataProviderPreProcess { MyTable myTable; List vendorList; Vendtable vendTable; [SRSReportDataSetAttribute(tableStr('MyTable'))] public MyTable getTempMyTable() { select MyTable; return MyTable; } private Query buildQuery(Query _query,List _vendorList) { ListIterator listIterator = new ListIterator(_vendorList); while(listIterator.more()) { _query.dataSourceTable(tablenum(VendTable)).addRange(fieldnum(VendTable, AccountNum)).value(queryValue(listIterator.value())); listIterator.next(); } return _query; } public void processReport() { QueryRun queryRun; TestContractClass contract = this.parmDataContract() as TestContractClass; Query query = this.parmQuery(); ; vendorList = contract.parmVendorList(); queryRun = new QueryRun(vendorList.empty() ? query : this.buildQuery(this.parmQuery(), vendorList)); while(queryRun.next()) { vendTable = queryRun.get(tablenum(VendTable)); this.insertIntoTempTable(); } } private void insertIntoTempTable() { myTable.AccountNum = vendTable.AccountNum; myTable.VendGroup = vendTable.VendGroup; myTable.insert(); } }


Keep Daxing!!

Tuesday, July 21, 2020

How to Create Multi Select Lookup in Microsoft Dynamics AX using X++

Hi guys, Today we see how to create multi select lookup on form level in Dynamics Ax using X++.

It will work for both 2012 and D365FO.

Unbound field :
Here we are adding Dynamic query to lookup.
Set Auto Declaration property "Yes" to control field(VendAccountNum).


Write below code on Class declaration on form level:

public class FormRun extends ObjectRun
{
    SysLookupMultiSelectCtrl msCtrl;
} 

Way 1  : adding fields from one table only :

Write Below code in Form init method:

public void init()
{
    Query query = new Query();
    QueryBuildDataSource qbds;

    super();

    qbds= query.adddatasource(tablenum(VendTable));

    qbds.fields().addField(fieldNum(VendTable,AccountNum));
    qbds.fields().addField(fieldNum(VendTable,VendGroup));

    msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(element, VendAccountNum , query);//dynamic Query

   msCtrl = SysLookupMultiSelectCtrl::construct(element, VendAccountNum , querystr(query));//static query
}

You can check your from it show the multiple lookup.
Output:


For testing purpose try below code

void clicked()
{
    container         con;
    int               i;

    con=msCtrl.getSelectedFieldValues();
    //con=msCtrl.get();//RecId values we get

    for (i=1; i<=conLen(con); i++)
    {
            Info(strfmt('%1',conPeek(con,i));
    }
}

Way 2 : adding fields from multiple tables :

    SysLookupMultiSelectCtrl     itemNumberControl;// Declare in global

    // This method we are calling from in it method.
    private void initItemMultiSelectCtrl()
    {
        QueryBuildDataSource    ecoResProductQbds, productTranslationQbds;
        Query                   ecoResProductQuery = new Query();

        ecoResProductqbds = ecoResProductQuery.addDataSource(tableNum(EcoResProduct));
        ecoResProductqbds.fields().addField(fieldNum(EcoResProduct, DisplayProductNumber));

        productTranslationQbds  = ecoResProductqbds.addDataSource(tableNum(EcoResProductTranslation));
        productTranslationQbds.relations(true);
        productTranslationQbds.fields().addField(fieldNum(EcoResProductTranslation, Name));

        itemNumberControl   = SysLookupMultiSelectCtrl::constructWithQuery(element, ItemNumber , ecoResProductQuery);

//ItemNumber  : control name. (need to put auto declaration is yes);
    }

// To get the data from that control : 
 any2str(conPeek(itemNumberControl.getSelectedFieldValues(), 1)) == ""  // check user is selected any value or not.

itemNumberControl.getSelectedFieldValues() // get the user selected values. It will return container.



For Bound field:

Some times wee need to store the user select value in table.

  • For bound field also we need to create unbound field and add the above code.
  • Need to add few more methods.
Data source active method.

 public int active()
   {
        int ret;
        
        ret = super();
ItemNumber.text(Table.field);

return ret;
   }

Unbound Field modified method.

        public boolean modified()
        {
            boolean ret;
    
            ret = super();
    // use any one line
            table.field = ItemNumber.valueStr();
            table.field = this.valueStr();
        table.field = Con2str(itemNumberControl.getSelectedFieldValues());

            return ret;
        }

case 1 : If your showcasing field in details form need to add unbound control.
case 2 : If your showcasing field in grid drag that field from table.


Keep Daxing !!