Document Number Calculated Mask

Hi Catherine,

Yes, you can use it under Calculated Mask editor through Director. It is same as eQL you do in REPORT DESIGNER.
You can use eB Administrator Guide for the help.

Hi Manav,


I'm trying to use this expression, which the admin guide says is valid:

CASE( Input_Expression ) – Evaluates a list of conditions and gives one of multiple possible result text
Example:
CASE Input_expression
WHEN When_expression
THEN ouput1_expression
ELSE output2_expression
END

But it always throws an error saying 'THEN' expected, even though I include a THEN statement. For example with the below:

CASE Code
WHEN Attributes["Global", "Numbering Scheme"].Value = 7 THEN Code = ‘1’
ELSE WHEN Attributes["Global", "Numbering Scheme"].Value = 7 THEN Code = ’2’
END


Thanks,

Catherine

Hi Manav,


I'm trying to use this expression, which the admin guide says is valid:

CASE( Input_Expression ) – Evaluates a list of conditions and gives one of multiple possible result text
Example:
CASE Input_expression
WHEN When_expression
THEN ouput1_expression
ELSE output2_expression
END

But it always throws an error saying 'THEN' expected, even though I include a THEN statement. For example with the below:

CASE Code
WHEN Attributes["Global", "Numbering Scheme"].Value = 7 THEN Code = ‘1’
ELSE WHEN Attributes["Global", "Numbering Scheme"].Value = 7 THEN Code = ’2’
END


Thanks,

Catherine

Catherine,

Please try :

CASE Attributes["Global", "Numbering Scheme"].Value
WHEN 7 THEN ‘1’
ELSE ’2’
END

Hi Manav,

This has just returned the error 'Line 2 Col 13: invalid expression'

Thanks,

Catherine

Hi Manav,

This now works:

CASE Attributes["Global", "Numbering Scheme"].Value WHEN 7 THEN '1' WHEN 8 THEN '2' ELSE '3' END

However I need to make it significantly more complicated, as I need 1, 2 and 3 to actually be calculated themselves rather than fixed values. Is that possible? For example could it be:


WHEN 7 THEN 'IFNULL(Projects.Project.Code, '?')+'-'+IFNULL( Responsibilities.Organization.Code, '?' )+'-'+Class.Code+'-'+TRIM(LEFT(IFNULL(Attributes["Global", "Discipline"].Value, '?'),3))+'-'+'######''

Thanks for your help!

Catherine

Great - otherwise I was thinking to suggest one more:
START WITH Document
SELECT CASE Attributes["Global", "Numbering Scheme"].Value
WHEN 1 THEN 'One'
ELSE 'TWO'
END
WHERE Id > 0

Hi Manav,

Is it possible to have something like this as the 'THEN' statement rather than just a fixed value? :

THEN 'IFNULL(Projects.Project.Code, '?')+'-'+IFNULL( Responsibilities.Organization.Code, '?' )+'-'+Class.Code+'-'+TRIM(LEFT(IFNULL(Attributes["Global", "Discipline"].Value, '?'),3))+'-'+'######''

Thanks,

Catherine