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.