public static server str DefaultDimension() { str field = SysComputedColumn::returnField(tableStr(HRSJobPositionDefaultDimension), identifierStr(HcmPositionDefaultDimension), fieldStr(HcmPositionDefaultDimension, DefaultDimension)); return SysComputedColumn::if( SysComputedColumn::isNullExpression(field), SysComputedColumn::cast("0",'BIGINT'), SysComputedColumn::cast(field,'BIGINT')); }
SYSCOMPUTEDCOLUMN
calculate field on view with SysComputedColumn example code
public static server str getOutstanding() { return strFmt("Sum(%1) + Sum(%2)", SysComputedColumn::returnField( tableStr(TIDIndentOrderUninvoiceTrans), identifierStr(TIDIndentOrderPaymentTrans), fieldStr(TIDIndentOrderPaymentTrans, amountTendered)), SysComputedColumn::returnField( tableStr(TIDIndentOrderUninvoiceTrans) , identifierStr(TIDIndentOrderPaymentTrans), fieldStr(TIDIndentOrderPaymentTrans, grossAmount))); }
Convert null date from outer join on view to maxDate with SysComputedColumn
Example Code :
public static server str ReleasePostingDate() { return SysComputedColumn::if( SysComputedColumn::isNullExpression(SysComputedColumn::returnField( tableStr(TIDAPUninvoiceConsignmentItem) , identifierStr(LedgerJournalTableRealease), fieldStr(LedgerJournalTable, PostedDateTime))), SysComputedColumn::cast(strFmt("'%1'",DateTimeUtil::date(DateTimeUtil::maxValue())),'NVARCHAR'), SysComputedColumn::cast(SysComputedColumn::returnField( tableStr(TIDAPUninvoiceConsignmentItem) , identifierStr(LedgerJournalTableRealease), fieldStr(LedgerJournalTable, PostedDateTime)),'NVARCHAR') ); }