Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select All Region

jwellsnhSep 3 2013 — edited Sep 4 2013

Looking for a solution to select all rows of a report region.  The region will contain a list of email addresses.  Have tried implementing this functionality via a dynamic action triggered by a button.  A demo of my latest attempt can be viewed at http://apex.oracle.com/pls/apex/f?p=57067:1

Dynamic Action is defined as follows:

Event: Click

Selection Type: Button

True Action:

Action: Execute JavaScript Code

Fire When Event Result Is: True

Fire On Page Load: Unchecked

Selection Type: Region

Code: document.getElementById('TEXT').select();

TEXT is the Static ID of the Region.

Jeff

Comments

Gaz in Oz

You could use XMLQUERY()

Paulzip
Answer

I could easily do this for you, but you won't learn anything.  However, here's a good article on how to go about it.

Marked as Answer by muttleychess · Sep 27 2020
muttleychess

wonderful !!

It seems the same example

Only I would like to know how to get the version of XML

xml version="1.0" encoding="UTF-8" standalone="yes

mNem

something like ...

select 

'<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'

||

xmlserialize(document ... as clob indent) as xml_output

....

Paulzip

muttleychess wrote:

wonderful !!

It seems the same example

Only I would like to know how to get the version of XML

xml version="1.0" encoding="UTF-8" standalone="yes

The prolog is added (and only needed) if you serialise the data to a BLOB.  It's simply for the consumer's sake so they know how to decode the BLOB into character data.  If you are serialising into a CLOB, you don't need it, however if you really want to, use mNem's concat approach.

report error:
Oops, something went wrong!  We've notified our team to take a look. Please try again later. (Reference 300000.25.201.31548).
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 2 2013
Added on Sep 3 2013
16 comments
492 views