AnsweredAssumed Answered

Help with lookup in Designer

Question asked by vtleogal2 on Mar 14, 2013
Latest reply on May 1, 2013 by vtleogal2
Clarity 12.1 - Oracle

On the change request object, there is a custom lookup field - single select; static list.
When the lookup was created in Webi, it pulls the right value, but it is as if it is showing a row for every time the value was changed. If I check the databse, it naturally only shows the current selection. Why?

Example;
CR1- answer A to the lookup
change lookup value to equal "B"
Change again and it now has the value showing as "C"
Run a webi report with the CR ID , Name and lookup
it shows 3 rows
CR ID , CR Name, A
CR ID, CR Name, B
CR ID , CR Name, C

Why is it not just showing its current value?

Thanks

Outcomes