Dynamics AX Blog - Dynamics AX 2012 - Posts from März 2019
These posts are machine-translated.
Currently, only posts are displayed, which are relevant for Dynamics AX version »Dynamics AX 2012«
RSS-Feed of this version
RSS-Feed of this version
Filter a FormdataSource by financial dimensionsIf you only want to display data records of a table that contain certain financial dimensions in a form, you can do this by overwriting the init() of the FormDataSource as follows: public void init() { super(); SysQuery::addDimensionAttributeRange(salesTable_ds.query(), salesTable_ds.name(), fieldStr(Salestable, DefaultDimension), DimensionComponent::DimensionAttribute, '1001', 'CostCenter'); } You can also call addDimensionAttributeRange() multiple times, so you can filter for multiple dimensions simultaneously. clearDimensionRangesFromQuery() removes such filters: SysQuery::clearDimensionRangesFromQuery(salesTable_ds.query())
|
|
|
|
|
|
|
If you want to run through the contents of a temporary table with a QueryRun, you have to use the method setRecord() of the QueryRun object.
Simple example