CODEWITHSUNDEEP
oracle-apex
Retal Omar
Retal Omar

Reputation: 39

How can i push data from classic report to interactive grid in the same page in oracle apex?

I have a pos page in oracle apex. this page contained 3 regions. the first is a classic report on the right with search page item. When i type in search the classic report selects only items matching with search result. the second region is interactive grid. I want when only one row appeared in search result it pushed to the grid automatically. when there was more one row, a link column must be found in the report. when I click on the link this row pushed to the grid. and if we clicked on another link column in another row it also be pushed to the grid. I tried to do this scenario using this code, but one row only pushed to the grid. and if I clicked on another it replaced the first.

SELECT PRODUCT_ID,
    PRODUCT_NAME, 
    PRODUCT_CODE, 
    QTY, 
    UNIT_PRICE, 
    TOTAL_PRICE,
    'javascript:openIGRow(''' || PRODUCT_ID || ''');' AS LINK
FROM E_PRODUCTS
WHERE upper(PRODUCT_NAME) LIKE '%' || upper(:P52_SEARCH) || '%'
or upper(PRODUCT_CODE) like '%'||upper(:P52_SEARCH)||'%'

this is the classic report code Can anyone help me to do that?

Upvotes: 0

Views: 30

Answers (1)

theoa
theoa

Reputation: 71

You could just add each selected PRODUCT_ID to some list, and base the Interactive Grid on that list. The list could be a (hidden) item containing colon seperated values, an Apex collection, or whatever else you fancy.

Upvotes: 0

Related Questions