Project

General

Profile

Bug #1103

new report احصائية انشطة التفتيش

Added by Abdelhalim Abu Qamar about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
High
Assignee:
Abdelhalim Abu Qamar
Start date:
04/11/2019
Due date:
04/14/2019
% Done:

100%

Co-Workers:
Severity:
Normal
Category:
inspection report
Sub-Category:
Step_Description:
Pre_Conditions:
Expected Result:
Actual Result:
Environment:
Production
Transaction Number:
Username:
Browser:
URL:
Test Case ID:

Description

kindly find the UI of a report and the SQL and then call it at a screen (تقارير احصائية لنظام التفتيش) thru button (التفتيش حسب النشاط الاقتصادي)

sql_eco_rep.txt Magnifier - latest one (763 Bytes) Abdelhalim Abu Qamar, 04/11/2019 04:25 PM

static_econmic_rep_UI.jpg (94.8 KB) Abdelhalim Abu Qamar, 04/11/2019 04:25 PM

History

#1 Updated by Abdelhalim Abu Qamar about 6 years ago

  • File deleted (static_econmic_rep_UI.jpg)

#2 Updated by Abdelhalim Abu Qamar about 6 years ago

  • File deleted (sql_eco_rep.txt)

#3 Updated by Abdelhalim Abu Qamar about 6 years ago

#4 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

please review the sql attached query >>
what do you mean by this where clause ?

*and VISIT_ID between :p_from_date to :P_to_Date *
??

#5 Updated by Abdelhalim Abu Qamar about 6 years ago

Ahmad Amer wrote:

please review the sql attached query >>
what do you mean by this where clause ?

*and VISIT_ID between :p_from_date to :P_to_Date *
??

visit_date

#6 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Status changed from Open to In Progress
  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer

#7 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

Dear Halim , please review the query on TEST Database

"INS_PKG"."GET_ORDER_LICN": invalid identifier
this function not found.
please add it on test database.

#8 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer

Ahmad Amer wrote:

Dear Halim , please review the query on TEST Database

"INS_PKG"."GET_ORDER_LICN": invalid identifier
this function not found.
please add it on test database.

---------
Test-DB synced now

#9 Updated by Ahmad Amer about 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar
  • % Done changed from 0 to 100

done on TEST, please check

#10 Updated by Abdelhalim Abu Qamar about 6 years ago

  • Due date set to 04/14/2019
  • Status changed from In Progress to Fixed
  • Assignee changed from Abdelhalim Abu Qamar to Ahmad Amer
  • Environment Production added
  • Environment deleted (Development)

Ahmad Amer wrote:

done on TEST, please check

Done, kindly move to Prod.

#11 Updated by Ahmad Amer about 6 years ago

  • Status changed from Fixed to Closed
  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

done on prod.

Also available in: Atom PDF