Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2016 where are Fil...
Microsoft Dynamics CRM (Archived)

CRM 2016 where are FilteredPost and FilteredPostComment

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

I have a task that create SSRS report to show Post, PostComment, Annotation (aka Note), and Activity (aka ActivityPointer) in chronical order.

I found there are 2 set of views. One with the above names, the other with "Filtered" prefixed. However, I can't find the FilteredPost and FilteredPostComment. It is fine since I have system admin and owner of the database and I can execute the report under my credential, but non-system admin user can't and all my user are non-sys-admin.

So I am curious that if we have FilteredAnnotaion, FilteredActivityPoint then why don't CRM include these 2 views out of the box?

Can I manually create these 2 views and grant select only access to database role CRMReaderRole? I know that CRM don't want to support direct database access, but do I have other choice?

I'm using CRM on-premise

Thanks,

Sam

*This post is locked for comments

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,323 Most Valuable Professional on at
    RE: CRM 2016 where are FilteredPost and FilteredPostComment

    I rechecked how it work and it seems that Microsoft instead of FilteredView for Posts uses stored procedures like p_retrieveposts.

    I'm in agreement with Ivan - you should not touch CRM DB. Alternatively you can create additional DB and use cross-DB queries to get access to posts and comments from CRM DB.

  • Suggested answer
    Ivan Ficko Profile Picture
    Ivan Ficko 1,380 on at
    RE: CRM 2016 where are FilteredPost and FilteredPostComment

    It's not recommended to manually alter "*_MSCRM" database because you could make a pretty big mess there and trust me it's really BIG mess then. Maybe it's a better idea to make a staging database in this case.

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans