Create computed column in view or data entity with Sql statement
public static server str getHasBreakupDetails() { str expression; expression = '(select count(bl.RecId) from EMSChargebackBreakupLines bl join EMSChargebackBreakupHeader bh on bl.BreakupHeaderRecId = bh.RecId and bh.ChargebackRecId = ' + SysComputedColumn::returnField(tableStr(SAKChargebacksInquiryView),identifierStr(SAKChargebacks),fieldStr(SAKChargebacks,RecId)) + ')'; return SysComputedColumn::if( SysComputedColumn::equalExpression( expression, SysComputedColumn::comparisonLiteral(0)), SysComputedColumn::returnLiteral(0), SysComputedColumn::returnLiteral(1)); } Other examples public static server str getCBNum(TableName _viewName, str ...