MSCRM Blogger

Unfortunately, CRM does not currently support adding the queue to a case advanced find. However, that doesn’t mean it can’t be done. Follow the steps in this article to modify your fetchXML and your layoutXML to have the queue name show up in the advanced find.

Here is a video tutorial of how to take a case advanced find, edit the query, troubleshoot errors in SQL Management Studio, and update your excel query.

Paging Limits control how many items show up on the list pages in crm. Most notably advanced finds. I like to be able to display a lot of information, and I need to be able to run operations on more than 250 items. Using the following SQL query I was able to increase my paging limit to 1000.

UPDATE UserSettings SET PagingLimit=1000 WHERE SystemUserId IN
(Select SystemUserId from SystemUserBase WHERE FullName like 'Carlton%')

The CRM 4 System Administrators group does not have access to assign other people’s saved advanced finds (user queries). I have created a single aspx page that uses the CRM SDK to allow a system administrator to assign any user’s saved view to another user.