How to select from internal table

There is one way how you can still fetch data from the table, which is marked as internal:



        WHSPrinterName          locPrinterName = '';
        TableId                 tableId         = tableName2Id('WHSWorkUserOverriddenLabelPrinter');
        FieldId                 userIdFId       = fieldName2Id(tableId, 'UserId');
        FieldId                 printerNameFId  = fieldName2Id(tableId, 'PrinterName');
        Query                   q               = new Query();
        QueryBuildDataSource    qbds            = q.addDataSource(tableId);
        QueryBuildRange         qbr             = qbds.addRange(userIdFId);
        QueryRun                qr;
        Common                  workUserOverriddenLabelPrinter;
        qbr.value('VK');
        q.firstOnly1(true);

        qr = new QueryRun(q);
        while (qr.next())
        {
            workUserOverriddenLabelPrinter = qr.get(tableId);
            locPrinterName = workUserOverriddenLabelPrinter.(printerNameFId);
        }

        info(locPrinterName);
Alternatively, you can use direct queries.

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