This content has been marked as final. Show 2 replies
Irrespective of building EVALUATE expression (using constant only) in the RPD BMM logical column or just in Answers there are some rules:
If you want to query just EVALUATE expression without some other column then this is must do (example):
case when 1=2 then PRODUCTS.PROD_CATEGORY else EVALUATE('TO_CHAR(%1)' as char, 100) end
Evaluate is using only constant. We place presentation attribute inside the case to make navigator to handle this request.
You can use only EVALUATE('TO_CHAR(%1)' as char, 100) in the Answers column expression but only in combination with another presentation attribute, cannot have only EVALUATE('TO_CHAR(%1)' as char, 100) in the request.
Column2: EVALUATE('TO_CHAR(%1)' as char, 100)