for requirement, i have some Vendors (users) with Brand Names. for both Vendor and Brand the name column value is same.
when an order is placed and via Vendor Orders and operator select that Vendor, in detail area user will see related brand items in PopUp LOV
created a Page Item (P34_VENDORNAME), set value with a DA and reference this in my LOV query as below:
-- this will set output in multiple page items
SELECT i.ITEM_NAME, i.ID ITEM_ID, i.BRAND_ID, b.BRAND_NAME, i.CATEGORY_ID, c.CATEGORY_NAME,
i.UNIT_ID, u.UNIT_NAME, s.ID STORE_ID, s.STORE_NAME
FROM ITEMS i, UNITS u, BRANDS b, CATEGORIES c, STORES s
WHERE i.UNIT_ID = u.ID
AND b.ID = i.BRAND_ID
AND c.ID = i.CATEGORY_ID
AND upper(trim(b.brand_name)) = TRIM(:P34_VENDORNAME) --> my Page Item here...
AND s.ID = 338 -- this is intenionally to have General Store by default
ORDER BY i.ITEM_NAME, c.CATEGORY_NAME, b.BRAND_NAME
when run its not populating any brand related items in PopUp LOV.
tried using a page item on Global Page but not worked. also tried an Application Item but still not worked.
please help, how i can achieve this?
regards