 Oracle Graphics Builder 6i [message #504207] |
Fri, 22 April 2011 01:05  |
 |
adeelali
Messages: 10
Registered: April 2011
Location: Pakistan
|
Junior Member |
|
|
Hi Friends
I am using Oracle Form Builder and Graphics Builder 6i
In Graphics Builder I create a graph from this query view but in result my result is reverse
which i want..
==============================================================
Create or Replace View V_Mnth_Attn as
select
emp_id, max(nm) name, max(cid) cmp_id, max(dpt) dpt_id,
min(case when to_char(dt_attend,'dd') = '01' then abrr end) "D_1",
min(case when to_char(dt_attend,'dd') = '02' then abrr end) "D_2",
min(case when to_char(dt_attend,'dd') = '03' then abrr end) "D-3",
min(case when to_char(dt_attend,'dd') = '04' then abrr end) "D-4",
min(case when to_char(dt_attend,'dd') = '05' then abrr end) "D_5"
from
( select et.* , st.abrr
from (select emp_id, max(p.dpt_id) dpt, max(p.name) nm, max(p.cmp_id) cid, dt_attend,
min(stag.order_by) tag_id
from emp_tags et, personnel.personnel p, set_tags stag
where emp_id = p.ID
and et.tag_id = stag.id
group by emp_id, dt_attend
) et , set_tags st
where et.tag_id = st.order_by )
group by emp_id
order by emp_id
/
==============================================================
because i want values in graph of all columns but i got only employee id on values
and on get all values on x axis please tell me what i do..
Thanks & Regards
Adeel
|
|
|
|
| Re: Oracle Graphics Builder 6i [message #512363 is a reply to message #504207] |
Sun, 19 June 2011 15:23  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Could you provide a test-case: CREATE TABLE and INSERT INTO sample data; not necessarily all tables you used in a view, but perhaps something like create table test as
select * from V_Mnth_Attn
where ...
and rownum < n |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
