How do I set the #REGION_ID# from the region template?

Hello Bill,

>> but can't find the text field or way to set the #REGION_ID#.

The #REGION_ID# substitution string is being set, internally, by the APEX engine, and you can’t change it (because this value is one of the PK identified the region).

So, your options are to use #REGION_STATIC_ID#, which you can set as you need, or the original #REGION_ID#, and retrieve its value from the APEX dictionary.

>> Because you have to use a modified template don't you?

Yes. You need to substitute #REGIN_ID# with #REGIN_STATIC_ID#. The APEX engine is smart enough to substitute this string with the original region id, if you didn’t provide a value for the static id (which means you have backward compatibility for regions without static id).

>> But APEX puts another table within this "Region" table so this ID is accessing the wrong table.

I don’t know thr theme you are working with, but as far as I know, if you modifying the template, the static id will replace the original id, and not on top of it.

The normal Reports Region that I use has #REGION_ID#as a normal ID just don't know how to access it..

If, for any reason, you want to continue using the original region id, you can retrieve it from the APEX dictionary. You can use similar code to the following:

Select region_id
from APEX_APPLICATION_PAGE_REGIONS
where application_id=:APP_ID
and page_id=:APP_PAGE_ID
and region_name=<<region name>>

Regards,
Arie.