Skip to Main Content

SQL Developer

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!

[4.2EA] Table edit not always working

Thierry PoelsOct 20 2016 — edited Oct 26 2016

Hi,

Editing tables seems to fail very often.

Issues encountered  :
- when adding columns and naming them, they sometimes get renamed back to "COLUMNx"
- when adding/editing columns added column comments sometimes get lost

best regards,

Thierry Poels

[ SQL Developer Version 4.2.0.16.260  Build 16.260.1303   on  Windows 7 ]

Comments

Keyser
Answer

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)

apex.region("theIG").widget().interactiveGrid("getViews", "grid").getActiveRecordId()

"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

pastedImage_4.png

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"

Marked as Answer by John like many others · Sep 27 2020
John like many others

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!

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 23 2016
Added on Oct 20 2016
3 comments
326 views