Support #6134
Support #6123: [MIHAS2016_Local Trade Fair] - Simulation Issue
[MIHAS2016_Local Trade Fair] - Issue 26/3/2016 (Exh016)
Status: | Closed - End of life cycle | Start date: | March 28, 2016 | |
---|---|---|---|---|
Priority: | Normal | Due date: | March 29, 2016 | |
Assignee: | Norhaidah Md Dasuki | % Done: | 100% | |
Category: | SIMULATION | Spent time: | 1.00 hour | |
Target version: | - |
Description
Report effected :-
• By Hall - All Products/Services
Issue:- Report is not grouped by all hall followed by individual hall for each day. Please refer to sample report that had been supplied on 22 October 2015 attachment. (10.TOP 10 PRODUCT & SERVICES SOURCED, BY HALL.pdf)
The sample report is for TOP 10 PRODUCT & SERVICES SOURCED, BY HALL. For this report, it will display all product and service without limit of top 10.
Related issues
History
#1 Updated by Ngoh Chee Onn over 8 years ago
- Assignee changed from Ngoh Chee Onn to Tan Jeng Wei
#2 Updated by Tan Jeng Wei over 8 years ago
- % Done changed from 0 to 70
#3 Updated by Tan Jeng Wei over 8 years ago
- Status changed from New - Begin Life Cycle to Internal Testing
- Assignee changed from Tan Jeng Wei to Lizahwati Basirun
- % Done changed from 70 to 90
Hi Lizah,
New Enhancement For Adding All Product Based On Date.
Please retest after deployed,Please refer template pdf with attachment. Thanks a lot
#4 Updated by Lizahwati Basirun over 8 years ago
- Status changed from Internal Testing to Development / Work In Progress
- Assignee changed from Lizahwati Basirun to Tan Jeng Wei
Dear Jeng Wei,
Issue still persist.
1)Data still not group by hall. Should display by all halls and by each hall.
2)The data should display only the highest product and service based on total sales generated.
#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 Lizahwati Basirun
Hi Lizah,
root/cause: taking the top product code from event and using those product code finding in all hall and each hall.
solution : taking the top product code by each hall and all Hall.
Please retest after deployed. Thanks a lot.
#6 Updated by Norhaidah Md Dasuki over 8 years ago
- Assignee changed from Lizahwati Basirun to Siti Norahayu Mohd Desa
Ayu, please retest. (For data please refer attached file)
#7 Updated by Norhaidah Md Dasuki over 8 years ago
- File DATA VERIFY.xlsx added
#8 Updated by Siti Norahayu Mohd Desa over 8 years ago
- File All Product & Services.png added
- Status changed from Internal Testing to Development / Work In Progress
- Assignee changed from Siti Norahayu Mohd Desa to Najmi Pasarudin
Salam Najmi,
Data in the system not tally with the extracted data from feedback. Please refer attached.
#9 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
On 30/03/2016 evening, I updated database sales from null to 0. This to fix sum calculation null when one of the sales is null.
Example: 1,000 + null = null which supposed to be result = 1,000.
DATA_VERIFY.xlsx is extracted before this update. Therefore, current downloaded report is different from DATA_VERIFY.xlsx.
Note: I have finished sql query for all Local Trade Fair report for data verification.
#10 Updated by Siti Norahayu Mohd Desa over 8 years ago
- File Support#6134_Test Result -INSP_MIHAS2016.docx added
- Status changed from Internal Testing to Pending Review
- Assignee changed from Siti Norahayu Mohd Desa to Norhaidah Md Dasuki
- % Done changed from 90 to 100
Noted and Thank You Najmi.
Kak Haida,
Please find test result as per attached.
#11 Updated by Norhaidah Md Dasuki over 8 years ago
- Status changed from Pending Review to Closed - End of life cycle
Successfully migrated to production on 30/3/2016 due to urgency.
Migration version: TPMS_v025