Return query on specific financial dimension and financial dimension value
// Changed on 30/7/2019 at 15:51:20 by chloel
public static QueryBuildDataSource joinDimensionAttributeLevelValueView(
QueryBuildDataSource _qbds,
DimensionAttribute _dimAttr,
anytype _fromValue = "",
anytype _toValue = "")
{
QueryBuildDataSource qbds;
// verify the source is GeneralJournalAccountEntry table
if(_qbds.table() != tableNum(GeneralJournalAccountEntry))
throw error(Error::wrongUseOfFunction(funcName()));
//join DimensionAttributeLevelValueView
qbds = _qbds.addDataSource(tableNum(DimensionAttributeLevelValueView));
qbds.addlink(fieldNum(GeneralJournalAccountEntry, LedgerDimension), fieldNum(DimensionAttributeLevelValueView,ValueCombinationRecId));
qbds.joinMode(JoinMode::InnerJoin);
qbds.fetchMode(QueryFetchMode::One2One);
//query the range of dimensionattribute, for example "C_DDA"
qbds.addRange(fieldNum(DimensionAttributeLevelValueView, DimensionAttribute)).value(queryValue(_dimAttr.RecId));
// query the value of dimensionattribute value, for example "UNC~UNC~UNCL"
qbds.addRange(fieldNum(DimensionAttributeLevelValueView, DisplayValue)).value(SysQuery::range(_fromValue, _toValue));
return qbds;
}
