Oracle Graphics Builder 6i [message #504207] |
Fri, 22 April 2011 01:05 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/143b75a553714263d2f3d045e9fb0836?s=64&d=mm&r=g) |
adeelali
Messages: 10 Registered: April 2011 Location: Pakistan
|
Junior Member |
![adeelalis%40yahoo.com](/forum/theme/orafaq/images/yahoo.png)
|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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 Attach your current graph screenshot, settings you set and (if possible) a drawing of what you'd like to get as a result. Graph 6i is quite an old piece of software; I'm not sure I have it, but someone might have. It would be easier to test and suggest if we had something to work with.
|
|
|