Archives by Tag 'sql'
Adding the queue name to a saved advanced find for cases (incidents)
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.
Click to continue reading
Click Here To View Post With Syntax Highlighting
QuickFind Active Or Resolved (Inactive) Cases
By default, CRM’s quick find, the find you use on any of the standard search pages, does not let you find inactive items. Here is way to modify the system views for an entity, like the QuickFind for Cases. I modified the criteria to allow text searches to search both active and inactive cases.
Click to continue reading
Click Here To View Post With Syntax Highlighting
Increasing Paging Limits
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%')
Click Here To View Post With Syntax Highlighting
CRM 4 UserQuery Privileges for System Administrators
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.
Click to continue reading
Click Here To View Post With Syntax Highlighting