Project

General

Profile

Bug #745

ins045 نواقص العمالة الوطنية

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

Status:
Fixed
Priority:
High
Assignee:
Abdelhalim Abu Qamar
Start date:
09/26/2018
Due date:
% Done:

0%

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

Description

Dear Ahmed;
kindly update the [ins045 نواقص العمالة الوطنية] :
1- update the SQL with new attachment one
2-remove (مستخدم النظام) from the list of (صفة مقدم الطلب)

sql_nationalworker.txt Magnifier (516 Bytes) Abdelhalim Abu Qamar, 09/27/2018 04:21 PM

History

#1 Updated by Ahmad Amer over 6 years ago

  • Status changed from In Progress to Fixed

updated, need for test deployment

#2 Updated by Ahmad Amer over 6 years ago

  • Assignee changed from Ahmad Amer to Abdelhalim Abu Qamar

#3 Updated by Abdelhalim Abu Qamar over 6 years ago

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

point 2 , DONE
point 1 , need to use the latest SQL, coz the old one (subquery returns more than one row) :
SELECT msor.SOURCE_ID ,
msor.SOURCE_STATUS ,
msor.CREATED_DATE,
msor.FILE_RECID ,
(SELECT mv.LICN_CON_NO
FROM MOSAL_USER.NMP_LICNFILE_V mv
WHERE mv.LF_RECID =dtl.lf_recid
) LICN_civil_NO
FROM INS_SOURCE_ORDER msor ,INS_SOURCE_ORDER_DTL dtl
WHERE msor.SOURCE_ID = dtl.SOURCE_ID
and msor.SOURCE_TYPE in ( 1,5,6)
and dtl.INSPECTION_TYPE_ID IN (4,5)
AND msor.FILE_RECID = :b_fileRecid;

#4 Updated by Ahmad Amer over 6 years ago

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

Also available in: Atom PDF