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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / UserQuery Table versus...
Customer experience | Sales, Customer Insights,...
Answered

UserQuery Table versus FilteredUserQueryView

(0) ShareShare
ReportReport
Posted on by Seamus 1,577

Hello, 

I am trying to migrate CRM Personal Views from 2013 onpremise to D365. The FilteredUserQuery View returns only a fraction of the data returned by querying the UserQuery Table.

Does anyone know what the difference is? More specifically a User has only one query in the FilteredUserQuery yet she has all her views including the single one displayed in FilteredUserQuery in the UserQueryTable - which seems to correspond to what she sees in her Saved Contact Views. 

I am hoping to use The View Transfer Tool (XRM Toolbox) - it works well but again only displays a fraction of the User Queries - presumably because it also FilteredUserQuery as its source, whereas I need to get access to all the Views referenced in the UserQuery Table,

I hope this makes sense - thanks in advance for any assistance.

- Seamus

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello Seamus,

    Have you tried this plugin - www.xrmtoolbox.com/.../

    I developed that plugin and used it migration projects.

  • Seamus Profile Picture
    Seamus 1,577 on at

    Thanks Andrew - sounds perfect. I will try it and let you know.

  • Justinp Profile Picture
    Justinp 175 on at

    All filter views filter by the logged in users permissions/security role.

    You look at the table that will give you all the records.

    XRM Toolbox tool works very well.

  • Seamus Profile Picture
    Seamus 1,577 on at

    Thanks. I am looking at the database directly. One of our Users has 100s of personal views, all of which appear in the Table but only 5 of which appear in the FilteredView and also the XRM ToolBox View Transfer tool.  Therefore, unless I have configured it incorrectly, if the tool only allows me to migrate 5 out of 100s of personal views then I could not rate that as working very well.

  • Suggested answer
    Justinp Profile Picture
    Justinp 175 on at

    Interesting, here is my hypothesis,

    I am guessing you have looked at or are looking at:

     -- SQL Table behind user created user views

     SELECT *

     FROM [mscf_dev_MSCRM].[dbo].[UserQueryBase]

     -- SQL View behind user created views

     SELECT *

     FROM [mscf_dev_MSCRM].[dbo].[FilteredUserQuery]

    And you are saying the results from the first query contain far more results than the second query?

    If this is the case then it is 100% a security thing... You are being prevented from seeing the views as you do not have rights to see them in the SQL filtered View

    Perhaps the user shared out the views you can see, and has not shared the views you can not see?

    Either way you will need to login with an account that has access to the views that need to be transferred.

    Can you get the user to share out one of the views you can not see, perhaps you can transfer it then?

  • Seamus Profile Picture
    Seamus 1,577 on at

    Thanks, yes you are right. I am logged in as a CRM system admin though?

  • Justinp Profile Picture
    Justinp 175 on at

    Hmmm, now that is an interesting twist.  The user with the systems administrator role should see all the views (I checked, I do) so long as you have the correct read write license, as you are seeing some I expect you have the correct license.  Just a shot, is your user missing membership to one of the CRM AD groups (SQLAccessGroup)?

  • Seamus Profile Picture
    Seamus 1,577 on at

    You are definitely right, Justin. Thanks! I checked the FilteredQuery View and what I see corresponds to the Personal Views which have been explicitly shared with me, so this is definitely a permissions issue, - as you identified early on. Re. The SQLAccessGroup do you know how I check if I'm in that group, - is it via the AD or Sql server mgmt studio? Many thanks again

  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    Any user (including System Administrators) only get user-level permission on the UserQuery entity - this is the mechanism used to have personal views, so a System Administrator would only see (either via the UI, or by querying the Filtered view) the views they own, or are shared with them.

    As far as I know, you'd need to use impersonation to impersonate each user in turn to read their views; I don't know if Andrew's tool includes this

  • Seamus Profile Picture
    Seamus 1,577 on at

    Thanks David. Do you know of any way I can use impersonation. I tried it with kingswaysoft and it still did not work.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 83 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans