Passing data to LOV groups at runtime
605207Oct 28 2007 — edited Oct 31 2007Hello,
I am trying to create an LOV group that accepts variables during runtime in its WHERE clause. I created an entity group and a named bind variables. I have also created the changes at JHeadstart level using its editor. However, I am not sure how to pass a value from the UI to this named bind variable.
Here is what I am trying to do:
1. My LOV query looks like this;
SELECT LKC_LKT_TYPE, LKC_CODE, LKC_DESC
FROM LOOKUPS
WHERE LKC_LKT_TYPE = :LkcLktType
2. I have stored the LkcLktType (example GENDER_CD) in the tooltip of my group item. I want to pass this value to the LOV query named bind variable so that the LOV only displays codes relevant to the gender.
Any idea how I can do that? I feel I need to work on one of the generated Impl files but not sure.
Regards,
Amit