AX Query에서 사용하는 like operator

Posted by Alvin You
2013. 11. 13. 14:58 Dynamics AX

AX Engine에서 사용되는 Query 작성시 사용할 수 있는 Like 연산자 사용방법에 대한 예제입니다.

 

static void likeOperator(Args _args)
{
    DirPartyTable dirPartyTable;
    ;
 
    select dirPartyTable where dirPartyTable.Name like("*Pusan*");// match with Pusan
    info(dirPartyTable.Name);   
    select dirPartyTable where dirPartyTable.Name like("*Pusan");// end with with Pusan
    info(dirPartyTable.Name);   
    select dirPartyTable where dirPartyTable.Name like("Pusan*");// start with Pusan
    info(dirPartyTable.Name);
}