Query build extended range example


static void testExtendedQuery(Args _args)
{
    Query                   q   = new Query();
    QueryBuildDataSource    qbds= q.addDataSource(tableNum(UtilElements));
    QueryRun                qr;
    str                     extRange;
    UtilElements            utilElements;

    extRange = strFmt("(((%1.%2=%3) || (%1.%2=%4)) && (%1.%5 LIKE \"%6\"))",
            qbds.name(), fieldStr(UtilElements, recordType),
            enum2int(utilElementType::OutputTool), enum2int(utilElementType::ActionTool), 
            fieldStr(UtilElements, name), 'RetailLabel*');
    
    qbds.addRange(fieldNum(UtilElements, recordType)).value(extRange);

    qr = new QueryRun(q);
    while (qr.next())
    {
        utilElements = qr.get(tableNum(UtilElements));
    }
}
Resulting query:
SELECT * FROM UtilElements(UtilElements_1)
    WHERE (((((UtilElements_1.recordType=2) || (UtilElements_1.recordType=3))
           && (UtilElements_1.name LIKE "RetailLabel*")))

Support The Author

If you found value in what I share, I've set up a Buy Me a Coffee page as a way to show your support.

Buy Me a Coffee

Post a Comment

   renew the code

All Comments

No comments. Be the first one to comment on this post.

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics 365 FO.

Authors are allowed to set their own "buy me a coffee" link.
Join us.

Blog Tags