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?

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?

• oracle-apex

• OK, but - why don't you perform search directly in the Interactive Grid? What benefit do you see in moving data around, from one region to another? – Littlefoot Commented Feb 17 at 7:53
• This is a page for casher. when the casher read the barcode searching for this item. when it found this item must be the item pushed to the grid. when more than one item when he searches with name as example every row mast has a link column. when he clicked on it this row be pushed to grid. he must can push more than one item to the grid – Retal Omar Commented Feb 17 at 9:32

1 Answer 1

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.