title: How to set a text item based on a selection list change event using a dynamic action
body: <p>I have the following select statement but unsure how to setup the dynamic action to assign the current sysdate when the user select
  an option from with the LOV. I basically want to populate automatically the "DATE_CALLED" field to sysdate when a LOV selection is
  made via a Dynamic Action.</p>
  
  <p>Trying to use the same processing from this thread that was against a checkbox but cannot seem to work out - see:</p>
  
  <p><a href="https://stackoverflow.com/questions/12038392/oracle-apex-checkbox-to-manipulate-other-values-when-checked-unchecked">Oracle ApEx Checkbox to Manipulate Other Values When Checked/Unchecked</a></p>
  
  <pre><code>select  APEX_ITEM.HIDDEN(1,change_id) ||
          APEX_ITEM.HIDDEN(2,contact_id) ||
          APEX_ITEM.SELECT_LIST_FROM_LOV(p_idx =&gt; 10,
                                         p_value =&gt; reason_id,
                                         p_lov =&gt; 'LOV_REASONS',
                                         p_attributes =&gt; 'class="lov_select"',
                                         p_show_null =&gt; 'YES',
                                         p_null_value =&gt; NULL,
                                         p_null_text =&gt; '--- Please select a reason ---') reas,
          APEX_ITEM.TEXT(p_idx =&gt; 20, 
                         p_value =&gt; TO_CHAR(date_contacted,'DD/MM/YYYY HH24:MI'),
                         p_size =&gt; 14,
                         p_attributes =&gt; 'class="date_val" readonly="readonly" style="background-color:#B0C4DE;border:1px solid #999999;"') "DATE_CALLED",
          APEX_ITEM.TEXTAREA(p_idx =&gt; 30,
                         p_value =&gt; comments,
                         p_rows =&gt; 2, 
                         p_cols =&gt; 30 ) "MPA_COMMENT"
  from  MY_TABLE
  </code></pre>
  
  <p>For the Dymanic Action, I have the following:</p>
  
  <pre><code>Dynamic action: "lov selection"
  Event: Change
  Selection Type: jQuery Selector
  jQuery Selector: .lov_select (this is the class I added to the select list from lov in the sql)
  Condition: JavaScript Expression
  Value: ****** Unsure what I need to put here ******
  </code></pre>
  
  <p>For True Action, I have the following:</p>
  
  <pre><code>True Action:
  Sequence: 10
  Action: Execute PL/SQl Code
  Fire On Page Load: No
  Code: :P1_DEF_DATE := TO_CHAR(SYSDATE,'DD/MM/YYYY HH24:MI'); and have Page Item Submitted and Returned
  
  Sequence: 20
  Action: Execute JavaScript Code
  Fire On Page Load: No
  Code: $(this.triggeringElement).closest("tr").find("td[headers='DATE_CALLED'] input").val($v('P1_DEF_DATE'));
  </code></pre>
  
  <p>This code is not working as <code>$(this.triggeringElement)</code> is not correct for a select list.</p>
  
  <p>How can I achieve what I need based on a select_list_from_lov scenario and not a checkbox?</p>