{"id":9654,"date":"2020-01-07T16:32:09","date_gmt":"2020-01-07T22:32:09","guid":{"rendered":"https:\/\/traust.com\/?p=9654"},"modified":"2021-06-15T17:42:11","modified_gmt":"2021-06-15T22:42:11","slug":"create-dynamic-links-for-interactive-reports-in-oracle-apex","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/","title":{"rendered":"Create Dynamic Links for Interactive Reports in Oracle APEX"},"content":{"rendered":"<p>For the moment, Dynamic Actions aren\u2019t directly integrated with Interactive Reports or Interactive Grids.\u00a0 That can be problematic when you want to display dynamic content that will:<\/p>\n<ol>\n<li>Hide\/Show depending on the value<\/li>\n<li>Do something when selected<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-9655 size-full aligncenter\" src=\"https:\/\/traust.com\/wp-content\/uploads\/2020\/01\/Image-1-End-Product.png\" alt=\"\" width=\"716\" height=\"504\" srcset=\"https:\/\/traust.com\/wp-content\/uploads\/2020\/01\/Image-1-End-Product.png 716w, https:\/\/traust.com\/wp-content\/uploads\/2020\/01\/Image-1-End-Product-300x211.png 300w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/p>\n<p>For this blog, I will walk you through the example of managing subscriptions.\u00a0 The goal is to display an unsubscribe button if a person already has a subscription.\u00a0 If they don\u2019t have one, the user needs to see a subscribe button.<\/p>\n<pre><code class=\"language-sql\">\r\nTable Structure:\r\n\r\npersonal_info\r\n    personal_info_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0PK\r\n\r\npublication_info\r\n    publication_info_id\u00a0\u00a0\u00a0\u00a0PK\r\n    publication_category\r\n    publication_name\r\n\r\nsubscription_info\r\n    subscription_id        PK\r\n    publication_info_id\u00a0\u00a0\u00a0\u00a0FK\r\n    personal_info_id\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FK\r\n    subscription_type\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h2>Add a Hidden Item to your Page<\/h2>\n<ul>\n<li>Name the hidden item: IR_PUB_VALUE<\/li>\n<\/ul>\n<h2>Add an Interactive Report to your page<\/h2>\n<ul>\n<li>Use the code below for the SQL query:<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">\r\nSELECT\r\n    CASE\r\n        WHEN SUBSCRIPTION_INFO.PUBLICATION_INFO_ID is null then\r\n        '&lt;a href=\"'||APEX_UTIL.PREPARE_URL('javascript:void(0)')\r\n        ||'\"data-id='||PUBLICATION_INFO.PUBLICATION_INFO_ID||'&gt; \r\n        &lt;span class=\"t-Button t-Button--simple t-Button--hot t-Button--stretch subscribe-action\"&gt;\r\n        Subscribe&lt;\/span&gt;&lt;\/a&gt;' end as \"Subscribe\", \r\n\r\n    CASE\r\n        WHEN SUBSCRIPTION_INFO.PUBLICATION_INFO_ID is not null then \r\n        '&lt;a href=\"'||APEX_UTIL.PREPARE_URL('javascript:void(0)')\r\n        ||'\"data-id='||PUBLICATION_INFO.PUBLICATION_INFO_ID||'&gt;\r\n        &lt;span class=\"t-Button t-Button--simple t-Button--hot t-Button--stretch unsubscribe-action\"&gt;\r\n        Unsubscribe&lt;\/span&gt;&lt;\/a&gt;' end as \"Unsubscribe\",\r\n\r\n    PUBLICATION_INFO.PUBLICATION_CATEGORY, \r\n    PUBLICATION_INFO.PUBLICATION_NAME \r\n\r\nFROM PUBLICATION_INFO\r\n    LEFT JOIN SUBSCRIPTION_INFO\r\n        ON PUBLICATION_INFO.PUBLICATION_INFO_ID = SUBSCRIPTION_INFO.PUBLICATION_INFO_ID\r\n    LEFT JOIN PERSONAL_INFO\r\n        ON PERSONAL_INFO.PERSONAL_INFO_ID = SUBSCRIPTION_INFO.PERSONAL_INFO_ID \r\n\r\nORDER BY PUBLICATION_INFO.PUBLICATION_INFO_ID\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<h2>Quick Code Breakdown<\/h2>\n<pre><code class=\"language-sql\">\r\nAPEX_UTIL.PREPARE_URL('javascript:void(0)')\r\n<\/code><\/pre>\n<ul>\n<li>Once the link is clicked, execute this JavaScript\n<ul>\n<li>This JavaScript does nothing by itself, but we can use it to trigger a Dynamic Action<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">\r\ndata-id='||PUBLICATION_INFO.PUBLICATION_INFO_ID||'\r\n<\/code><\/pre>\n<ul>\n<li>The links in the Interactive Report will have the row value of the primary key from the PUBLICATION_INFO table (PUBLICATION_INFO_ID)<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">\r\n&lt;span class=\"t-Button t-Button--simple t-Button--hot t-Button--stretch\r\nsubscribe-action\"&gt; Subscribe&lt;\/span&gt;\r\n<\/code><\/pre>\n<ul>\n<li>This makes the link look like a button<\/li>\n<li>Subscribe-action within the span tags is just an identifier that I assigned. We will reference it when we create a Dynamic Action<\/li>\n<\/ul>\n<h2>Apply Some Interactive Report Modifications in Page Designer<\/h2>\n<ul>\n<li>Under the Attributes section of the Interactive Report, select Exclude Link Column in the Link section<\/li>\n<li>Select the Subscribe column in your Interactive Report and disable Escape special characters in the Security section\n<ul>\n<li>Do the same with the Unsubscribe column<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>Create a New Dynamic Action<\/h2>\n<ul>\n<li>Call it something like \u201cSubscribe Dynamic Action\u201d\n<ul>\n<li>I can\u2019t believe my art teacher in elementary school questioned my creativeness<\/li>\n<\/ul>\n<\/li>\n<li>Choose a Click event<\/li>\n<li>Make the Selection Type a jQuery Selector<\/li>\n<li>For the jQuery Selector, make it:\n<pre><code class=\"language-sql\">\r\n.subscribe-action\r\n<\/code><\/pre>\n<ul>\n<li style=\"list-style-type: disc;\">The period at the front of subscribe-action is not a typo<\/li>\n<li style=\"list-style-type: disc;\">.subscribe-action can be found within the span tags of the SQL query for the Interactive Report. If you renamed it something else, remember to change it accordingly<\/li>\n<\/ul>\n<\/li>\n<li>Change the Event Scope to Dynamic<\/li>\n<\/ul>\n<h2>Create True Actions for the Dynamic Action<\/h2>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Create a Set Value True Action<\/li>\n<li>For the Set Type, Choose JavaScript Expression. Add this code:<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code class=\"language-sql\">\r\n$(this.triggeringElement).parent().data('id')\r\n<\/code><\/pre>\n<ul>\n<li>Under the Affected Elements section, change the Selection Type to Item(s)<\/li>\n<li>Choose the hidden page item you created earlier (IR_PUB_VALUE)<\/li>\n<\/ul>\n<h2>Give it a Test<\/h2>\n<ul>\n<li>Change the hidden item (IR_PUB_VALUE) to a regular text field to see if it is working properly<\/li>\n<li>When you change the page item back to a hidden item, remember that you will run into errors if you plan on manipulating the value, unless you turn Value Protected off under the Settings section on the hidden page item<\/li>\n<\/ul>\n<h2>Expand the Code<\/h2>\n<ul>\n<li>Now that you can display dynamic links and grab the row value, you can add True Actions to the dynamic action to run PL\/SQL in order to run insert\/update\/delete statements or whatever you are trying to do<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Learn More<\/h3>\n<ul>\n<li>You can learn more helpful tips like the ones above by visiting the <a href=\"https:\/\/traust.com\/blog\/\">Traust Consulting Blog<\/a>.<\/li>\n<\/ul>\n<h3>References<\/h3>\n<ul>\n<li><a href=\"https:\/\/jackiemcilroy.blogspot.com\/2018\/03\/delete-row-of-report-with-dynamic-action.html\">https:\/\/jackiemcilroy.blogspot.com\/2018\/03\/delete-row-of-report-with-dynamic-action.html<\/a><\/li>\n<li><a href=\"http:\/\/www.grassroots-oracle.com\/2015\/12\/tutorial-include-action-button-in-report.html\">http:\/\/www.grassroots-oracle.com\/2015\/12\/tutorial-include-action-button-in-report.html<\/a><\/li>\n<li><a href=\"https:\/\/stackoverflow.com\/questions\/28299582\/oracle-apex-interactive-report-conditional-column-link-display#28300786\">https:\/\/stackoverflow.com\/questions\/28299582\/oracle-apex-interactive-report-conditional-column-link-display#28300786<\/a><\/li>\n<\/ul>\n<h3>Requirements<\/h3>\n<ul>\n<li>APEX 5x or higher<\/li>\n<\/ul>\n<p><em>Disclaimer:<\/em><br \/>\n<em>We do not take responsibility for any unintended or unwanted consequences in your instance of Oracle, Oracle APEX, or related products as a result of reading our blogs or following our guides.\u00a0 Though the information is fully tested and generally safe to use, our lawyers really have a thing against admitting potential wrongdoing.\u00a0 If it makes you feel any better, one time they asked me to put the trash cans outside for pickup.\u00a0 I know that the city dictates that they have to be a least 4 feet apart, but I put them 3.5 feet apart.\u00a0 I\u2019ve been checking the mail every day and can\u2019t wait for the fine to arrive.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For the moment, Dynamic Actions aren\u2019t directly integrated with Interactive Reports or Interactive Grids.\u00a0 That can be problematic when you want to display dynamic content that will: Hide\/Show depending on&#8230;<\/p>\n","protected":false},"author":17,"featured_media":7363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[50,35,53,52],"tags":[],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create Dynamic Links for Interactive Reports in Oracle APEX - Traust<\/title>\n<meta name=\"description\" content=\"Traust&#039;s Andrew Schultz shows how to integrate Dynamic Links for interactive reports and interactive grids within Oracle APEX.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create Dynamic Links for Interactive Reports in Oracle APEX - Traust\" \/>\n<meta property=\"og:description\" content=\"Traust&#039;s Andrew Schultz shows how to integrate Dynamic Links for interactive reports and interactive grids within Oracle APEX.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\" \/>\n<meta property=\"og:site_name\" content=\"Traust\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-07T22:32:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-15T22:42:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andrew Schultz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@TraustConsult\" \/>\n<meta name=\"twitter:site\" content=\"@TraustConsult\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrew Schultz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\"},\"author\":{\"name\":\"Andrew Schultz\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628\"},\"headline\":\"Create Dynamic Links for Interactive Reports in Oracle APEX\",\"datePublished\":\"2020-01-07T22:32:09+00:00\",\"dateModified\":\"2021-06-15T22:42:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\"},\"wordCount\":640,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/traust.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg\",\"articleSection\":[\"APEX\",\"IT\",\"Oracle\",\"Technical\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\",\"url\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\",\"name\":\"Create Dynamic Links for Interactive Reports in Oracle APEX - Traust\",\"isPartOf\":{\"@id\":\"https:\/\/traust.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg\",\"datePublished\":\"2020-01-07T22:32:09+00:00\",\"dateModified\":\"2021-06-15T22:42:11+00:00\",\"description\":\"Traust's Andrew Schultz shows how to integrate Dynamic Links for interactive reports and interactive grids within Oracle APEX.\",\"breadcrumb\":{\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage\",\"url\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg\",\"contentUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg\",\"width\":1536,\"height\":1024,\"caption\":\"traust twin cities round table meeting\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/traust.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create Dynamic Links for Interactive Reports in Oracle APEX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/traust.com\/#website\",\"url\":\"https:\/\/traust.com\/\",\"name\":\"Traust Consulting\",\"description\":\"Enterprise Solutions. Tailored to Work.\",\"publisher\":{\"@id\":\"https:\/\/traust.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/traust.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/traust.com\/#organization\",\"name\":\"Traust\",\"url\":\"https:\/\/traust.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png\",\"contentUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png\",\"width\":200,\"height\":200,\"caption\":\"Traust\"},\"image\":{\"@id\":\"https:\/\/traust.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/TraustConsult\",\"https:\/\/www.linkedin.com\/company\/traust-consulting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628\",\"name\":\"Andrew Schultz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g\",\"caption\":\"Andrew Schultz\"},\"description\":\"Andrew is a Senior Oracle Application Express (APEX) developer with more than 10 years of experience leading projects from inception to completion. He has built and maintained more than 750 Oracle APEX forms and reports. His prior work as a technical writer and client educator has uniquely prepared Andrew to identify the needs of a task from the perspectives of the organization, programmer, client, and end-user.\",\"url\":\"https:\/\/traust.com\/blog\/author\/aschultz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create Dynamic Links for Interactive Reports in Oracle APEX - Traust","description":"Traust's Andrew Schultz shows how to integrate Dynamic Links for interactive reports and interactive grids within Oracle APEX.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/","og_locale":"en_US","og_type":"article","og_title":"Create Dynamic Links for Interactive Reports in Oracle APEX - Traust","og_description":"Traust's Andrew Schultz shows how to integrate Dynamic Links for interactive reports and interactive grids within Oracle APEX.","og_url":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/","og_site_name":"Traust","article_published_time":"2020-01-07T22:32:09+00:00","article_modified_time":"2021-06-15T22:42:11+00:00","og_image":[{"width":1536,"height":1024,"url":"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg","type":"image\/jpeg"}],"author":"Andrew Schultz","twitter_card":"summary_large_image","twitter_creator":"@TraustConsult","twitter_site":"@TraustConsult","twitter_misc":{"Written by":"Andrew Schultz","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#article","isPartOf":{"@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/"},"author":{"name":"Andrew Schultz","@id":"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628"},"headline":"Create Dynamic Links for Interactive Reports in Oracle APEX","datePublished":"2020-01-07T22:32:09+00:00","dateModified":"2021-06-15T22:42:11+00:00","mainEntityOfPage":{"@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/"},"wordCount":640,"commentCount":1,"publisher":{"@id":"https:\/\/traust.com\/#organization"},"image":{"@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage"},"thumbnailUrl":"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg","articleSection":["APEX","IT","Oracle","Technical"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/","url":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/","name":"Create Dynamic Links for Interactive Reports in Oracle APEX - Traust","isPartOf":{"@id":"https:\/\/traust.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage"},"image":{"@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage"},"thumbnailUrl":"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg","datePublished":"2020-01-07T22:32:09+00:00","dateModified":"2021-06-15T22:42:11+00:00","description":"Traust's Andrew Schultz shows how to integrate Dynamic Links for interactive reports and interactive grids within Oracle APEX.","breadcrumb":{"@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#primaryimage","url":"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg","contentUrl":"https:\/\/traust.com\/wp-content\/uploads\/2016\/06\/IMG_6957-Copy-jpg.jpg","width":1536,"height":1024,"caption":"traust twin cities round table meeting"},{"@type":"BreadcrumbList","@id":"https:\/\/traust.com\/blog\/create-dynamic-links-for-interactive-reports-in-oracle-apex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/traust.com\/"},{"@type":"ListItem","position":2,"name":"Create Dynamic Links for Interactive Reports in Oracle APEX"}]},{"@type":"WebSite","@id":"https:\/\/traust.com\/#website","url":"https:\/\/traust.com\/","name":"Traust Consulting","description":"Enterprise Solutions. Tailored to Work.","publisher":{"@id":"https:\/\/traust.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/traust.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/traust.com\/#organization","name":"Traust","url":"https:\/\/traust.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/#\/schema\/logo\/image\/","url":"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png","contentUrl":"https:\/\/traust.com\/wp-content\/uploads\/2020\/05\/Traust-Logo-2.png","width":200,"height":200,"caption":"Traust"},"image":{"@id":"https:\/\/traust.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/TraustConsult","https:\/\/www.linkedin.com\/company\/traust-consulting\/"]},{"@type":"Person","@id":"https:\/\/traust.com\/#\/schema\/person\/e433f83ed21d5947cde6cc0067f9c628","name":"Andrew Schultz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3dc445221a43d9535221babd6bb2a1e?s=96&d=mm&r=g","caption":"Andrew Schultz"},"description":"Andrew is a Senior Oracle Application Express (APEX) developer with more than 10 years of experience leading projects from inception to completion. He has built and maintained more than 750 Oracle APEX forms and reports. His prior work as a technical writer and client educator has uniquely prepared Andrew to identify the needs of a task from the perspectives of the organization, programmer, client, and end-user.","url":"https:\/\/traust.com\/blog\/author\/aschultz\/"}]}},"_links":{"self":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts\/9654"}],"collection":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/comments?post=9654"}],"version-history":[{"count":0,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts\/9654\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/media\/7363"}],"wp:attachment":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/media?parent=9654"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/categories?post=9654"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/tags?post=9654"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}