Open the calculated field window in Query builder. Create/select a name for the calculated. Below, click Field Definition drop down to open up as a window. In that window is another drop down at the top. This does not drop down as a window. If attempting to paste a multiple line statement into this field, only the first line is pasted in.
Example:
CASE
WHEN FROM_TO_ERROR = '1' THEN 'It is 1'
WHEN FROM_TO_ERROR = '2' THEN 'It is 2'
ELSE 'It is something else'
END
But in the calc field, it only pastes:
CASE
The rest of the statment does not paste.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center