It sounds like an easy task, but it took me a while to get a badge list query working. Just to be clear, I’m talking about the query you have to define when creating a dynamic list in Shared Components. You can then create a list region on a page based on that list. Here is a working example query:
It turns out that a lot of things can go wrong with this kind of query.
- The first column in the query must be the level, which is completely useless for a badge list query. However, you are required to specify this column. Neglecting to do so will result in the following error message when running the page:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
Simply specify NULL or 1 as the level value.
Don’t use the word level as an alias by the way. Level is a reserved keyword in SQL.
- The second column lets you define the badge label. This column is required as well. Use NULL if you don’t want to display a label.
- The next required column is the target value, which allows you to provide a link for the badge.
- Specifying NULL will generate a link to the current page.
- Attribute 1 to 4 are not being used, but they are required.
- Attribute 5 is the value that shows in the badge. Needless to say that this column is required.
- Attribute 6 is optional (finally). You can use it to add one or more custom classes to the <li> tag of the badge.
- Attribute 7 is also optional and can be used to add custom HTML attributes to the <a> tag of the target column.
A small tip: use the UNION ALL set operator to add more badge items.
To make things even more complicated, the Badge List template in Universal Theme uses the #A01#, #A02# and #A03# substitution strings.
<li class="t-BadgeList-item #A02#"> <span class="t-BadgeList-label">#TEXT#</span> <span class="t-BadgeList-value"><a href="#LINK#" #A03#>#A01#</a></span> </li>
However, the badge list query works with attributes 5, 6 and 7. Pretty weird, right?
Use UNION ALL to prevent a sort operation in the execution plan, instead of a UNION
You are right. UNION ALL is the better pick here. I have updated the article accordingly.
forgot so say: great tip! ;)
LikeLiked by 1 person
On the click on the badge I need to add link so that it can go to another page. I tried it on target, However it does not work. What will be URL ?
The target should be something like this:
This URL will go to page 20 in the current application, and will set the value of P20_DEPTNO to 10.
Hope this helps,
Hi everyone help me please..how can download plugin for dashboard.
Comments are closed.