Friday, February 21, 2020 APEX and shuttle filter - Revisited APEX and jQuery Previously I did write post about APEX and shuttle filter. I received comments that filtering does not work when shuttle have parent cascading item. Issue was that JavaScript code stores shuttle values to variable for filtering only on page load. Continue Reading
Sunday, February 17, 2019 Stopping XE 18c properly when shutting down CentOs 7 Oracle Database You can configure automatically start and stop Oracle XE 18c database on operating system startup and shutdown. See details from installation guide. I did install XE 18c on CentOs 7 and executed steps mentioned in installation guide. When viewing database alert.log after system reboot, noticed that database wasn't actually stopped properly. Processes were just killed. I didn't investigate more why that happens on my system. For workaround I did revert steps mentioned in installation guide and created service file for systemd. Continue Reading
Sunday, March 4, 2018 Caching APEX static files APEX and Apache HTTPD The APEX installation includes static files that are located on the web server. These files may changed normally only when you upgrade or apply patch to APEX. Because files are changing rarely, they are good subject stored to cache. If you use Apache HTTPD to serve static files, you can configure mod_file_cache for ones that are used most in your applications. Continue Reading
Sunday, February 11, 2018 Changing Report Column Date Format APEX Tips and Tricks In APEX there is build in date formats SINCE and SINCE_SHORT that I use often in report date columns. Unfortunately you can't use SINCE format in application Globalization Attributes, so you need separately set it to columns. But, sometimes you need to see the actual date value in column. Here is simple example how you can switch between application global date format and SINCE. Continue Reading
Saturday, October 10, 2015 Oracle Database Developer Choice Awards APEX Community I'm finalist for Oracle Database Developer Choice Awards in Oracle Application Express (APEX) category. I'm very impressed and surprised for this honor. I want thank all who have filled nomination form and voted. Special thanks to all who have also leave comments and supported me by blog posts and spreading word other ways. If you haven't vote yet, now it's time. Voting ends at 15th of October. Please remember you can vote multiple persons in all categories. I hope Denes Kubicek's blog post encourage everybody to vote. Continue Reading