Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query returning empty months

Javier PMar 10 2022

Hi all,

I have this query that returns the production of the last 12 months.
This is the query:

select
    null
  , sum(f.comision)         value
  , trunc(f.efectiva, 'MM') label
from
    risk_facturas f
where
    f.efectiva >= add_months(trunc(sysdate), -13) and f.efectiva < trunc(sysdate) + 1
and f.organizacion_id = :APP_GET_ORGANIZACION_ID
group by
    trunc(f.efectiva, 'MM')

How can I get a line for every month no matter if it has any production or is just 0? Can this be done?
Thanks for the help!
Javier

This post has been answered by Solomon Yakobson on Mar 12 2022
Jump to Answer

Comments

John JB Brock-Oracle

Details please.
What version of JET?
What do you mean by "move the chart months and weeks"? How are you doing that moving?

Thanks

renangi

version 9.2.0, yes, after loading the chart, when we move the chart months and weeks.,
I have search popup, it will display all the projects, when i select one project, showing chart and values.. after loading the chart when i move the chart..
for the next project when i select from search popup, chart not displaying.

John JB Brock-Oracle

Please describe in more detail, what this means, "after loading the chart when i move the chart.."
What steps are you taking to "move the chart". I can't tell what exactly you are doing from the information you have provided. Without that info, I can't try and create a local reproduction case.

Wilson Louie-Oracle

Any screenshots and/or videos and/or code demonstrating the issue would be helpful. Thanks!

1 - 4

Post Details

Added on Mar 10 2022
18 comments
113 views