Hi there,
I'm trying to implement a dynamic action on an interactive report that fires an pl/sql procedure and then reload the IR.
I have something like this:
select par.*,
CASE
WHEN (SELECT 1 FROM addressbook ch WHERE ch.usr_id = (select id from usr where email = :APP_USER) AND ch.address_id = par.id) IS NOT NULL
THEN '<img src="#IMAGE_PREFIX#wwv_cancel.gif" alt"Y" class="delAddressFromBook" id="'|| par.id || '"/>'
ELSE '<img src="#IMAGE_PREFIX#add.gif" alt="N" class="addAddressToBook" id="'|| par.id ||'" />'
END mapped
from addresslist par
My dynamic action uses the jquery selector ".addAddressToBook" and it fires correctly the first time I click on an add-image. My pl/sql-code runs correctly and the IR ist refreshed.
Problem is, when I click the second time in another entry nothing happens. Seems like the javascript is still running something.
Refresh of the IR ist done with javascript gReport.pull().
Thanks in advance.
Florian