Wow, I must be life in a cave. Trying to learn many programming language "just to have" application based on my company data (and fail, ) as a non programming guys in manufacturing environment. Yes! finally find this video. Love at first sight at APEX oracle. Thank you very much!
What is the best way to draw an Application Architecture for an Oracle APEX application? Is there a diagram or a reference point which could help to get started?
can somebody help/guide, in 19.2 (current ver) how I can implement 2 things, in IG I want to have a button or link in every row to open a Modal Dialog ( keep in mind, a blank row should have a working button / link ) and from that Modal Dialog - Interactive Report user will click on a row and that row should return 3 columns to populate calling IG row 3 columns. This is just like an LOV in Oracle Forms which return multiple columns. Apex popup LOV currently (even in 19.2) natively can't return multiple columns values.
1 - Just create a fake column in your SQL to call the modal dialog page like this: 'Call Modal Page' 2 - SET "Escape special characters" to "No" for the fake column 3 - Create a dynamic action for your grid with event "Dialog Closed" and chose your grid region and in action put Refresh for the same region 4 - Use another dynamic action for the interactive report you want to return the data and after update the IG table set a new action to close modal
thanks @@brumasoficial , it has been done without any JS/HTML/CSS 0r Dynamic Action 0etc. it is easy n simple. create a List of Values in Shared Component with Additional Display Columns (scroll down), in fake/dummy column' s property (column Type of PopUp LOV) here in Settings -> Additional Outputs add columns which you wants to "return" ( colum name+a colon :+ page item / column name from popup lov like: LOVCOUNTRYID:PAGECOUNTRYID ), don't forget (like me) to have static id set in Advanced of each column/page item and use this Static ID for Additional Output column/page item name. hope this will help others too.
He seems very keen on the Page Designer but unfortunately the page designer is very clunky and so difficult to arrange items with the column system. There really is no freedom to truly customize positioning. A modern true drop and drag to exact position of elements would be very welcome. Navigation through items as well as the window for editing queries isn't great. It seemed far better in earlier versions. The aesthetics are very lacking. The layout really has little to be desired. The underlying system works well but it really could use a total interface overhaul.
How he talks is just amazing! Wish I had a professor like you in the Uni!
Wow, I must be life in a cave. Trying to learn many programming language "just to have" application based on my company data (and fail, ) as a non programming guys in manufacturing environment.
Yes! finally find this video. Love at first sight at APEX oracle. Thank you very much!
What is the best way to draw an Application Architecture for an Oracle APEX application? Is there a diagram or a reference point which could help to get started?
Many thanks for your excellent overview
Is the keyboard Turkish? Have seen that ü ö etc. Just I wondered
nice
can somebody help/guide, in 19.2 (current ver) how I can implement 2 things, in IG I want to have a button or link in every row to open a Modal Dialog ( keep in mind, a blank row should have a working button / link ) and from that Modal Dialog - Interactive Report user will click on a row and that row should return 3 columns to populate calling IG row 3 columns. This is just like an LOV in Oracle Forms which return multiple columns. Apex popup LOV currently (even in 19.2) natively can't return multiple columns values.
1 - Just create a fake column in your SQL to call the modal dialog page like this:
'Call Modal Page'
2 - SET "Escape special characters" to "No" for the fake column
3 - Create a dynamic action for your grid with event "Dialog Closed" and chose your grid region and in action put Refresh for the same region
4 - Use another dynamic action for the interactive report you want to return the data and after update the IG table set a new action to close modal
thanks @@brumasoficial , it has been done without any JS/HTML/CSS 0r Dynamic Action 0etc. it is easy n simple. create a List of Values in Shared Component with Additional Display Columns (scroll down), in fake/dummy column' s property (column Type of PopUp LOV) here in Settings -> Additional Outputs add columns which you wants to "return" ( colum name+a colon :+ page item / column name from popup lov like: LOVCOUNTRYID:PAGECOUNTRYID ), don't forget (like me) to have static id set in Advanced of each column/page item and use this Static ID for Additional Output column/page item name. hope this will help others too.
Great presentation... right?
can anybody help in APEX 20.1 ? How I can change Application Logo Text Dynamically (from table )... Thanks in advance
I love you!
He seems very keen on the Page Designer but unfortunately the page designer is very clunky and so difficult to arrange items with the column system. There really is no freedom to truly customize positioning. A modern true drop and drag to exact position of elements would be very welcome. Navigation through items as well as the window for editing queries isn't great. It seemed far better in earlier versions. The aesthetics are very lacking. The layout really has little to be desired. The underlying system works well but it really could use a total interface overhaul.