Oracle Application Express (MOSC)

MOSC Banner

Card region doesn't work with "Page Items to Submit"

edited Nov 18, 2020 9:09PM in Oracle Application Express (MOSC) 4 commentsAnswered

In APEX 20.2.0.00.20, I created a card region as type "SQL Query" and set "Page Items to Submit" like below.

 SQL Query : select A, B, C from tbl where A=:P12_ITEM

 Page Items to Submit : P12_ITEM

I would like to refresh this card region when P12_ITEM is changed. However this doesn't work.

I checked source code related this card region and found that "itemsToSubmit" was created with wrong item name.

-------

apex.widget.templateReportRegionInit({"regionId":"3604309040534143","regionStaticId":"recent_activities","regionType":"Cards","ajaxIdentifier":"UkVHSU9OIFRZUEV-fjM2MDQzMDkwNDA1MzQxNDM~\u002FDnKlJBA2JlxokN1u5OqGaKpSaPmK6JSz916d44vz7_6f4rsZKadQEeeeIUxfSJXoHcqmQXq985zMqbcP4xNY_Q","itemsToSubmit":"#P12_ITEM,#","modelName":"recent_activities","modelOptions":{"regionId":3604309040534143,"paginationType":"progressive","pageSize":100},"pagination":{"scroll":true,"showRange":false,"firstAndLastButtons":false,"hideSinglePage":true}, ...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center