Simon Bantle

#orclapex Team Lead @ Schwarz IT KG
Building solutions for Schwarz Group (LIDL, Kaufland, Schwarz DL)

opinions are my own

[Simon Bantle @simonbantle]

@moreaux_louis @nikola_canadi @orclapexworld I think this idea was already there: https://t.co/pMiNTcvnSr @JaysonHanes any chance to get this reopened for voting?

[Simon Bantle @simonbantle]

@beckerman_maik can be added with PL/SQL API quite easily APEX_UTIL.RESET_PW for reset via Mail | APEX_UTIL.RESET_PASSWORD for direct password changes
https://t.co/gfdDCMLChK

[Simon Bantle @simonbantle]

@JonDixonUS not sure about PAGE_VIEW_MODE "C" and "A", D should be "Dynamic" and P most likely "Partial Page", pasted the snippet here: https://t.co/4MK0MxGFnl

[Simon Bantle @simonbantle]

@JonDixonUS that monitoring report or almost all of them can also be rebuild with APEX views (https://t.co/tb7qAZNzdH) The one shown here is the internal WWV_FLOW_ACTIVITY_LOG which should match to APEX_WORKSPACE_ACTIVITY_LOG

[Simon Bantle @simonbantle]

@modhoo with an inline PopupLOV you can easily navigate to it with your keyboard and open the list with ↓ arrow down ↓

[Simon Bantle @simonbantle]

@Thanhtu88Tu while this works for the current APEX version there is a certain risk that IG structure is going to change in the future and this jQuery is going to fail then. I would suggest to stick with the standard way of adding buttons demonstrated in sample app "Sample Interactive Grids"

[Simon Bantle @simonbantle]

@m_raoul @HunterEndymion IG is utilizing html table for rendering. every row within that table requires its unique data-id. IG puts your PK into this data-id, so for any new row it utilizes t1001...t1002 instead

[Simon Bantle @simonbantle]

@m_raoul even with automatic IG processing everything works as expected for me with a hidden PK column

[Simon Bantle @simonbantle]

@HunterEndymion @m_raoul you shouldn't be utilizing rowid as PK. See the discussion here for more details: https://t.co/gsV1KKCiVx

[Morten Braten @mortenbraten]

TLDR; don't use ROWID

Hopefully you didn't take the shortcut, choosing "Use ROWID as key", in your APEX apps. And hopefully you have avoided composite primary keys. Turns out a single PK column with a system-generated value saves you a lot of trouble. 👈

#orclapex #plsql

[Simon Bantle @simonbantle]

@jmsivianes did you check your deep linking setting? this can be either set in Application Security or even page specific on page configuration

[Simon Bantle @simonbantle]

@_LeeBurgess_ @OracleAPEX just checked, it works with Oracle APEX 22.2.0

[Simon Bantle @simonbantle]

@JochenZehe @orclapex absolutely, in that case you would have to add a new span though as none is generated by #orclapex

Please find a working example here:
https://t.co/PIkuQKqip7

[Simon Bantle @simonbantle]

@JochenZehe @orclapex

[Simon Bantle @simonbantle]

@JochenZehe @orclapex while we don't have this declaratively you can do this pretty easily by adding an animation class to your button after clicking it and removing it once your action has completed.

[Simon Bantle @simonbantle]

@mortenbraten need to add one more to the list, since I'm really looking forward to that one:
- Name any True/False Actions within a DynamicAction (prior to APEX22.2 it showed action type as Name before, corresponding feature requests: https://t.co/h05jKNHU5G
https://t.co/A5odNEa0Hi)

[Simon Bantle @simonbantle]

@raftrevisan JET Charts doesn't like gaps for time axis. There should be 2 ways to handle this:
a) make sure to have entries for every series for each month (generate entries with value 0 if req.)
b) Chart Region -> Attr. -> Settings -> Time Axis Type change from Automatic to -> Skip Gaps

[Simon Bantle @simonbantle]

this seems to be a more common issue, since there are also 3 posts in Cloud Customer Connect regarding the same issue
https://t.co/6D93Dv2QNQ

https://t.co/iIYQJwlp9W

https://t.co/4JT4XfAeCr

@joelkallman @ASQLBarista is this a known issue for APEX in Always Free ADW?

[Simon Bantle @simonbantle]

anyone experienced a blank page before when trying to open #orclapex from Always Free Autonomous Database? Stopping and restarting does not help

[Simon Bantle @simonbantle]

@matthias_range direct links for apps/builder/workspace won't work either unfortunately. Instance was created in March, but restarted this week after inactivity.
SQL Developer Web with ADMIN or APEX Schema works fine though

[Simon Bantle @simonbantle]

@HispanoF1 @orclapexworld unfortunately not the same issue as always free autonomous db is on 19.2 and I cannot reach app builder at all, thanks though