Code for creation of new view:

 

System.String layoutXml =
@"<grid name='resultset' object='3' jump='name' select='1' 
    preview='1' icon='1'>
    <row name='result' id='opportunityid'>
    <cell name='name' width='150' /> 
    <cell name='customerid' width='150' /> 
    <cell name='estimatedclosedate' width='150' /> 
    <cell name='estimatedvalue' width='150' /> 
    <cell name='closeprobability' width='150' /> 
    <cell name='opportunityratingcode' width='150' /> 
    <cell name='opportunitycustomeridcontactcontactid.emailaddress1' 
        width='150' disableSorting='1' /> 
    </row>
</grid>";

                    System.String fetchXml =
                    @"<fetch version='1.0' output-format='xml-platform' 
    mapping='logical' distinct='false'>
    <entity name='opportunity'>
    <order attribute='estimatedvalue' descending='false' /> 
    <filter type='and'>
        <condition attribute='statecode' operator='eq' 
        value='0' /> 
    </filter>
    <attribute name='name' /> 
    <attribute name='estimatedvalue' /> 
    <attribute name='estimatedclosedate' /> 
    <attribute name='customerid' /> 
    <attribute name='opportunityratingcode' /> 
    <attribute name='closeprobability' /> 
    <link-entity alias='opportunitycustomeridcontactcontactid' 
        name='contact' from='contactid' to='customerid' 
        link-type='outer' visible='false'>
        <attribute name='emailaddress1' /> 
    </link-entity>
    <attribute name='opportunityid' /> 
    </entity>
</fetch>";

                    SavedQuery sq = new SavedQuery
                    {
                        Name = "A New Custom Public View",
                        Description = "A Saved Query created in code",
                        ReturnedTypeCode = "opportunity",
                        FetchXml = fetchXml,
                        LayoutXml = layoutXml,
                        QueryType = 0
                    };
                    
                    _customViewId = _serviceProxy.Create(sq);
                    Console.WriteLine("A new view with the name {0} was created.", sq.Name);

 

Interesting links @mscrm :

A To Z Crm: 
http://madcomputerist.blogspot.com/2011/06/new-features-in-microsoft-dynamics-crm.html

http://www.alticoadvisors.com/clients/dynamics-crm-tips-and-tricks.aspx



Crm Tools:
http://manishmistry.wordpress.com/2012/09/17/85-codeplex-projects-related-to-ms-crm-development/


Javascript reference:
http://garethtuckercrm.com/2011/03/16/jscript-reference-for-microsoft-dynamics-crm-2011/


Crm  XRM.Page objects access from Silverlight:

http://arvindcsit.wordpress.com/2011/12/27/interacting-silverlight-with-crm-forms/


MSCRM  SDK Message sample code:

http://mileyja.blogspot.in/p/microsoft-dynamics-crm-2011-sdk-example.html


MSCRM Usefull links:
http://blogs.msdn.com/b/crmindia/archive/2012/02/27/useful-links-for-crm-2011.aspx

Hiding navigation pane in mscrm2011:

Javascript approach:

//Ensure navitem is "quoted" to represent string
// bool: true = Visible, false = removed
var objNavItem = Xrm.Page.ui.navigation.items.get(navitem);
objNavItem.setVisible(bool);

C# code approach:

/// Retrieve the sitemap

QueryExpression query = new QueryExpression();
query.EntityName = "sitemap";
query.ColumnSet = new Microsoft.Xrm.Sdk.Query.ColumnSet(true);

EntityCollection col = _service.RetrieveMultiple(query);

Entity sitemap = null;
if (col != null && col.Entities.Count > 0)
   sitemap  = col.Entities[0];
 ///Parse the sitemap entity to an XDocument object
 string sitemapcontent = sitemap["sitemapxml"].ToString();
XDocument sitemapxml = XDocument.Parse(sitemapcontent);


You can now change the sitemap by modifying the sitemapxml object. After you made your changes, it's time to save these changes.

//// Update the sitemap
sitemap["sitemapxml"] = sitemapxml.ToString();
_service.Update(sitemap);


//// Publish the sitemap

PublishXmlRequest request = new PublishXmlRequest();
request.ParameterXml = "<importexportxml><sitemaps><sitemap></sitemap></sitemaps></importexportxml>";
_service.Execute(request);

converting Managed solution to Unmanaged solution Work around:

This is useful when we have only Managed solution to work with but needs some more customization. Extract the Solution Zip file, Open solution.xml file in notepad application. Search for Managed Tag (E.g.: <Managed>1</Managed>), Now change the value from 1 to 0 and zip the files again and import it. That’s it The Solution is changed to Unmanaged. This can be imported and customized as per the need.

 

CRM 2011 LINQ Operator Limitations:

.       from

–       Supports one from clause per query.

•          join

–       Represents an inner join. You cannot perform outer joins.

•          where

–      The left side of the clause must be an attribute name and the right side of the clause must be a value.

–      Supported String functions: Contains, StartsWith, EndsWith, and Equals.

•          groupBy

–      Not supported. FetchXML supports grouping options that are not available with the LINQ query provider.

–      For more information, see Use FetchXML Aggregation.

•          orderBy

–       Supports ordering by entity attributes, such as Contact.FullName.

•          select

–       Supports anonymous types, constructors, and initializers.

•          last

–       The last operator is not supported.

•          skip and take

–       Supports skip and take using server-side paging. The skip value must be greater than or equal to the take value.

•          aggregate

–       Not supported. FetchXML supports aggregation options that are not available with the LINQ query provider. For more information, see Use FetchXML Aggregation.

 

FetchXML syntax:

Legend:

•          Xxxx :=   à production

•          (   ) à choice

•          | à or

•          ? à optional

•          * à repeat

// à comments

 

FetchXml :=

  <fetch

    (page='page-number')? // start page default is 0

    (count='items-per-page')? // count default is 5000

    (utc-offset='utc-offset')? // utc-offset default is 0

    (mapping='logical')?

    (distinct = ('true' | 'false' | '1' | '0') )? //default false

    (paging-cookie='page-cookie')?

   >

    <entity name='entity-name'>

    Entity-Xml

    </entity>

  </fetch>

 

 Example:

<fetch page=‘10’ count=‘50’ distinct=‘true’

     page-cookie=‘Page1’>

    <entity name=‘account’ >

    …. Put Entity-Xml here ….

    </entity>

</fetch>

 

 

 

•          Entity-Xml :=

•          (<all-attributes/> | <no-attrs/> |Attribute-Xml* )

•            ( Filter-Xml |  LinkEntity-Xml |  Order-Xml )*

•          Attribute-Xml :=

•            <attribute name='attr-name'

•              (aggregate=(AggOp) alias='alias-name')?

•            />

•          AggOp :=

•          (avg | min | max | count(*) |count(attribute name))

•          Filter-Xml :=

•            <filter (type= ('or' | 'and'))? // default is 'and'  >

•            ( Condition-Xml | Filter-Xml )*

•            </filter>

•           

•          LinkEntity-Xml :=

•            <link-entity name = 'entity-name'

•              // to is the column on the remote entity

•              (to = 'column-name')? 

•              // from is the column on the local entity

•              (from = 'column-name')? 

•              (alias = 'table-alias')?

•              (link-type = ('natural' | 'inner' | 'outer'))?

•            >

•            Entity-Xml

•            </link-entity>

•          Order-Xml :=

•            <order attribute='attr-name'

•              (descending= ('true' | 'false' | '1' | '0')?

•            />