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)

Fawad Ahmad 61 on at

Like (0)

Report

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

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

Like (0)

Report

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

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,827 Moderator on at

Like (0)

Report

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

zeros padding in employeesID values

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

Like (0)

Report
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

yes but many employees ids have 00012 .

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

Like (0)

Report

Have you tried the code which I have sent?

Thanks,

Girish S.

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates