Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Tile count not correct...
Finance | Project Operations, Human Resources, ...
Unanswered

Tile count not correct when query has a date range

(0) ShareShare
ReportReport
Posted on by ChosenSilver 50

I have a tile on a custom workspace that is showing a count of the underlying list data. Both the tile and the underlying list are based on the same AOT query. The query has a range on it for a datetime field, but the count on the tile seems to ignore this date. If I click on the tile, the list is showing the correct amount of records so it just seems to be the tile that is affected.

Is this a known issue, or is there something else that needs to be done for dates to effect the count? The only other threads I could find on this issue were from 2018 and no resolution was ever posted.

tile_5F00_count_5F00_vs.png

  • ChosenSilver Profile Picture
    ChosenSilver 50 on at
    RE: Tile count not correct when query has a date range

    Making this change does not seem to have corrected the issue. I currently have one record in the system that matches my Ranges and the count shows Zero on the tile, but if I click on the tile it takes me to the list with the one record showing.

    NOTE: Before making the change you suggested, the list was actually showing me Zero records when I clicked on the tile but looks to have been inserting a new record by default which I had been thinking was the one record I was expecting to see. The tile had been showing a count of 800. So it seems like your suggestion did actually fix a problem I didn't realize I had, but now the tile count shows Zero so the original issue is still unresolved.

  • Martin Dráb Profile Picture
    Martin Dráb 230,445 Most Valuable Professional on at
    RE: Tile count not correct when query has a date range

    The values looks wrong to me - there should be extra parenthesses around the method: (currentDate()).

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

photo of Muhammad Affan

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

thumbnail image of a pie chart section

Top 10 leaders for November!

Congratulations to our November super stars!

thumbnail image of the word Tip

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans