Computed column switch statement

(0) Share

Report

Posted on by Jason0810M

Hello,
I have the following scenario in x++ that I need to implement in the SalesOrderHeaderV2 entity as a computed column:

switch (SalesTable.SalesStatus)
{
   case SalesStatus::Backorder:
   if (SalesTable.DocumentStatus == DocumentStatus::None ||
       SalesTable.DocumentStatus == DocumentStatus::Confirmation)
   {
       return 'Value1';
   }
   break;
   case SalesStatus::Delivered:
   case SalesStatus::Invoiced:
       return 'Value2';
   break;
}

//return empty string if conditions are false
return '';

I am not too familiar with the SysComputedColumn.
Can anyone please share how this could be converted as a computed field logic?

All responses (2)

Answers (1)

Jason0810M on at

Like (0)

Report

Computed column switch statement

Hello Martin,

Actually for the BackOrder case there is another check and another value to be implement like this:
case SalesStatus::Backorder:
    if (SalesTable.DocumentStatus == DocumentStatus::None ||
        SalesTable.DocumentStatus == DocumentStatus::Confirmation)
    {
        return 'Value1';
    } else if (SalesTable.DocumentStatus == DocumentStatus::PackingSlip||
        SalesTable.DocumentStatus == DocumentStatus::Invoice)
   {
       return 'Value3';
   }

I have managed to do a switch on the SalesStatus. I have then for the Map condition of the BackOrder I have called another switch for the DocumentStatus field.
Thanks.
Verified answer

Martin Dráb 230,466 Most Valuable Professional on at

Like (0)

Report

Computed column switch statement

You can utilize SysComputedColumn::switch() or SysComputedColumn::switchOrdered().

Although you can use it without understanding what it does, a good first step is thinking about what T-SQL code you want to generate and only then writing X++ generating this T-SQL. Knowing what T-SQL code you want would help you finding right helper methods, at will help you if when verifying that correct code is being generated.

By the way, the logic in the Backorder case makes no sense to me. The value is Backorder there, therefore there is no point in checking whether it's None or Confirmation.

Computed column switch statement

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Leaderboard

Featured topics

Product updates

Computed column switch statement

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates