Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Database mapping not evident in Personalisation

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

Usually when I want to find where a field on an AX form maps back to the database I right click, select Personalise and find the mapping in the System name field of the Personalisation form. I have one field where there is no database mapping. Instead the System name just says CtrlActiveAll(see screenshot).

How do I find the mapping? I want to create a report where only Active projects are returned.

Thanks

Paul

*This post is locked for comments

  • Verified answer
    jayh Profile Picture
    jayh 410 on at
    RE: Database mapping not evident in Personalisation

    That control isn't tied directly to a database field, instead code in ProjProjectListPageIntraction.initializeQuery filters the ProjTable.Status field based on whether you have chosen 'Active' or 'All'.  Active projects are projects where the ProjTable.Status field is not ProjStatus::Completed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Database mapping not evident in Personalisation

    Sorry. Screenshot attached.

    0045.proj.JPG

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: Database mapping not evident in Personalisation

    Hi Paul,

    Sometimes controls on the form could be not bound to table field directly. They could be bound to display or edit method. In same cases, if it is a tick box, it could be unbound as well and have some logic in the overridden clicked method.

    There is no screenshot so it's hard to understand what control are you talking about.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans