a33ik: How to select from internal table

[Blog bot]

Источник: http://daxonline.org/1953-how-to-sel...nal-table.html
==============

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.





Источник: http://daxonline.org/1953-how-to-sel...nal-table.html