{"id":12322,"date":"2022-05-19T08:00:38","date_gmt":"2022-05-19T13:00:38","guid":{"rendered":"https:\/\/traust.com\/?p=12322"},"modified":"2022-10-05T19:27:35","modified_gmt":"2022-10-06T00:27:35","slug":"creating-a-dynamic-copyright-notice-in-public-facing-apex-applications","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/","title":{"rendered":"Creating a Dynamic Copyright Notice in Public-Facing APEX Applications"},"content":{"rendered":"

Most websites and web-based applications<\/a> are built on original intellectual property that needs to be protected using a copyright notice. Over at Love2Dev.com<\/a>, Chris Love has created a nice explainer on the importance of adding a copyright notice to your site (or app).<\/p>\n

The tl;dr of Chris\u2019s research is that while website contents are copyrighted by default, adding the notice ensures that you\u2019ve told the world who owns those rights. And while the notice by itself won\u2019t give you a lot of enforceable legal protections without other precautions, it\u2019s the first thing you really have to do.<\/p>\n

Our marketing guy Brock says that a properly formatted copyright notice can also help your sites look more professional. This is especially true if the notice is kept up-to-date. After all, nothing quite says \u201cout of business\u201d more than a copyright notice that\u2019s four years old.<\/p>\n

Unfortunately, as of version 21.1, Oracle APEX doesn\u2019t have a click-button way to produce one of these notices. Luckily, the way around this is simple, effective, and \u2014 by creating it dynamically \u2014 the date displayed will always be current.<\/p>\n

The first step is to visit your app\u2019s Global Page (0) in Page Builder. Create a new Region, and call it Copyright Notice. Leave the region\u2019s type as \u2018static content,’ and set the layout position to \u2018footer.\u2019 Under appearance, set the template to \u2018blank with attributes.\u2019<\/p>\n

Within this new region, create a page item, and rename it \u2018P0_YEAR\u2019. Next, set the new page item\u2019s type to \u2018hidden\u2019 and switch \u2018value protected\u2019 off.<\/p>\n

\"APEXThe source of P0_YEAR should be set to ‘SQL Query (returning single value)’ that is used \u2018always.\u2019 The query that should populate the value of the page item with the current year is:<\/p>\n

select to_char(sysdate, 'YYYY') from dual;<\/code>\"APEX<\/p>\n

The final step is to set the source of the Copyright Notice region to the following text that interprets the dynamic value of the hidden page item using a substitution string:<\/p>\n

\u00a9 &P0_YEAR. [name of your company or application]<\/code>\"APEX<\/p>\n

\"CopyrightAnd voil\u00e0! \u2014 a dynamic-date footer copyright notice. If you want to get really fancy, you can even add an extra statement about the extent of the copyright you are asserting. For example, if you\u2019re claiming ownership rights for all of the content, you can include, \u201cAll rights reserved.\u201d On the other hand, if you\u2019re putting your content under a Creative Commons license<\/a>, you can include that information here. Either way, you\u2019ll have a properly-formatted copyright notice that\u2019s always up-to-date.<\/p>\n

Looking for more help with Oracle APEX development? Let\u2019s chat.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Most websites and web-based applications are built on original intellectual property that needs to be protected using a copyright notice. Over at Love2Dev.com, Chris Love has created a nice explainer…<\/p>\n","protected":false},"author":20,"featured_media":12337,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[50,53,52],"tags":[],"acf":[],"yoast_head":"\nCreating a Dynamic Copyright Notice in APEX Applications - Traust<\/title>\n<meta name=\"description\" content=\"Here's an easy way to help protect your intellectual property in Oracle APEX websites and applications using a copyright notice.\" \/>\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\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a Dynamic Copyright Notice in APEX Applications - Traust\" \/>\n<meta property=\"og:description\" content=\"Here's an easy way to help protect your intellectual property in Oracle APEX websites and applications using a copyright notice.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\" \/>\n<meta property=\"og:site_name\" content=\"Traust\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-19T13:00:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-06T00:27:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Luke Rohde\" \/>\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=\"Luke Rohde\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\"},\"author\":{\"name\":\"Luke Rohde\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/2af8547f31bebf73e4d13692df03f83e\"},\"headline\":\"Creating a Dynamic Copyright Notice in Public-Facing APEX Applications\",\"datePublished\":\"2022-05-19T13:00:38+00:00\",\"dateModified\":\"2022-10-06T00:27:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\"},\"wordCount\":434,\"publisher\":{\"@id\":\"https:\/\/traust.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg\",\"articleSection\":[\"APEX\",\"Oracle\",\"Technical\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\",\"url\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\",\"name\":\"Creating a Dynamic Copyright Notice in APEX Applications - Traust\",\"isPartOf\":{\"@id\":\"https:\/\/traust.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg\",\"datePublished\":\"2022-05-19T13:00:38+00:00\",\"dateModified\":\"2022-10-06T00:27:35+00:00\",\"description\":\"Here's an easy way to help protect your intellectual property in Oracle APEX websites and applications using a copyright notice.\",\"breadcrumb\":{\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage\",\"url\":\"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg\",\"contentUrl\":\"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg\",\"width\":1200,\"height\":800,\"caption\":\"Copyright notice stamp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/traust.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a Dynamic Copyright Notice in Public-Facing APEX Applications\"}]},{\"@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\/2af8547f31bebf73e4d13692df03f83e\",\"name\":\"Luke Rohde\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/traust.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4e13d600233be2c482a193461da44343?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4e13d600233be2c482a193461da44343?s=96&d=mm&r=g\",\"caption\":\"Luke Rohde\"},\"description\":\"Luke is a hard working, trustworthy, honest, dependable, genuine consultant, and he cares about doing good work that he can be proud of. In 2019, he left his position at Surly Brewing Company to pursue an education opportunity at Prime Digital Academy in Minneapolis, Minnesota. After completing that course in March 2020, he began work at Traust as a web developer and an Oracle APEX engineer.\",\"url\":\"https:\/\/traust.com\/blog\/author\/lrohde\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a Dynamic Copyright Notice in APEX Applications - Traust","description":"Here's an easy way to help protect your intellectual property in Oracle APEX websites and applications using a copyright notice.","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\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/","og_locale":"en_US","og_type":"article","og_title":"Creating a Dynamic Copyright Notice in APEX Applications - Traust","og_description":"Here's an easy way to help protect your intellectual property in Oracle APEX websites and applications using a copyright notice.","og_url":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/","og_site_name":"Traust","article_published_time":"2022-05-19T13:00:38+00:00","article_modified_time":"2022-10-06T00:27:35+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg","type":"image\/jpeg"}],"author":"Luke Rohde","twitter_card":"summary_large_image","twitter_creator":"@TraustConsult","twitter_site":"@TraustConsult","twitter_misc":{"Written by":"Luke Rohde","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#article","isPartOf":{"@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/"},"author":{"name":"Luke Rohde","@id":"https:\/\/traust.com\/#\/schema\/person\/2af8547f31bebf73e4d13692df03f83e"},"headline":"Creating a Dynamic Copyright Notice in Public-Facing APEX Applications","datePublished":"2022-05-19T13:00:38+00:00","dateModified":"2022-10-06T00:27:35+00:00","mainEntityOfPage":{"@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/"},"wordCount":434,"publisher":{"@id":"https:\/\/traust.com\/#organization"},"image":{"@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage"},"thumbnailUrl":"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg","articleSection":["APEX","Oracle","Technical"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/","url":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/","name":"Creating a Dynamic Copyright Notice in APEX Applications - Traust","isPartOf":{"@id":"https:\/\/traust.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage"},"image":{"@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage"},"thumbnailUrl":"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg","datePublished":"2022-05-19T13:00:38+00:00","dateModified":"2022-10-06T00:27:35+00:00","description":"Here's an easy way to help protect your intellectual property in Oracle APEX websites and applications using a copyright notice.","breadcrumb":{"@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#primaryimage","url":"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg","contentUrl":"https:\/\/traust.com\/wp-content\/uploads\/2022\/02\/copyright-symbol-2021-08-26-16-59-49-utc_1200x800.jpg","width":1200,"height":800,"caption":"Copyright notice stamp"},{"@type":"BreadcrumbList","@id":"https:\/\/traust.com\/blog\/creating-a-dynamic-copyright-notice-in-public-facing-apex-applications\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/traust.com\/"},{"@type":"ListItem","position":2,"name":"Creating a Dynamic Copyright Notice in Public-Facing APEX Applications"}]},{"@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\/2af8547f31bebf73e4d13692df03f83e","name":"Luke Rohde","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/traust.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4e13d600233be2c482a193461da44343?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4e13d600233be2c482a193461da44343?s=96&d=mm&r=g","caption":"Luke Rohde"},"description":"Luke is a hard working, trustworthy, honest, dependable, genuine consultant, and he cares about doing good work that he can be proud of. In 2019, he left his position at Surly Brewing Company to pursue an education opportunity at Prime Digital Academy in Minneapolis, Minnesota. After completing that course in March 2020, he began work at Traust as a web developer and an Oracle APEX engineer.","url":"https:\/\/traust.com\/blog\/author\/lrohde\/"}]}},"_links":{"self":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts\/12322"}],"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\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/comments?post=12322"}],"version-history":[{"count":0,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/posts\/12322\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/media\/12337"}],"wp:attachment":[{"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/media?parent=12322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/categories?post=12322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/traust.com\/wp-json\/wp\/v2\/tags?post=12322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}