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!

Determining Checkbox value if Checked or unchecked.

User_E9GZJFeb 7 2017 — edited Feb 7 2017

I have created a IR report with checkbox with the following query statement in APEX 5

SELECT

APEX_ITEM.CHECKBOX2(

p_idx => 1,

p_value => TRAVELFORCAST.ID_NUM,

P_attributes => 'class="ID_NUM"',

p_checked_values => :P14_SELECTLIST,

P_checked_values_delimiter =>',') "SELECT",

TRAVELFORCAST.ID_NUM AS "TRAVEL NUMBER",

TRAVELFORCAST.LASTNAME||', '||TRAVELFORCAST.FIRSTNAME AS "EMPLOYEE",

TRAVELFORCAST.TRAVEL_DEPT AS "DEPARTMENT",

TRAVELFORCAST.TRIP_NAME AS "TRIP DESCRIPTION",

FROM ........

I need to determine which checkbox have been checked to process the travel request for example to approve them. I was hoping there was a way in PL/SQL or javascript. I do appreciate any help at this matter.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2017

Added on Feb 7 2017

#apex-discussions

1 comment

623 views