Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Tile count not correct when query has a date range

(0) ShareShare
ReportReport
Posted on by 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

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

Product updates

Dynamics 365 release plans