Saturday, May 7, 2016

AX 2012 - how to use 'NOT LIKE' in AX statements

Please note that I am using ! after 'where' keyword to reverses the effect of 'like' 

static void Not_Like(Args _args)
{
    #define.createdBy('faisal')
    InventTable     inventTable;
   
    while select inventTable
        where !(inventTable.ItemId like 'I*')
    {
        // do your logic  
    }

}

No comments:

Post a Comment

I will appreciate your comments !

How to enable new Microsoft teams - Public Preview!

New Microsoft Teams is just AWESOME, quick but useful post below shows how you have this preview feature to make your life EASY!  Open Micr...