Skip to Main Content

APEX

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!

Group by bug on Appex page??

FunkyApr 30 2006 — edited Apr 30 2006

I have a report on page defined as:

select count(*) Hitova, to_char(click_time,'YYYY.MM.DD') Dan
from xe_page_hits
group by to_char(click_time,'YYYY.MM.DD')
order by 2 desc

Here is result from SQLPlus:

    HITOVA DAN
---------- ----------
         2 2006.04.30
         2 2006.04.28
         9 2006.04.26
         1 2006.04.25

When I put the same report on Appex page I get the result as shown on picture:
http://i1.tinypic.com/wtgabo.png
look at the missing value in first column!

I have checked all definition on WEB page And cannot see whay is that happening!???
Here is the whole page:
http://i3.tinypic.com/wtgayg.png

Here is the XE_PAGE_HITS structure:

CREATE TABLE XE_PAGE_HITS (
  ID           INTEGER                        CONSTRAINT XE_PAGE_HITS_ID_NN NOT NULL,
  IP_ADDRESS   VARCHAR2(15 BYTE)              ,
  PAGE_ID      INTEGER                        ,
  CLICK_TIME   DATE                           DEFAULT SYSDATE                                           
)
PCTFREE    0  -- there is no update on this table-just INSERT
LOGGING 
NOCACHE
PARALLEL ( DEGREE DEFAULT INSTANCES DEFAULT );

Any hint appresciated...

P.S.
Picture is taken from Firefox 1.5.0.2 but the web page is the same in I.E.6.x and Opera 9.x!

P.S. II
Here is the whole table data:

ID                                     IP_ADDRESS      PAGE_ID                                CLICK_TIME          
1                                      10.10.0.101                                            26.04.2006 17:50:30 
2                                      10.10.0.101                                            26.04.2006 17:51:52 
3                                      10.10.0.101     4                                      26.04.2006 17:51:55 
4                                      10.10.0.101                                            26.04.2006 17:52:01 
5                                      10.10.0.101     4                                      26.04.2006 17:52:02 
6                                      10.10.0.101                                            26.04.2006 20:24:39 
7                                      10.10.0.101     4                                      26.04.2006 20:24:43 
8                                      10.10.0.101                                            26.04.2006 20:25:42 
9                                      10.10.0.101     4                                      26.04.2006 20:25:44 
14                                     1.1.1.1         28                                     25.04.2006          
10                                     10.10.0.101                                            28.04.2006 15:50:51 
11                                     10.10.0.101     4                                      28.04.2006 15:51:02 
12                                     10.10.0.101                                            30.04.2006 12:47:43 
13                                     10.10.0.101     4                                      30.04.2006 12:47:54 
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 28 2006
Added on Apr 30 2006
2 comments
278 views