Aishwarya

Parametrized lookup with dates

Discussion created by Aishwarya on Oct 12, 2010
Latest reply on Oct 14, 2010 by Patrick Cooper
Hi All,

I have written a dynamic parametrized lookup.
I need to get the run time date from my object and compare to the existing date.
I have written the lookup in the following way.

SELECT @SELECT:lma_mach_id:ID@
FROM ODF_CA_MW_LMA_LST_MACH_ASSI
WHERE @FILTER@
AND lma_all_st<>@WHERE:PARAM:USER_DEF:DATE:lma_all_st@

My lookup doesnt throw error but when i try mapping the value lma_all_st to the attribute in my object, i am unable to find the corresponding value. ie., the mapping is available only for string and number attributes.
cant we map for any date attributes?

how can i achieve this?


Thanks in advance

Aishwarya

Outcomes