I don't believe there's a good way to do this out of the box and there might not be any way to do it. Since it sounds like you're bound to an attribute, you might be able to use a retrieve list automation script launch point and check if you're on a zombie MBO (mbo.isZombie()) and then interact with the UI (utilizing UIContext) to try to get the value in another input on that dialog. But if you're on an out of the box object/attribute I'd avoid it because it'd suppress the logic for the attribute. Even if you were on a custom object where the risk is low, I'm not sure that you'd be able to interact with the UI from the Retrieve List automation script event and if you'd have a good way to parse the values.
------------------------------
Steven Shull
IBM
------------------------------
Original Message:
Sent: 09-27-2021 14:39
From: Pat Galloway
Subject: BIRT report parms - how to get parm2 to reference parm1 on lookup
Hi - I have BIRT report with two parms - is there a way for parm2 lookup query to reference the value input on parm1? I have tried to reference the parameter :location in the lookup.xml whereclause but that does not have a value when I look in sql log. Detail first parm lookup displays all locations and user selects a location . Now I would like second parm lookup to display list of all assets at that location and can select asset(s). Thanks!
#Customizations
------------------------------
Pat Galloway
Galloway Consulting
------------------------------