Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

APEX 5.1 Interactive Grid Single Row View Issues

Matt MulvaneyJan 23 2017 — edited Mar 29 2017

Hi Team,

I'm entering Single Row View by clicking the "Row Actions" button against a record in Interactive Grid, and selecting the Single Row View option.

Once in Single Row View; Clicking on the "Settings Menu" and...

...Clicking Exclude Null Values: doesn't exclude a column I have which contains a Null value

...Clicking Displayed Columns: I'm not sure what this should do, I have hidden columns on the IG but these are neither shown or hidden using this option.

If I click "Add Row" from this view, it adds a border design to the first column. The Row is actually being added in the "Report View" but I would have thought APEX would present the new record for edit in Single Row View.

Similarly, "Duplicate row", duplicates the row in "Report Mode" only, rather than being presented in Single Row View.

In case of both the above, the Single Row View pagination is not automatically updated until I navigate back/forth through the records

All the best - Matt

Comments

thatJeffSmith-Oracle

We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :(

Stay tuned…

Carl Singer

Is there a way to add a “hook” to launch into SQLcl as is done in SQL Dev or is that a future thing?

thatJeffSmith-Oracle

Sorry, not sure I understand what you mean. Can you describe in more detail what you're looking for?

Paavo

How about running sqlcl local installation in vscode Terminal window and

1.) while editing the file - select the code and use “Terminal: Run Selected Text in Active Terminal”

SQL> script
  2   ctx.write("Hello World !\n");
  3* /
Hello World !
SQL>

2.) or use the e-trick:

SQL> e hello_world.js

SQL best practice warning (2,1): G-1030: Avoid defining variables that are not used 

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.283
Elapsed: 00:00:00.052
  1  script
  2*  ctx.write("Hello World !\n");
SQL> @hello_world.js 
Hello World !
Elapsed: 00:00:00.115
1 person found this helpful
Philipp Salvisberg

We're using Java 21, and it's not straightforward to add the javascript engine support for MLE Java 21 :(

Stay tuned…

IMO integrating the GraalVM scripting engine should be straightforward (I've done that for other projects). Libs compatible with Java 21 are available on Maven Central. It's sad, that in version 23.3.0 the integrated SQLcl still does not support the script command.

Any estimates on when we can expect support for the script command in the integrated version of SQLcl of SQL Developer for VS Code?

1 person found this helpful
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 26 2017
Added on Jan 23 2017
#apex-discussions
2 comments
4,451 views