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!
Hi!
SQL Developer 19.1.0.094.2042, if open package SYS.DBMS_UTILITY then Code Ouline has seen error parse .
In version Sql Developer-18.4.0-376.1900 it worked
it's the same model, only the view has changed (i think)
I don't know what element is triggering your code but I don't think this...
var trigger = $(this.triggeringElement);
var rowId = trigger.closest('tr').data('id');
...will get you what you want when you are in single record view mode
I tried this...
apex.region("theIG").widget().interactiveGrid("getViews", "grid").getActiveRecordId()
and it works if you are in edit mode...(using empno as my primary key column)
"7499"
but if you aren't in edit mode it returns nothing, so instead I tried this...
apex.region("theIG").widget().interactiveGrid("getViews", "grid").getSelectedRecords()
seeing as we are in single row view mode, it gives you the current visible row
but that's positional (same with getContextRecord()) so if someone moves a column then it may break your code, so you could get the position from...
apex.region("theIG").widget().interactiveGrid("getViews", "grid").getColumns()
there maybe something more appropriate, have a look at what is available...(change "theIG" to your static ID)
apex.region("theIG").widget().interactiveGrid("getViews", "grid")
you can then use the primary key column value to access the model as before (i think)
EDIT : and please change you username to something more recognisable than "3052157"
All your provided information were VERY helpful! All your assumptions where correct...
For other having the same problem:
- getActiveRecordId() delivers me only an ID if the record is in EDIT mode what I can't guarantee
- The user CAN switch the order of the columsn (allowed)
- Luckily getSelectedRecords([0]) provides the index (attribute 'index') in order to get the correct value in array of getColumns()
I check (again) my name but couldn't find/change it in profile.
Thanks a lot, very appreciated!
