Archive › Technology

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 )

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 )

SQL Server: Find first column with specified value

Returns first column of any table which contains a search value

Comments ( 0 )