web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / What's difference ...
Microsoft Dynamics CRM (Archived)

What's difference between an entity filtered view & entity view

(0) ShareShare
ReportReport
Posted on by Alaa Ramadan 4,130

I have a custom entity named Event, when I try to retrieve an Event datetime from CRM database through a custom app, it return a wrong date.

There are two views, one is: FilteredNew_Event, the other one New_Event

FilteredNew_Event return the correct date, but my custom application is not using windows authentication

New_Event: return the date time in UTC format, but even after converting (-4 Hour) for my time zone, with some records it return a datetime with one hour difference 

It’s very confusing; any help will be really appreciated

Alaa

*This post is locked for comments

I have the same question (0)
  • mesfin Profile Picture
    mesfin 285 on at

    My understanding is that you should think of the entity view as the server view of that data while the filtered view is what a user would consume.  I'm not sure on how you are using the data but when you are doing reports or sending data back out to an end user you will always want to use the filtered views.  They factor in security and in your case time zone, for the calling user.  

  • tkh Profile Picture
    tkh 60 on at

    By default, CRM stores datetime in UTC time. Using filtered views enable the timezone conversion base on the executing user's timezone setting.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans