Haven't done one of these in a couple of years so a bit rusty. Would appreciate any help.
I need to create a parameterized lookup on sub-object B under Idea object such that it reads the records from Sub-object A for the same idea instance and displays them in a browse lookup.
I had the following code in the lookup:
select id, name from odf_ca_subobject_a
where odf_parent_id = @where:PARAM:XML:INTEGER:/data/odf_parent_id/@value@
I created an attribute under sub object B, associated with this lookup, added it to create layout
and expected to see the list of records from sub-object A but not seeing it.
I thought this code will read the odf_parent_id value from the URL of the create layout and pass it to the lookup. But evidently something is not right.
What am I missing?