pam499057 wrote:Use a jQuery attribute selector to bind a dynamic action event handler to report column cells:
I Have an apex page that display a modal window utilizing jquery. In the modal window I have a classic report with a link column that I want to capture its click event.
I was thinking I could create a dynamic action with selection type=jquery selector. Not for sure if I need to do anything on link column and do not know the syntax
for jquery selector. Would appreciate any help or direction???
and add a descendant selector to apply it to the contents of the cell, like a link:
td[headers="HIREDATE"] a // Links in cells in HIREDATE column
</tt> tags as described in the FAQ.
I created a report region with the following query:There's no alias specified for the <tt>'SELECT'</tt> column, Oracle therefore uses the column contents as a default alias. This is
Select empno, ename, 'SELECT' from emp where (ename like '%'||ltrim(rtrim(:P2_SEARCHPU))||'%' or :P2_SEARCHPU is null)
The required jQuery selector would therefore be:
However the need to escape the single quotes everywhere is a bug waiting to happen. <tt>SELECT</tt> being an Oracle reserved word means using it as any kind of identifier isn't too clever either.
APEX will use the <tt>LINK_TEXT</tt> column alias as the ID attribute of the column header, and the column cells will reference this in their <tt>headers</tt>attributes. The jQuery selector is:
select empno , ename , 'SELECT' link_text from emp where ( ename like '%'||ltrim(rtrim(:P2_SEARCHPU))||'%' or :P2_SEARCHPU is null)