Skip to Content
0
Former Member
Jun 11, 2009 at 02:52 PM

MAX and MIN return Policy in Lookup_ext returns same value.

942 Views

Hi

I am facing a problem with lookup_ext used as an output column function call.

BODS 12.1.1 (al_Engine, al_Job_Server, al_designer)

BODS 12.1.0 (MySQL Local Repository).

Installation (server & client) on Windows XP SP2

When my lookup_Ext returns 2 rows via 3 output columns

DATE_NUMBER CODE DESC

20060207 N74 XYZ

20060208 N56 ABC

If return policy is max, I should get 20060208 and if return policy is min then I should get 20060207 at the output. But, MIN and MAX are both returning 20060207.

When my lookup_Ext returns 2 rows via 1 output column in the mapping expression

DATE_NUMBER

20060207

20060208

The return policy is returning the results as expected.

Is my understanding of lookup_ext wrong?

Does Lookup_ext behave differently when used as a Functional Call in the Query tranform column vs. expression in the mapping?

Thanks & Regards

Tiji