Selecting Cached Tables
Dynamics AX ignores specific fields selection if all the folowing contitions are fulfiled:
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.
- 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.
*This post is locked for comments