I am trying to use project Stage as a lookup filter for a query based portlet, but when I try to set the stage attribute as a lookup on the query's Attributes tab, I can't find the Investment Type (INV_TYPE) lookup in the list.
Am I doing something wrong?
The Investment Type lookup is a Static Dependent List, and I don't think you can use it on a Query where I assume you are pulling back stage_code, and then attempting to define this with a lookup = Investment Type.
I assume that you have also decoded stage_code as a string, so potentially you could be using the string in the filter, where users can then search for *iden for Idenitfy (as an example).
If you do need the filter attribute to be a lookup, you may have to consider creating a Dynamic Lookup, based on:
select name, code from cmn_lookups_v2 where lookup_type = '***' and landguage_code = 'en'
where *** maps to the Stages for your environment that you have defined in Investment Type look-up.
This new filter should then be able to be used in your Query.
Thank you, Roland, I will give that a try.
Thanks a lot, Roland!
This is the code I used, in case anyone is interested:
@SELECT:LK.PARENT_LOOKUP_CODE || '\\' || LK.NAME:PATH@,
CMN_LOOKUPS_V LK, CMN_LANGUAGES LANG
LK.language_code = @WHERE:PARAM:LANGUAGE@
AND LK.PARENT_LOOKUP_CODE = 'project'