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
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