APEX

Hi Everyone,

I am using apex 4.2. I am proficient in sql/plus and very very very new to jQuery and javascript.

I have created a tabular form based on a view (landings_collection_view) which looks at a collection 'SPECIES_COLLECTION'.

I am able to update/add/delete to my tabular form using dynamic actions.

I am now trying to hide/show several columns based on the value of a CHECKBOX column and wondering the best way to do it.

Currently I have:

2 page items:
P113_ID
P113_VALUE

Dynamic action called CHANGE COLUMN:
event: CHANGE
selection type: jQUERY Selector
jQuery:
jQuery Select = select[name'f08'],select[name='f09'],input[name='f10'],input[name='f11'],input[name='f12'],select[name='f40'],input[name='f21'],input[name='f22'],input[name='f23'],input[name='f50']

event scope: Dynamic

true action#1: set value P113_ID javascript expression this.triggeringElement.id
true action#2: set value P113_VALUE javascript expression this.triggeringElement.value
true action#3: execute pl/sql code

declare

  v_member number;
  v_seq number;

begin 
  v_member := TO_NUMBER (SUBSTR (:p113_id, 2, 2));
  select ltrim(substr(:p113_ID,5,4),'0') into v_seq from dual;

  safis_collections.update_column(v_seq,
                                v_member,
                                :p113_value);
end;

true ation#4 refresh region :LANDINGS_COLLECTION

the tabular form is based on the query:

select 
NULL del_link, 
v.seq_id, 
v.seq_id seq_id_display,
s.common_name||'-'||m.market_desc||'-'||g.grade_desc||'-'||u.unit_desc species,
v.LANDING_SEQ,
v.SPECIES_ITIS,
v.GRADE_CODE,
v.MARKET_CODE,
v.UNIT_MEASURE,
v.DISPOSITION_CODE,
v.GEAR_CODE,
v.REPORTED_QUANTITY,
v.PRICE,
v.DOLLARS,
v.AREA_CODE_FLAG,
v.C014,
v.ADDITIONAL_MEASURE_FLAG,
v.ADDNL_REPORTED_QUANTITY,
v.ADDNL_UNIT_QUANTITY,
v.AREA_FISHED,
v.SUB_AREA_FISHED,
v.LOCAL_AREA_CODE,
v.FINS_FLAG,
v.FINSATTACHED,
v.FINSNOTATTACHED,
v.FINSUNKNOWN,
v.FINS_CODE,
v.EXPLANATION,
v.NATURE_OF_SALE,
v.HMS_AREA_CODE,
v.SALE_PRICE,
v.HMS_FLAG
from  LANDINGS_COLLECTION_VIEW v, 
      species s, 
      market_categories m, 
      grade_categories g, 
      units_of_measure u
where v.species_itis = s.species_itis and 
      v.market_code = m.market_code and 
      v.grade_code = g.grade_code and
      v.unit_measure = u.unit_measure

Fields F21, F22, F23 correspond to the simple checkbox fields FINSATTACHED, FINSNOTATTACHED, FINSUNKNOWN. The tabular form deals with fisheries management, specifically highly migratory species such as TUNA or SHARK.

my requirements on this tabular form are:
1. If a user checks FINSATTACHED, I need to set FINSATTACHED = Y and FINSNOTATTACHED and FINSUNKNOW both equal to null.
2. if a user checks FINSATTACHED, I need to display the field HMS_AREA (field f40). If FINSNOTATTACHED or FINSUNKNOW is checked, then I must hide HMS_AREA


I have a couple of issues that I am struggling with:

1. how can I save a 'Y' or null value in FINSATTACHED? as this is a view, I cannot use the select apex_item.checkbox....so I am unclear on how to set up the checked/unchecked data.
2. can I hide one field of a tabular form? for example hide HMS_AREA if FINSUNATTACHED or FINSUNKNOW is set to YES in row one...but show HMS AREA in row 2 if FINSATTACHED = YES?


thank you!

Karen