Showing posts with label Multi selection lookup in grid. Show all posts
Showing posts with label Multi selection lookup in grid. Show all posts

Monday, July 14, 2025

Multi selection lookup in grid

 [Form]

public class Form1 extends FormRun

    

     SysLookupMultiSelectCtrl msCtrl;


    [Control("String")]

    class MyTablenew_FieldString2

    {

        

        public void lookup()

        {

           

           

            Query query = new Query();

            QueryBuildDataSource qbds = query.addDataSource(tableNum(MainAccount));         

            qbds.fields().addField(fieldNum(MainAccount, MainAccountId));

            qbds.orderMode(OrderMode::GroupBy);

            qbds.addGroupByField(fieldNum(MainAccount, MainAccountId));

            qbds.fields().dynamic(NoYes::No);

            msCtrl = SysLookupMultiSelectCtrl::constructWithQuery(element,MyTablenew_FieldString2,query);

            

            msCtrl.set(msCtrl.getSelectedFieldValues());

        }


        

        public boolean modified()

        {

            boolean ret;

        

            ret = super();

            MyTablenew buffer=element.dataSource("MyTablenew").cursor();

            buffer.FieldString2=con2Str(msCtrl.getSelectedFieldValues(),";");

        

            return ret;

        }

    }



}


Output:-






Filtering records in grid in datasource init method

 This article is about filtering records in grid >> Generally if it comes to  Filtering records we go for execute query but sometime w...