x++创建Query

codererererer

于 2021-11-30 15:57:51 发布

阅读量133

点赞数

分类专栏： # Query 文章标签： axapta

本文链接：https://blog.csdn.net/smallstudent1/article/details/121635073

版权

Query 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

How to: Create Queries by Using X++ | Microsoft Docshttps://docs.microsoft.com/en-us/dynamicsax-2012/developer/how-to-create-queries-by-using-x

public void runMyDynamicQuery2()
    {
        Query q;
        QueryRun qr;
        QueryBuildDataSource qbd;
        QueryBuildRange qbr;

        q = new Query();
        qbd = q.addDataSource(TableNum(CustTable));

        qbr = qbd.addRange(FieldNum(CustTable, AccountNum));
        qbr.value(">=4000"); // Default operator is ==.

        qbr = qbd.addRange(FieldNum(CustTable, AccountNum));
        qbr.value("<=4022");

        qbd.addSortField(FieldNum(CustTable, DlvMode));

        qr = new QueryRun(q);
        qr.prompt();

        pause;
    }