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