Skip to main content

How to Aviod the null values from Lookup() in AX2009

By

 Avoid Null values in Lookup (AX2009)

If you don't want to show Null Values in a lookup list
The below code avoid Null Values in Lookup.
Ex: Avoid Null values from lookup i.e If Qty is zero avoid those record in the lookup
public void lookup()
{
 Query query          = new Query();
 QueryBuildDataSource    queryBuildDataSource;
 QueryBuildRange                    queryBuildRange,queryBuildRange1;
// Create an instance of SysTableLookup where 'this'
// is the current form control.
SysTableLookup sysTableLookup = SysTableLookup
           ::newParameters(tableNum(ItemControl),this);

;
// Add fields to be shown in the lookup form.
        sysTableLookup.addLookupField(fieldNum(ItemControl, BatchNumber));
        sysTableLookup.addLookupField(fieldNum(ItemControl, ItemId));
        sysTableLookup.addLookupField(fieldNum(ItemControl, onhand));

 // Limit and arrange the data selection.

queryBuildDataSource = query.addDataSource(tableNum(ItemControl));

 queryBuildRange = queryBuildDataSource.addRange(
        fieldNum(ItemControl, ItemiD));

        queryBuildDataSource.addRange(fieldnum(ItemControl,ItemID)).value(ProdBOM.ItemId);

queryBuildRange = queryBuildDataSource.addRange(
        fieldNum(ItemControl, onHand));

 // To Avoid Null Values from ItemControl Table in  //lookup        

 queryBuildDataSource.addRange(fieldnum(ItemControl,
Onhand)).value(SysQuery::valueNotEmptyString());
        queryBuildDataSource.addRange(fieldnum(ItemControl,
Onhand)).value('!=0.00');


sysTableLookup.parmQuery(query);


// Perform the lookup.
if(ProdBOM.ProdLineType == BOMType::Production)
{
            sysTableLookup.performFormLookup();
}
else
{
            super();

}

 }

 Any uncertainty regarding lookup email me i will help you folks..

Happy Daxing...

Comments

Post a Comment

Popular posts from this blog

Using File path on a form getting Error in Axapta

By
Hi Folks, After a long time am coming  back to posting few new things here for AX Developer... When we want to select the file path in form level. Normally what we will do create one EDT and extends with filepath (EDT), but that time when you are trying to select the path we will get error like stack-trace/Error message .Don’t worry there is no problem with your ax application. Simple we need to provide the method to the form like filepathLookUpTitle (). Below method we need to add it into form level methods, i.e. str filePathLookupTitle() {     return "Select document folder"; } Thanks Happy Daxing....
20 comments
Read more

Convert word Documents into PDF report [using X++ in Dynamics AX 2009]

By
Hi Friends, This is the way we can convert word format report into PDF in ax2009 static void dsiple_PDS(Args _args) {     Args args;     ReportRun rr;     str reportName = "ReportName";     PurchRFQLine rfqLineTable;     str myPath;     str pdfFileName;     int i;     COM wordApplication;     COM wordDocuments;     COM wordDocument;     COM wordRange;     str a[];     str path;     str pdfPath;     str finalPath;     int length;     int minus;     ;     i = 1;     myPath = winApi::getTempPath();     info(myPath);     args = new Args(reportName);     args.caller(rr);     //rr =...
1 comment
Read more

How to add Filter functionality to Display method in dynamics AXAPTA

By
Hi Friends, Normally filters will work only in table fields but we can't do filters to display method. This below code will work for filters to display method also. Step 1: Go to the form design right click on particular control properties Auto Declaration No to Yes. Step 2: Override the context() method on the display method  . public void context() {     int             selectedMenu;     formrun         fr;     Args            ag;     Name            strtext;     querybuilddataSource qb1;     queryrun    qr;     query       q;     PopupMenu menu = new PopupMenu(element.hWnd());     int a = menu.insertItem('Filter By Field');     int b = menu.insertItem('Filter By Selection');     i...
1 comment
Read more