Data Manipulation tip 5. Like operator wild card in Select query Dynamics ax 2012 D365 for Operations.

Currently I am writing an Inquiry for Client. For this inquiry I have to use Like operator functionality. For example end user wants to search Sale Orders. For this enter the partial sale order number and Inquiry provides the result.

Microsoft provide Like operator , I used it with text box in below code snippet. Suppose strProcumentValue is string edit control with auto declaration as true.

void clicked()

{

PurchTable  _Table;

super();

select * from _Table where _Table.PurchId like “*” + strProcumentValue.text() +”*”;

if (_Table !=null)

{

info(“found”);

}

}

Its works for me,

reference: http://daxdude.blogspot.com/2011/02/use-x-wildcard-like-and-not-like-in-x.html