Bug #5737

[UAT3-9/044] - Dashboard > Impact Sales > TOP GROSSING COMPANIES

Added by Siti Norahayu Mohd Desa almost 9 years ago. Updated over 8 years ago.

Status:Closed - End of life cycleStart date:November 24, 2015
Priority:NormalDue date:November 25, 2015
Assignee:Siti Norahayu Mohd Desa % Done:

100%

Category:tpms_uatSpent 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

Also available in: Atom PDF