welcome to XRM blog

Keep in touch with latest CRM/ERP articles

To remain competitive your organisation must be efficient across the business process spectrum. To do so you need to take sound decisions based on a balance between the cost and risk. To do so you will be heavily dependent on your content management in itself needs...

image
Blog

MS CRM 2011 Retrieving Entity Type Code or ETC

By xrmlabs webmaster on 4/19/2013
If you are looking to get the Entity Type Code or ETC (as it is generally known as) dynamically for any entity name in your web resource in MS CRM, you should use the MetaData service to do so. The MetaData service in MS CRM 2011 will retrieve all the Meta information about an entity. This information includes the display name of the entity, the logical name of the entity and all other information about its relationship status etc. However the information that we are interested in here is the "ObjectTypeCode". 

How to build your MetaData service? For building a MetaData service you can use sample code provided in the CRM SDK itself. (samplecode\js\soapforjscript\soapforjscript\scripts). The name of the file is sdk.metadata.js.
This javascript file has a function by name RetrieveAllEntitiesAsync. This function fetches all the entities with with their MetaData information. On success this function returns you entityMetadataCollection. Now all you need to do is to loop over entities and get the Object Type Code. Please follow the code below to get the Object Type Code or ETC.

function successRetrieveAllEntities(entityMetadataCollection) {
   for (var i = 0; i < entityMetadataCollection.length; i++) {
      var entity = entityMetadataCollection[i];
      var objTypeCode = entity.objectTypeCode;
   }
}

This is a supported way of getting etc or ObjectTypeCode of an entity. 
Hope this helps. 
Javascript
Entity Type Code
Javascript
MetaData service
MS CRM 2011
ObjectTypeCode

Auditing: An Out Of Box feature of Microsoft Dynamic CRM 2011

By xrmlabs webmaster on 3/30/2013

Audit History is an Out Of Box functionality of Microsoft CRM 2011 that is used to track the changes in a whole entity or particular fields on entity. For example you can track that who has changed address field of a contact record, what is old & new value of address & when it has been changed etc. You can see these by going to “Audit History” in the left pane of an entity in which auditing is enabled.

Auditing
MS CRM 2011

Dynamic Dropdownlist in ASP.NET by a text file

By xrmlabs webmaster on 3/26/2013

Dynamic Dropdownlist in ASP.NET by a text file  

.Net
ASP.NET Dynamic Drop down list

Manage Relationship Behavior in Dynamic CRM 2011

By xrmlabs webmaster on 3/26/2013

This blog article is all about relationship behaviour between two MS CRM 2011 entities. We all know that in Dynamic CRM 2011 there are three type of relationship they are 1: N, N: 1 and N: N but little is know about the relationship behaviour that each of these relationship type possesses. There are four relationship behaviour in CRM 2011. The relationship behaviour feature of MS CRM controls the resulting action that will happen if a related entity record is deleted, Assigned, Shared, Unshared, Reparent and Merged. These behaviours can be controlled by going to settings of the relationship. 

MS CRM 2011
Relationship
Relationship Behavior

Use Fetch Xml for query in Plug-in

By xrmlabs webmaster on 3/26/2013

Fetch XML is a really handy way of retrieving data from CRM. It is easy to construct complex query and really simple to execute. In this blog article I will explain how you can execute fetch XML query in Dynamic CRM 2011 or CRM online. To start you will first need to download a fetch xml from advanced find and then use the RetrieveMultiple method of the CRM Service to execute the Fetch XML.

First go to Advanced d find and select the entity on which you need to make query





Following is the fetchxml retrieve from Advance Find:

String fetchXml = @"'1.0'?>
'false' mapping='logical' output-format='xml-platform' version='1.0'>
   'contact'>
          'telephone'/>
          'lastname'/> 'firstname'/>
                                  'contactid'/> 'false' attribute='telephone'/>                                 'and'>
                                     'vdbwc1_vip' value='1' operator='eq'/>
                  
  
 ";

All now that is left is to send a fetch request. This can simply be done by using the following code.

EntityCollection EC = _service.RetrieveMultiple(new FetchExpression(fetchXml));
 
if (EC != null && EC.Entities != null && EC.Entities.Count >= 1)
{
     foreach (Entity E in EC.Entities)
     {
         Guid entityId = E.Id;
     }
}


Above code shows how RetrieveMultiple method is used to retrieve EntityCollection from fetchxml.
Hope this helps. Happy Coding !!

.Net
Fetch XML
MS CRM 2011
Plugin

Auto refresh window form/application in every minutes

By xrmlabs webmaster on 3/25/2013

Step  1->Open Visual Studio 2010/2008 and open Project, give the name of project and click OK like this Step 2->Put Label and put this code in  .cs file of project public Form1()         {                        InitializeComponent();             System.Windows.Forms.Timer MyTimer = new System.Windows.Forms.Timer();             MyTimer.Interval = (1 * 60 * 1000); // 1 mins             MyTimer.Tick += new EventHandler(MyTimer_Tick);             MyTimer.Start();         } And generate event for MyTimer_Tick and paste this code ...

.Net
ASP.NET
C#
VS 2010
Window Application

Adrotator in ASP.NET

By xrmlabs webmaster on 3/21/2013

                                              Adrotator in ASP.NET   By the AdRotator   control you can change the look of  your home page . The control is very simple and the wonderful thing is that you  don’t need to write the code in code behind file . A Xml file is needed  for the reference of images which are to be displayed on the home page or anywhere else one more beneficial thing is that you can hyperlink to each image  so a new window is opened  and you can acquire the benefit of advertisement also basically it is meant for the advertisement .Due to the reference of images are written in xml file so it can be easily modified.

.Net
ASP.NET Adrotator

DNN Grid Read more button in a column

By xrmlabs webmaster on 3/21/2013

DNN Grid Read more button in a column

DotNetNuke
Dotnetnuke Gridview

ASP.NET Date Manipulation

By xrmlabs webmaster on 3/20/2013

ASP.NET Date Manipulation

.Net
ASP.NET
C#
Date manipulation

Useful SQL server expression (SSRS) for Date & Time conversion

By xrmlabs webmaster on 3/14/2013

Basic idea of this article is to use of SQL server expression to convert  and get date& time fromat.

SQL Server string to date / datetime conversion: 



 String date conversion (Without century (yy)): convert string to datetime
 

  Convert string to date&time

  Day (Mon) types are nondeterministic conversions:
 

  SQL server datetime format (mon dd yyyy hh:mm:ss:mmmAM (or PM))

Date format (ISO) works  international standard

SQL Sever
SQL Server 2008
SSRS
Blog Calendar
Blog Calendar List
2025 Oct  12  5
2025 Sep  50  7
2025 Aug  32  4
2025 Jul  18  9
2025 Jun  23  6
2025 May  63  9
2025 Apr  35  6
2025 Mar  66  7
2025 Feb  41  6
2024 Nov  12  1
2024 Aug  8  1
2024 Apr  61  4
2024 Mar  176  4
2024 Feb  528  3
2024 Jan  36  7
2023 Dec  45  6
2023 Nov  698  5
2023 Oct  933  12
2023 Sep  2122  9
2023 Aug  654  6
2023 Jul  49  6
2023 Jun  27  4
2023 May  45  5
2023 Apr  92  5
2023 Mar  233  6
2023 Feb  180  5
2023 Jan  96  4
2022 Dec  98  7
2022 Nov  305  2
2022 Sep  14  1
2022 Aug  32  2
2022 Jun  11  2
2022 May  6  2
2022 Apr  12  2
2022 Mar  2  1
2022 Feb  2  1
2022 Jan  1  1
2021 Dec  4  1
2021 Nov  2  1
2021 Oct  2  1
2021 Sep  14  1
2021 Aug  49  5
2021 Jul  53  4
2021 Jun  1931  5
2021 May  43  3
2021 Apr  2284  3
2021 Mar  217  5
2021 Feb  2871  7
2021 Jan  4310  9
2020 Dec  625  7
2020 Sep  85  3
2020 Aug  795  3
2020 Jul  139  1
2020 Jun  104  3
2020 Apr  109  3
2020 Mar  19  2
2020 Feb  34  5
2020 Jan  48  7
2019 Dec  18  4
2019 Nov  42  1
2019 Jan  23  2
2018 Dec  156  4
2018 Nov  68  3
2018 Oct  18  3
2018 Sep  1306  11
2018 Aug  7  2
2018 Jun  21  1
2018 Jan  74  2
2017 Sep  591  5
2017 Aug  17  1
2017 Jul  17  2
2017 Jun  65  2
2017 May  21  1
2017 Apr  40  2
2017 Mar  145  4
2017 Feb  872  4
2016 Dec  213  3
2016 Nov  1116  8
2016 Oct  358  10
2016 Sep  835  6
2016 Aug  40  1
2016 Jun  1899  6
2016 May  118  3
2016 Jan  73  2
2015 Dec  784  6
2015 Nov  4  1
2015 Oct  13  1
2015 Sep  1475  6
2015 Aug  14  1
2015 Jul  129  2
2015 Jun  11  1
2015 May  20  1
2015 Apr  30  3
2015 Mar  80  3
2015 Jan  5350  4
2014 Dec  18  1
2014 Nov  2260  4
2014 Oct  69  1
2014 Sep  107  2
2014 Aug  5345  1
2014 Jul  49  2
2014 Apr  2606  12
2014 Mar  308  17
2014 Feb  223  6
2014 Jan  1510  16
2013 Dec  21  2
2013 Nov  695  2
2013 Oct  256  3
2013 Sep  13  1
2013 Aug  40  3
2013 Jul  214  1
2013 Apr  62  6
2013 Mar  2406  10
2013 Feb  131  3
2013 Jan  353  2
2012 Nov  63  2
2012 Oct  520  10
Tag Cloud
Interested in our services? Still not sure about project details? get a quote