how to show employee ID where single integer value are in empID Field.

(0) Share

Report

Posted on by Fawad Ahmad

Here single Integer not show Name

public str ahmad_getEmpName(PREmployeeId _employeeId)
{
	utcDateTime 	validTo = DateTimeUtil::maxValue();
	utcDateTime 	validFrom = DateTimeUtil::minValue();
    str				empName;
    //PREmployeeId 	empid1 = "*"  _employeeId;
    PREmployeeId 	empid1 = strRFix(_employeeId,5,'0');

	while select firstOnly ValidTimeState(validFrom, validTo) prEmploymentInformation
        where prEmploymentInformation.EmployeeId == empid1

    {
        empName = prEmploymentInformation.EmployeeName;
	}
	
	return empName;
}

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Fawad Ahmad 61 on at

Like (0)

Report
Copy link

Link copied!

I want to show through single Integer employee ID have name and department also show.

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Fawad,

Your question is not clear.

Can you elaborate?

Thanks,

Girish S.

Was this reply helpful? Yes No
Fawad Ahmad 61 on at

Like (0)

Report
Copy link

Link copied!

I want to display rawpunchesReport where in screenshot employees ID whose one integer e,g in sreenshot empId field , ID number 3 and ID number2 have not display employees Name. .

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

May be the employee's name is missing from the table.

Seems you are using custom table or view to get the employee details for the report.

Just open the table browser of the particular table or view and see whether employee name is there or not.

Thanks,

Girish S.

Was this reply helpful? Yes No
Fawad Ahmad 61 on at

Like (0)

Report
Copy link

Link copied!

zeros padding in employeesID values

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!
I am not able to understand your question.

Are you asking how to add 0 in the employee Id before.

Suppose if the personnel number is 3 then it should display like 0003?

If yes, then you need to add a code to add 0 in the employee id field. Refer to the below code and see whether its suit your scenario.

int strLen; strLen = strLen(tableName.PersonnelNumber); if(strLen <= 1) { tempTable.PersonnelNumber = "000" tableName.PersonnelNumber; } else { tempTable.PersonnelNumber = tableName.PersonnelNumber; }

Thanks,

Girish S.

Was this reply helpful? Yes No
Fawad Ahmad 61 on at

Like (0)

Report
Copy link

Link copied!

yes but many employees ids have 00012 .

Was this reply helpful? Yes No
GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you tried the code which I have sent?

Thanks,

Girish S.

Was this reply helpful? Yes No