Posts

Showing posts from July, 2023

Filter on checkbox is not available in d365 x++

 Filter on checkbox is not available in d365 x++ on which code is written. Grid column header filtering/sorting Some columns in a grid may not be filterable . In these cases, the column header will not be clickable. From a technical perspective, only columns corresponding to fields in a SQL table can be filtered on or sorted. Columns whose values are computed via code are not filterable or sortable using grid column headers, the Filter pane, QuickFilter, or Advanced filter or sort.

Create Lookup code on dimension field ConfigId in x++

 We can create lookup of configuration in x++ on base of ItemId as follows;         public void lookup()         {             FormRun callerForm = element.args().caller();             InventTable localinventable;              str articleId    = '1234'             select firstonly localinventable where localinventable.ItemId == articleId;             Query query = new Query();             QueryBuildDataSource queryBuildDataSource, QueryBuildDataSource1;             QueryBuildRange queryBuildRange, queryBuildRange1;             SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(EcoResConfiguration ), this);         ...