locked
What is FilteredView and how to create it ?? RRS feed

  • Question

  • Hello All,

         What is the exact defination of FilteredView and how to creat it ??  Please provide your thoughts on this or any links to get the information on this would be much arrpicated.

    Thank you .

    Thursday, February 16, 2012 11:42 AM

Answers

  • Hello Pradeep Poojary ...

       Filtered view is a SQL View which can be used to Query CRM Data.

       The best part of Filtered View is that enforces CRM Security ..

      i.e. it uses the current user context who is executing it and reterive those record which he has access rights to it.

        You dont create a Filtered View.

       CRM creates it for you .. For Every entity there is one Filtered View ...

       Even when you create a Custom Entity it would be Create a new FilterView

    hth

    dkay

    If the problem is resolved, we would appreciate a post explaining the resolution and mark the post answered and close the thread.

    • Proposed as answer by D kay Thursday, February 16, 2012 12:02 PM
    • Marked as answer by Pradeep47 Thursday, February 16, 2012 12:25 PM
    Thursday, February 16, 2012 12:02 PM

All replies

  • Hello Pradeep Poojary ...

       Filtered view is a SQL View which can be used to Query CRM Data.

       The best part of Filtered View is that enforces CRM Security ..

      i.e. it uses the current user context who is executing it and reterive those record which he has access rights to it.

        You dont create a Filtered View.

       CRM creates it for you .. For Every entity there is one Filtered View ...

       Even when you create a Custom Entity it would be Create a new FilterView

    hth

    dkay

    If the problem is resolved, we would appreciate a post explaining the resolution and mark the post answered and close the thread.

    • Proposed as answer by D kay Thursday, February 16, 2012 12:02 PM
    • Marked as answer by Pradeep47 Thursday, February 16, 2012 12:25 PM
    Thursday, February 16, 2012 12:02 PM
  • Thanks for the quick reply .   it was helpful  :)
    Thursday, February 16, 2012 12:25 PM