Bug #5737
[UAT3-9/044] - Dashboard > Impact Sales > TOP GROSSING COMPANIES
Status: | Closed - End of life cycle | Start date: | November 24, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | November 25, 2015 | |
Assignee: | Siti Norahayu Mohd Desa | % Done: | 100% | |
Category: | tpms_uat | Spent time: | - | |
Target version: | - |
Description
Does not show result for Trade Fair for Top Rank
History
#1 Updated by Shahidan Syahirman almost 9 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- Assignee changed from Shahidan Syahirman to Siti Norahayu Mohd Desa
query :
select first ?1 f.cm_company_name, sum(nvl(e.ecsaleprog_ammount,0)), g.r_desc as tgs from event_main a inner join event_detail b on a.em_id = b.em_id inner join event_participating_company c on b.ed_id = c.ed_id inner join event_comp_sale d on c.ec_id = d.ec_id inner join event_comp_sale_progress e on d.ecsale_id = e.ecsale_id inner join company_main f on c.cm_id = f.cm_id inner join r_programme_type g on a.r_programme_type_id = g.r_programme_type_id where YEAR = ?2 and a.r_programme_type_id = ?3 group by f.cm_company_name, g.r_desc order by tgs desc
which mean the data for sale generated for top grossing companies is from
table event_comp_sale_progress
column ecsaleprog_ammount.
but there are no data available within the database.
#2 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Status changed from Development / Work In Progress to Internal Testing
#3 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Subject changed from [UAT3-9/044] - Dashboard > Impact Sales to [UAT3-9/044] - Dashboard > Impact Sales > TOP GROSSING COMPANIES
#4 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Status changed from Internal Testing to Development / Work In Progress
- Assignee changed from Siti Norahayu Mohd Desa to Aditya Prathama
#5 Updated by Aditya Prathama almost 9 years ago
- Status changed from Development / Work In Progress to Internal Testing
- Assignee changed from Aditya Prathama to Siti Norahayu Mohd Desa
- % Done changed from 0 to 100
update query, but some table have no data for certain programtype (ISP, JTP, MPM)
#6 Updated by Siti Norahayu Mohd Desa almost 9 years ago
- Status changed from Internal Testing to User Acceptance Test
15/12/15 [Ayu]
Tested & Passed.
Send for User Retest.
#7 Updated by Norhaidah Md Dasuki over 8 years ago
15/12/15 - Issue Closed
#8 Updated by Norhaidah Md Dasuki over 8 years ago
- Status changed from User Acceptance Test to Closed - End of life cycle