Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Cache lookup property
Finance forum

Cache lookup property

(0) ShareShare
ReportReport
Posted on by

I well understand about Cache Server side and Client side.

As I understand

Entire Table: We used for Master tables.

NotInTTS: We used for Transaction tables.

Found : We used for those table where values never get changed. Like Unit Table.

Found&Empty : ?

Kindly let me know in which table we are going to set Found&Empty.

Please give me more she'd on this

Thanks!

Notintts: We used for Transaction tables

  • Rahul606 Profile Picture
    Rahul606 5 on at
    RE: Cache lookup property

    Hi, first i would thank you for above content.


    Found&Empty: is used on table which by default has no record. Table like Discount table. By using Found&empty cache on discount table, the key that are queried for but not found are stored in the cache as nonexistent. So subsequent queries for these same non existent records can be answered from cache without a round trip to DB. Hoping this might help you.

    Thank you

  • Verified answer
    Jie G Profile Picture
    Jie G on at
    RE: Cache lookup property

    Hi @rp@n,

    The CacheLookup property of the table defines how and when records are cached as shown in the following table in this link:  docs.microsoft.com/.../single-record-caching  You can find answer to this question in the "CacheLookup Property" section.

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,848 Most Valuable Professional on at
    RE: Cache lookup property

    Not at all. As usual, you can find the explanation in documentation: Single-record Caching.

    You would get answers quicker and save others' time if learned to consult AX documentation.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans