Archives by Tag 'sql'

Adding the queue name to a saved advanced find for cases (incidents)

By Carlton Colter - Last updated: Thursday, February 18, 2010

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 Carlton Colter - Last updated: Monday, June 15, 2009

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

By Carlton Colter - Last updated: Tuesday, February 10, 2009

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

By Carlton Colter - Last updated: Wednesday, February 4, 2009

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