Skip to main content

Notifications

Dynamics 365 Community / Blogs / ELandAX blog / Selecting Cached Tables

Selecting Cached Tables

Dynamics AX ignores specific fields selection if all the folowing contitions are fulfiled:
  • Table has CacheLookup property set to NotInTTS, Found or FoundAndEmpty
  • Table has a primary key
  • Selecting tables' primary key with (==)

Example:
select ProjId, ProjGroupId, Name from projTable where projTable.ProjId == "PROJ-00123";

if projTable meets above mentioned conditions the result will be entire record, not only ProjId, ProjGroupId, Name fields.

Comments

*This post is locked for comments