Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / DirPerson.Name not sho...
Microsoft Dynamics AX (Archived)

DirPerson.Name not showing as option on view

(0) ShareShare
ReportReport
Posted on by lukbel 280

Hi all

Running AX 2012 R3 CU9

Trying to set up a view that links HcmWorker to DirPerson table, and it appears to be working - however, I can't pull through the DirPerson.Name, or First Name/Last Name - it's not showing as an option.

I also can't see it on the list of fields in the AOT in the actual table? However it shows on the table viewer.

How can I access this field in my view? It's never been an issue before when accessing through X++ code

Thanks very much in advance

Luke

*This post is locked for comments

  • Verified answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: DirPerson.Name not showing as option on view

    DirPerson is the table that extends from DirPartyTable table. DirPartyTable has a field Name. When you open table browser you also can see fields from main table.

    Screen-Shot-2018_2D00_09_2D00_18-at-13.09.54.png

    Take a look at this links https://docs.microsoft.com/en-us/dynamicsax-2012/developer/selecting-data-from-a-table-inheritance-hierarchy

  • lukbel Profile Picture
    lukbel 280 on at
    RE: DirPerson.Name not showing as option on view

    Hi Rustem

    This is true, and I spotted this - however, I would like to know why it isn't showing up, as this is not the first time I've run into a problem like this making queries/views.

    Also I feel DirPerson.Name is likely to be more accurate than (First name + " " + Last name) as we have some Spanish users who use multiple last names, etc. I will use this as a last resort but there must be a reason I cannot select this field when I can select others from the table (eg. Gender)

  • Suggested answer
    Rustem Galiamov Profile Picture
    Rustem Galiamov 8,072 on at
    RE: DirPerson.Name not showing as option on view

    Hi!

    Try to add DirPersonName table to a view. DirPersonName has that fields.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans