CODEWITHSUNDEEP
oracle-databaseoracle-apex
Ahmed Chishti
Ahmed Chishti

Reputation: 133

Oracle Apex : Showing SQL Count beside Navigation Menu Icon and Text

I want a dynamic number (an output of SQL query) to be shown besides page link text and icon in the navigation menu of my Oracle Apex application (Just the way it has been done in Oracle Apex Opportunity Tracker sample application).

Editing the static text of link is really simple and can be done by going to *Application123\Shared Components\Lists* and editing Application Menu but what I don't know is that how can I display a count there besides the Text and icon.

This is the desired output enter image description here

This is where I know, I can edit the text (static) and change/select the icon for the link enter image description here but where to write SQL query and get its result instead of [&Leads.] , that's is not in my knowledge. Really appreciate help on this !!!!

select count(mycolumnname)
from mytablename
where anotherdatecolumn = trunc(current_date)  and (referid='1' or referid='12' or referidD='18');

Upvotes: 0

Views: 2386

Answers (1)

Littlefoot
Littlefoot

Reputation: 143053

  • DEALS should be an application item (declared in Shared Components)
  • query should be then used in application computations (also in Shared Components)

Upvotes: 1

Related Questions