AnsweredAssumed Answered

Status id to Status text

Question asked by Sebastian Schenk on Apr 18, 2018

Hello.

This topic relates to Schema-Definition:

I have plenty dimensions which used to have a field status. Status means either enable, true, active, not finshed or the opposite and is declared as 0 or 1. Due to the multilanguage system I cannot write the text within the definition but instead into the property-files. So how can I map the numbers to the text. Which ways are practicable, best practise, and how is it solved?

 

Here a solution which uses SQL unnecessarily, can someone tell me how or if I can maybe use inline tables instead?

<View alias="orderstatus">

        <SQL dialect="generic">

          <![CDATA[select

ID,

ERLEDIGT,

CASE ERLEDIGT

WHEN 0 then '%{open}'

WHEN 1 then '%{finished}'

end as STATUS

FROM

DIM_ORDER]]>

        </SQL>

      </View>

Outcomes