Add field ->StringComputedColumn -> add properties ->View method name as below and EDT
public static str displayDimensionValues()
{
str sql = SysComputedColumn::returnLiteral("");
str targetField = "AllocationAccount";
TableId tableId = tableNum(DimensionAttributeValueCombination);
DimensionAttribute dimensionAttribute = DimensionAttribute::findByName(targetField);
// The dimension attribute column should be valid sql, so it is safe to output.
if(dimensionAttribute
&& dimensionAttribute.getStatus() != DimensionAttributeStatus::Inactive
&& fieldName2Id(tableId, dimensionAttribute.DimensionValueColumnName) != 0)
{
sql = T4.dimensionAttribute.DimensionValueColumnName;
}
return sql;
}
No comments:
Post a Comment