Sample of computed column using enums

(0) Share

Report

Posted on by ShaqAX

709

Hi guys,

Need your lead as I need to create a computed column with calculation depend on field enums.

The case is :

In my data entity, which is the datasource is InventTrans, I have custom field named COGS, which I want to be filled in whenever the InventTrans is with StatusIssue::Sold and InventTransType::Sales. The value to be filled in is the CostAmountPosted in that InventTrans it self.

Question is how am I going to create it in computed column ? At least can someone lead me to a similar case in AOT (but with easy to understand, not a complex code). I've been creating some of this before but usually only relate to values or dates, so has not use field enums before ?

Thanks in advance.

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report
I'm not sure what's your actual problem.

You can use SysComputedColumn::comparisonLiteral() to convert an enum element to the right value in SQL.

To implement the comparison, you can use SysComputedColumn::equalExpression, or simply construct this piece of code as a string.

Use SysComputedColumn::comparisonField() to get references to the fields to compare with.

To combine those conditions, use SysComputedColumn::and().

You can look at reference of these methods to find example in code. For example, look at how StatusIssue is used in InventValueCube::issueAmount():

return SysComputedColumn::if( SysComputedColumn::equalExpression( SysComputedColumn::comparisonField(viewName, identifierStr(InventValueTransUnionAll),fieldStr(InventValueTransUnionAll, StatusIssue)), SysComputedColumn::comparisonLiteral(StatusIssue::None)), SysComputedColumn::returnLiteral(0), SysComputedColumn::negative(SysComputedColumn::returnField(viewName, identifierStr(InventValueTransUnionAll),fieldStr(InventValueTransUnionAll, Amount))));

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Thanks,

Yeap, this is the sample I want to learn or follow. I will take a look first and try, as the actual is the one I described, I want to have COGS value in my data entity which a summary of InventTrans, since CostAmountPosted (Financial cost amount) total is inventory value, right? we cannot see the COGS (my transactions only SO-PO)

Thanks again.

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

How's the "AND" looks like, btw ? Because I need this 2 criteria -> StatusIssue::Sold and InventTransType::Sales

I'm sorry but this is very confusing for me.

Thanks

Was this reply helpful? Yes No
Martin Dráb 237,882 Most Valuable Professional on at

Like (1)

Report

You can use SysComputedColumn::and() to combine the two conditions.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Sample of computed column using enums

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Sample of computed column using enums

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates