web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) get Createdby name fro...

Microsoft Dynamics AX (Archived)

get Createdby name from table to Report

(0) Share

Report

Report

Posted on by Community Member

i have to show who created the Record in a table to show in my report.

Table: VendReceiptsListJour

i tried:

in processreport:

myTmp.CreatedName = this.getName(vendReceiptsListJour.createdBy);

getName Method:

public Name getName(NetworkAlias _alias)
{
UserInfo userInfo;

select * from userInfo where userInfo.networkAlias == _alias;

return UserInfo.name;
}

it didn't work, can you help me, thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (3)

Verified answer

Kanagaraj A 1,254 on at

Like (0)

Report

RE: get Createdby name from table to Report

try this,

This may help you before testing this ensure Createdby property should be YES in your table property.

UserInfo userInfo;

select networkAlias,name from UserInfo

where userInfo.id == purchtable::find("000043").createdBy;

info(strFmt("Name %1 Network alias-%2 Created by : %3", UserInfo.name,UserInfo.networkAlias,purchtable::find("000043").createdBy));

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 47,784 User Group Leader on at

Like (0)

Report

RE: get Createdby name from table to Report

also kindly remove * from your query.

you can specify filed name after select such as select FieldName from TableName;

this has nothing to do with your question but it will result in better processing.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: get Createdby name from table to Report

Hi RenSonozaki,

Go to the table properties and change CreatedBy to yes.

Was this reply helpful? Yes No
Suggested answer

Sohaib Cheema 47,784 User Group Leader on at

Like (1)

Report

RE: get Createdby name from table to Report

where userInfo.id== _vendReceiptsListJour.createdBy;

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Responsible AI policies for the Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Syed Haris Shah 9

#2

Mea_ 4

#3

Rahul Shah 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans