Tool Update : Searchable Property Updater for CRM 2011 (1.1.919.75)

One of my fellow MVP asked me for the possibility to display if an attribute is displayed on at least one entity form. This will ease the decision to make an attribute valid for advanced find.

I thought it was difficult because of the need to export a solution to get the xml of an entity forms.

But it can be achieved a lot more easily! Entity forms, in Microsoft Dynamics CRM 2011, are just like any other entity, so you can simply retrieve the forms with a simple QueryExpression (or QueryByAttribute, in my case).

The code sample:

QueryByAttribute qba = new QueryByAttribute("systemform");
qba.Attributes.AddRange("objecttypecode", "type");
qba.Values.AddRange(entityLogicalName, 2);
qba.ColumnSet = new ColumnSet(true);

EntityCollection ec = oService.RetrieveMultiple(qba);


So, this new version is much more useful since you can see easily if an attribute is used on a form, and you can also check only attributes used in at least one form by pressing a single button.


searchAttrPropUpdaterUpdate


As usual, you can download, review, discuss or log issue for this tool one codeplex

Comments

Jim Wang said…
Excellent, this tool works very well to me.

Thanks Tanguy!
October 20, 2011 at 9:24 PM
Scott Sewell said…
That's a very nice enhancement-
Thank you Tanguy!
October 31, 2011 at 3:01 PM
Post a Comment

Popular posts from this blog

New XrmToolBox plugin : Import/Export NN relationships

Image
Two plugins in one day! wow! This one was, in fact, developed a couple of months ago. One of my colleague was using a solution from my fellow MVP Andrii Butenko which allows to import/export NN relationships in a silverlight web resource. This was nice but my colleague was using other attributes than primary key to do the mapping and Andrii’s solution does not support this. So he asked me to develop a XrmToolBox’s plugin that could do this. And, here it is! You can select entities and relationships and moreover, choose mapping attributes on both enitities. I only let text and number attributes selectable as other does not really make sense for mapping purposes. Then you can import or export NN relationships! Here is a preview As usual, this plugin, among other, is available with XrmToolBox on CodePlex
Read more

Searchable Propery Attribute Updater

Image
Hi, The previous post was not the last one... :) You can find in this post the first tool that will make your life easier: Just remember when you customer asked you to remove all these unused attributes form the attribute list of the advanced find form... You navigated through all attrbutes form to modify the Searchable property of each attributes for hours... (maybe am I exaggerating a bit...) The program I give you allows you to update all attributes in a single winform application! Yes it can be! Do not hesitate to give me your comments about this program if you think improvements can be done... Download:
Read more

Full featured CRM grid in HTML/JS

Image
In last December, I was asked to write a web resource to display a grid with CRM records. I was quite frustrated because I didn’t succeed to manage some grid features easily like fixed header with horizontal scrolling among others. I delivered a fixed table which was not so bad but absolutely not something that look like the application grid views. So I decided to work harder to find a way to do this CRM style grid view. After some works (almost two full days), I have succeeded to create a full featured CRM grid view by using only JavaScript. Here is a screenshot: And this is how I can create a grid view from only a div in a HTML page < html > < head > < title > Page de test </ title > < script src ="json2.js"></ script > < script src ="jquery.js"></ script > < script src ="XrmServiceToolKit.js"></ script > < script src ="sdk.metadata.js"></ script > ...
Read more