Skip to Main Content

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!

Update row sequence in database with up and down arrow key on a tabular form

PromeetOct 8 2014

hey Apex Gurus

I am using APEX 4.2.0.00.27. I have created a tabular form (declarative and not manually using collections) on a table and have added Up/down arrows using JavaScript in the Report Template.

I want to update a column(Alternate Priority) in the database when the user moves the up/down arrow.

Using the Up/down arrow i am able to move rows within the Div table of the report but i would like to update the database when the user moves rows up or down

palletsetupstackpallet.JPG

The Up/Down arrow is displayed using the below JavaScript in the Report Template After rows sections

</tbody>

</table>

<script src="/i/libraries/apex/minified/builder.min.js" type="text/javascript"></script>

<script type="text/javascript">

var g_rpreview_global = 'report_#REGION_ID#_sortable';

var g_#REGION_ID#_sortable;

function f_#REGION_ID#_sortable(){

**_g\_#REGION\_ID#\_sortable = new apex.tabular.sort(g\_rpreview\_global);_**

**_g\_#REGION\_ID#\_sortable.row.after\_move = function(){rpreview()};_**

}

addLoadEvent(f_#REGION_ID#_sortable);

</script>

</td>

</tr>

</tbody>

<tbody class="uReportPagination">

#PAGINATION#

</tbody>

</table>

<div class="uReportDownloadLinks">#EXTERNAL_LINK##CSV_LINK#</div>

Question Do i need to add something to the JavaScript to change the value on the Alternate Priority item and then submit a page process to update the table or should i build the form manually and control the collection assignment?

Promeet Ganguly

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2014
Added on Oct 8 2014
0 comments
743 views