AnsweredAssumed Answered

Help with a LookUp in Clarity 13

Question asked by juan.segovia on Apr 18, 2012
Latest reply on Apr 20, 2012 by Dave
Hi, I'm trying to create a lookup similar like this one:

select
(CASE @WHERE:PARAM:USER_DEF:INTEGER:esfuerzo_total@
WHEN 0001 THEN 1
WHEN 0002 THEN 2
WHEN 0003 THEN 3
WHEN 0004 THEN 4
ELSE 5 end) value
FROM odf_ca_inv
WHERE id = @WHERE:PARAM:USER_DEF:INTEGER:ID@

My problem here is that instead of having values like 0001 up to 0004 I need to put ranges there.

I'm not sure if this is possible seems all my attempts are failing.

My ranges are like this

0 TO 1999 THEN 1
2000 TO 5999 THEN 2
6000 TO 11999 THEN 3
12000 TO 15999 THEN 4

Do you have any ideas on how can I do this?

Thanks.

Juan

Outcomes