Database mapping not evident in Personalisation

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry. Screenshot attached.

Was this reply helpful? Yes No
Verified answer

jayh 410 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No