Archive › News

APEX 5: Showing custom success message from Dynamic Action (DA) on Universal Theme

I needed to show a success message after ending a Dynamic Action and I wanted this message to be with the same format as success messages from page processes. Since this is not a standard feature of Oracle APEX, you can do the following trick if you’re using Universal Theme: Create a JavaScript function which […]

Comments ( 0 )

Oracle APEX 5.0: How-to call modal page from dynamic action and capture close event

Today I needed to submit a page saving data and opening a modal page afterwards. For my surprise, APEX 5.0 raises an “400 – Bad request” error when calling a modal page from “Branch” section after processesing (calls apex.navigation.dialog without stating “javascript:” sentence first). It seems to be a Bug of 5.0 version (which hopefuly […]

Comments ( 1 )

MicroStrategy: Creating a count metric of distinct occurrences of Attribute2 in Attribute1

Today I needed to create a simple count report metric without the need of creating a standalone metric in MicroStrategy. What I needed was to count the number of appearences of certain attribute for the last 30 days. In other words, the metric of distinct occurences of “Days” in Attribute1. You could easily achieve this […]

Comments ( 0 )

MicroStrategy 10 Hacks: How to fire selector change via Button for any presentation mode

In order to provide usability to your Dashboards, you can let users the possibility to click somewhere and apply certain filter. For instance, you may want to filter a region by clicking a Button instead of scrolling inside a select list for some particular values: 1) MicroStrategy: Create a “Select List” Selector 2) MicroStrategy: Select any panel or […]

Comments ( 0 )

MicroStrategy 10 hacks: Loading jQuery under new Presentation Mode

First of all I’d like to thank Bryan Brandow because this post is inspired on his various posts about this subject: http://www.bryanbrandow.com/search/jquery Since MicroStrategy 10 was out last year 2015, I’ve been trying to achieve some jQuery hacks in order to provide more usability to our dashboards. The first problem I faced when migrating to MicroStrategy […]

Comments ( 1 )

Answering freelance fears from experience

I usually write technical notes on my blog but, in this case, I want to write some literature about my experience of being freelance, focusing on my initial fears and how they got defeated. I’ve been working in a freelance basis since 2009, when I created “Relational” which is my freelance firm. At the beginning […]

Comments ( 0 )

Deleting unused indexes – SQL Server

It’s a good practice to periodically check usage of indexes in case they are not really used by users. We must be aware some indexes cost to maintain and affects our database performance when inserting data. The following query allows you to identify those indexes which are not used (no user seeks, scans nor lookups) […]

Comments ( 0 )

APEX Relational Flexfield plugin – Tutorial

In this post I’ll guide you on how to use “flexfield” APEX plugin. For a online demo, you can access: https://apex.oracle.com/pls/apex/f?p=JOSEPCOVES:FLEXFIELDS Let’s assume we want to provide admin users the ability to fill some table fields with their own specification. We assume you have your own demo “EMP” table with employee information. 1. First of […]

Comments ( 2 )

APEX 5.0: Change export calendar links position

After trying new amazing APEX 5.0 Calendar, even though I’ve found it great, I really think further work is needed in order to provide more options for developers. We’re unable to change inner HTML code because we’re don’t have Templates associated to this new component, and we’re even unable to define different position for its […]

Comments ( 3 )

APEX: How to create a select list with FontAwesome icons

Hi, Today I needed to create an APEX select list input in order to let users choose its own icon from FontAwesome gallery, like this one: I first tried to insert span tag with font-awesome classes, but APEX scapes HTML tags and it didn’t work. So finally I read at Patrick Wolf’s blog one possible […]

Comments ( 10 )