SQL & PL/SQL

Hi,

You can use html directly into to sql report query to get multiple buttons like below,

select

'<input type="button" value="Button 1">'||'<input type="button" value="Button 2">'||

from dual;

Hi Schuriik,

here is an example and a package of what you can use to render a button in a report as simple as possible.

https://thalbachdevelop.blogspot.de/2017/02/apex-rendering-button-in-report-column.html

The post from Scott was my ambition to render the button into the report.

You should also read Scott's post to understand the mechanics behind it.

If you have multiple buttons you can concatinate them into a sql query.

e.q.

Select

thdevelop_util_pkg.apex_item_button(p_item_label     => 'FIRST_BUTTON',

                              p_item_id     => 'first_button'

                             ) ||

thdevelop_util_pkg.apex_item_button(p_item_label     => 'SECOND_BUTTON',

                              p_item_id     => 'second_button'

                             );

from dual;

then you have to set on the coloumn security Escape special character to no.

Regards Tim

Hi Scott, one more question: I created 2 buttons in the SQL report with following code: "'<a data-id="#ID#" class="test t-Button" </a>Start' || ..."

Now I want to save the ID of the row in my item P1_TEST via javascript like shown in your example:  $s('P1_TEST', $(this.triggeringElement).data('id'));

But afterwards the value of P1_TEST is always "#ID#", no matter which row I click. Can you tell me how I can get the right ID?

When I create a button with link like shown in your example its working fine and I get the right ID of every row. But that way I cant create 2 buttons in 1 column.

#ID# must be the alias of a column in your report.

Check that

a) you have such a column

b) it's not conditionally hidden