Bug #6117

[TPMS_Prod] - Post Event > Event Report > Local Trade Fair

Added by Lim Leonard over 8 years ago. Updated about 8 years ago.

Status:Work Completed-End life cycleStart date:March 23, 2016
Priority:UrgentDue date:
Assignee:Norhaidah Md Dasuki% Done:

100%

Category:tpms_prodSpent time:-
Target version:-

Description

To correct the Report value,
since Local Trade Fair Feedback from has added multiple product and service.

Support#6117_Test Result.docx (2.74 MB) Lim Leonard, April 04, 2016 11:14

History

#1 Updated by Tan Jeng Wei over 8 years ago

  • % Done changed from 0 to 50

#2 Updated by Tan Jeng Wei over 8 years ago

  • Status changed from New - Begin Life Cycle to Internal Testing
  • % Done changed from 50 to 90

Hi Leo,

This are not consider as bugs because system are just updated on yesterday night for Adding Local Trade Fair Table from 1 to multiple   table.

Me and chee On was already changed all report for actual values and expected values from fbk_exhibition_Child. Please retest it(already deployed to server). Thanks a lot.

Effected report Is ALL Local Trade Fair Report under Post Event (Total 11).

#3 Updated by Tan Jeng Wei over 8 years ago

  • Assignee changed from Tan Jeng Wei to Lim Leonard

#4 Updated by Lim Leonard over 8 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Lim Leonard to Tan Jeng Wei

hi Jeng Wei,

from our discussion and re-checking with En. Rizal, seems there still issue with the data display in the report,
Please Fix the issue

Thank you

#5 Updated by Tan Jeng Wei over 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Tan Jeng Wei to Lim Leonard

Hi leo,

Because ytd En rizal are using the ANUGA 2015 which is Trade Fair Programme Type. TF and LFT the data are store in different table in db. Please retest after deployed. Please Try to use event_name which is setup for Local Trade fair type. Thanks a lot.

Test report
1) All sales by hall
2) All Sales By product and services Categories.

#6 Updated by Tan Jeng Wei over 8 years ago

Hi Leo ,

you can Test report
1) All sales by hall report
2) All Sales By product and services Categories report.
3) Remark / Comment report
4) Equiries report

#7 Updated by Lim Leonard over 8 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Lim Leonard to Tan Jeng Wei

Hi Jeng Wei,

3) Remark / Comment report
> to hide any remark/comment, if no remark/comment is entered
4) Equiries report
> please recheck on the value, the numbers that i calculate is different from the report,
and the rest of the report

Thanks

#8 Updated by Tan Lee Yong over 8 years ago

Leo:
3) Remark / Comment report

to hide any remark/comment, if no remark/comment is entered

Lee Yong: For report, if the field is meant to be display on the report, the field must exist on the report. If the field is exist in the report and no data, can put empty space, "-", NA or N/A. Please standardize this with customer. I personally recommend to use "-".
We will not hide a field that meant to be in the report. This will impact the report design.

#9 Avatar?id=1966&size=24 Updated by Ngoh Chee Onn over 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Tan Jeng Wei to Lim Leonard
  • % Done changed from 90 to 100

Hi Leo,

Please refer below in bold for my reply.

3) Remark / Comment report

to hide any remark/comment, if no remark/comment is entered - Fixed and deploy to UAT.

4) Equiries report

please recheck on the value, the numbers that i calculate is different from the report,

and the rest of the report - Please check again on foreign buyer company as what i show you just now.

Thank you.

#10 Updated by Lim Leonard over 8 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Lim Leonard to Tan Jeng Wei

Hi Jeng Wei,

the 4 Report You have done have been tested and Passed,

Please Continue with the other Local Trade Fair

Thanks

#11 Updated by Tan Jeng Wei over 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Tan Jeng Wei to Najmi Pasarudin

Hi najimi,

Please help for checking Data For LTF report. Thanks a lot

#12 Updated by Najmi Pasarudin over 8 years ago

  • % Done changed from 100 to 90

Checked report LTF 1, LTF 2, LTF 3 and LTF 4 with sql queries. No issue so far.

#13 Updated by Najmi Pasarudin over 8 years ago

  • Status changed from Internal Testing to Development / Work In Progress

#14 Updated by Najmi Pasarudin over 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Najmi Pasarudin to Siti Norahayu Mohd Desa

Finished checking local trade fair report with sql script data.
No data issue with event MIHAS 2014 SIMULATION.

#15 Updated by Siti Norahayu Mohd Desa over 8 years ago

  • Assignee changed from Siti Norahayu Mohd Desa to Lim Leonard

Hi Leo,
Please assist. Tq

#16 Updated by Lim Leonard over 8 years ago

  • Status changed from Internal Testing to Development / Work In Progress
  • Assignee changed from Lim Leonard to Aditya Prathama

Hi Adit,

there is missing data on 'All Product & Service - By Product & Service Category'
compared data from 'Top5 Product & Service - By Product & Service Category' and 'Top10 Product & Service - By Product & Service Category'
with:
company name 'HALAGEL (M) SDN BHD'
total sale '500.00'
actual/concluded sales '500.00'

Please Kindly assist

#17 Updated by Aditya Prathama over 8 years ago

  • Status changed from Development / Work In Progress to Internal Testing
  • Assignee changed from Aditya Prathama to Lim Leonard
  • % Done changed from 90 to 100

missing data on 'All Product & Service - By Product & Service Category' fixed
Please retest at UAT.

#18 Updated by Lim Leonard over 8 years ago

  • File Support#6117_Test Result.docx added
  • Status changed from Internal Testing to Pending Review
  • Assignee changed from Lim Leonard to Siti Norahayu Mohd Desa

test result attached

#19 Updated by Siti Norahayu Mohd Desa over 8 years ago

  • Category set to tpms_prod
  • Status changed from Pending Review to User Acceptance Test
  • Assignee changed from Siti Norahayu Mohd Desa to Norhaidah Md Dasuki

#20 Updated by Norhaidah Md Dasuki about 8 years ago

  • Status changed from User Acceptance Test to Work Completed-End life cycle

Also available in: Atom PDF