vincentdeelen

DECLARE
   l_empno_arr    APEX_APPLICATION_GLOBAL.VC_ARR2;
BEGIN
   l_empno_arr := APEX_UTIL.STRING_TO_TABLE(:p1_empnos);
   FOR i IN 1..l_empno_arr.count
   LOOP
      update  emp
      set   sal = sal*1.1
      where empno = l_empno_arr(i);
   END LOOP;

vincentdeelen

var empNoS = $('.uReportStandard input[type=checkbox]:checked').map(
                       function() {
                                    return $(this).parent().parent().find('td[headers="EMPNO"] input').val();
                                  }
                     ).get().join(':');
$('#P1_EMPNOS').val(empNoS);

vincentdeelen

http://localhost:8080/JasperReportsIntegration/report? _repName=test&_repFormat=pdf&_dataSource=xxxxx

vincentdeelen

…&_dataSource=xxxxx&p1=<somevalue>&p2=<anothervalue>…

vincentdeelen

select *
from   emp
where  $P{p_session} in ( select apex_session_id
                          from   apex_workspace_sessions
                        )

vincentdeelen

$("#report_jobs tr > td").each(
   function() {
      $(this).addClass( "job" );
      $(this).attr("draggable","true");
      $(this).attr("ondragstart","dragJob(event)");
      var idVal = $(this).first('td').html();
      $(this).first('td').attr("id",idVal);
   }
)

vincentdeelen

ondrop="dropJob(event)" ondragenter="return false" ondragover="return false"

vincentdeelen

function dragJob(ev) {
  ev.dataTransfer.setData("Job", ev.target.id);
}

vincentdeelen

function dropJob(ev) {
   var data=ev.dataTransfer.getData("Job");
   ev.target.value = document.getElementById(data).innerHTML;
}

vincentdeelen

<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
<script>
$(function() {
  $( ".job" ).draggable({
    appendTo: "body",
    helper: "clone"
  });
  
  $( "#P8_JOB" ).droppable({