Hi, Im trying to fetch different constant values based on different c

divyav over 9 years ago

Hi,

Im trying to fetch different constant values based on different conditions for choice labels and choice values of "Dropdown field", Each constant has 2 values, but it is returning only single value when I use "Like" conditions. If I use "=", all values of constants are returning. Please see the code below
ChoiceLabels:
if(
like(ri!cdtxyz.tfield,"*New*"),
cons!NEW_LABELS,
if(
like(ri!cdtxyz.tfield,"*Renewal*"),

cons!RENEWAL_LABELS,
if(
like(ri!cdtxyz.tfield,"*Modification*"),
cons!MODIFY_LABELS,
cons!TERMINATE_LABELS_))),

Similarly for Choice values also.

Please suggest any solution to return all values of constants, when like condition is matching

Discussion posts and replies are publicly visible

Parents

0 sagarl511
A Score Level 2
over 9 years ago

@stefanh791 - I went through your example - if(
like({"New"},"*New*"),
{"a", "b"},
{"c", "d"}
)

Isn't it unexpected where output is "a". I tried it and it should return {a,b}. As if() evaluates boolean and also - like({"New"},"*New*") returns true it should return {a,b}. Do you have any idea why is it behaving in this way?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sagarl511
A Score Level 2
over 9 years ago

@stefanh791 - I went through your example - if(
like({"New"},"*New*"),
{"a", "b"},
{"c", "d"}
)

Isn't it unexpected where output is "a". I tried it and it should return {a,b}. As if() evaluates boolean and also - like({"New"},"*New*") returns true it should return {a,b}. Do you have any idea why is it behaving in this way?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data