-
1. Re: Dynamically create region
Kiran Pawar Jun 23, 2015 11:38 AM (in response to Ketan Madhak)1 person found this helpfulHi Ketan,
Ketan Madhak wrote:
I want to create region for each resulting row of select query on same page. Is it possible to create region dynamically for each row like that? i am using APEX 5.0,theme 25.
Use the region type "PL/SQL Dynamic Content".
Refer :
- Dynamic HTML Generated From PL/SQL Tutorial – APEX Blog
- plsql - Can you dynamically generate regions in Oracle APEX using PL/SQL? - Stack Overflow
- The Oracle APEX blog: Dynamically showing reports side by side
Hope this helps!
Regards,
Kiran
-
2. Re: Dynamically create region
fac586 Jun 23, 2015 1:47 PM (in response to Ketan Madhak)Ketan Madhak wrote:
I want to create region for each resulting row of select query on same page. Is it possible to create region dynamically for each row like that? i am using APEX 5.0,theme 25.
Why?
What type of region?
See Dynamic number of report regions for examples of creating multiple "report regions" using a custom report template.
-
3. Re: Dynamically create region
Ketan Madhak Jun 24, 2015 4:28 AM (in response to fac586)No it isn't a report region.In my case a user have a one or more addresses in address table.I want to display each address in different region.
-
4. Re: Dynamically create region
Kiran Pawar Jun 24, 2015 4:35 AM (in response to Ketan Madhak)Hi Ketan,
Ketan Madhak wrote:
No it isn't a report region.In my case a user have a one or more addresses in address table.I want to display each address in different region.
Then you can use the "PL/SQL Dynamic Content" region type to achieve what you want. See my reply above.
Regards,
Kiran
-
5. Re: Dynamically create region
fac586 Jun 26, 2015 10:39 AM (in response to Ketan Madhak)1 person found this helpfulKetan Madhak wrote:
No it isn't a report region.In my case a user have a one or more addresses in address table.I want to display each address in different region.
If you really mean "display" (rather than "insert", "edit", or some combination thereof), then a report is the appropriate APEX solution. An APEX report is not a grid of rows and columns (which may be your only experience of them so far). It is a means of rendering the results of a SQL query as content in an HTML document. As a developer you are responsible for determining what structure and semantics is appropriate to that data, and converting that into the necessary HTML mark-up. In many cases a table of rows and columns is appropriate, and the report can be implemented using a built-in interactive report or classic report with a standard template. Where those do not meet the requirements, then a classic report with a custom template is used. These give the developer complete control over the report mark-up, enabling highly flexible and diverse layouts to be created. Here are some examples created as solutions to previous forum posts:
- Tabular report with subheadings (Issue with break formatting in Apex Classic Report with the third column.)
- Image with text overlay (is there a way to add text to the image automatically; CSS figcaption elements- not working)
- Multi-column list (Show Report In Two Columns)
- Dynamic matrix (Matrix report)
- Multiple dynamic report "regions" (Dynamic number of report regions)
These are all "reports", generating different HTML structures using custom templates, with different presentations achieved using CSS. They demonstrate that reports are the best way to display read-only information in APEX. (Reports can be used to generate complex forms, but this will usually require custom processing to be developed to handle the submitted data. It's generally therefore better to use the standard APEX "form on a table with report" design pattern, customising the report to meet any complex layout requirements, and utilise default APEX forms for data entry and maintenance. This is particularly effective in APEX 5.0 where the form page can be created as a pop-up dialog with no extra effort.)
Provide detailed requirements, then we can decide if the solution is a report or something else.