Database mapping not evident in Personalisation

(0) Share

Report

Posted on by Community Member 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

All responses (3)

Answers (1)

Verified answer

jayh 410 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: Database mapping not evident in Personalisation

Sorry. Screenshot attached.
Mea_ 60,278 on at

Like (0)

Report

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.