Category: CRM 2011

Hi,

We recently had a requirement to implement filtering on Add Existing lookup button for 1-n relationship.

This is the post that helped us to implement it.

http://sliong.wordpress.com/2012/06/22/crm-2011-filtered-lookup-for-add-existing-button-for-one-to-many-relationship-crmformsubmit-is-undefined/

Only change was in the name of the getParameter function.

function
replaceAddExistingButtonView(params) {

    var
relName = params.gridControl.getParameter(“relName”),

    var roleOrd = params.gridControl.getParameter(“roleOrd”),

instead of getParameter it is now GetParameter (capital G)

Bye.

Hi,

Was working on Filtering Add Exiting Lookup and got the below error.

Here we need to make sure that we are referencing correct columns in the fetchxml and layoutxml while creating the view using JavaScript.

fetchXml: “<fetch
version=‘1.0‘
output-format=‘xml-platform‘
mapping=‘logical‘
distinct=‘false‘>” +

“<entity name=‘new_mycustomentity‘>” +

“<attribute name=‘new_customentityid‘ />” +

“<attribute name=‘new_name‘/>” +

“<order attribute=‘new_name‘ descending=‘false‘ />” +

“<filter type=‘and‘>” +

“<condition attribute=‘new_name‘ operator=‘like‘ value=‘%1%‘ />” +

“</filter>” +

“</entity>” +

“</fetch>“,

layoutXml: “<grid name=‘resultset‘ object=‘10001‘ jump=‘new_name‘
select=‘1‘ icon=‘1‘ preview=‘1‘>” +

“<row name=‘result‘ id=‘new_customentityid’>” + “<cell name=‘new_name‘ width=‘300‘ />” +

“</row>” +

“</grid>“,

Hope it helps.

Hi,

Have a look at this awesome set of Visio Stencils for CRM 2011.

http://appstencils.codeplex.com/

Bye.

Hi,

Below is the code that we can use to update user’s work hours for a specific day. Here we are setting the work hours of the user to be starting from 2 to ending at 7 p.m. for 1^st of April.

IServiceManagement orgServiceManagement =
 ServiceConfigurationFactory.CreateManagement(new Uri("https://mycrm.crm5.dynamics.com/XRMServices/2011/Organization.svc"));

AuthenticationCredentials authCredentials = new AuthenticationCredentials();
 authCredentials.ClientCredentials.UserName.UserName = "username@onmicrosoft.com";
 authCredentials.ClientCredentials.UserName.Password = "password";
 AuthenticationCredentials tokenCredentials = orgServiceManagement.Authenticate(authCredentials);

OrganizationServiceProxy organizationProxy = new OrganizationServiceProxy(orgServiceManagement, tokenCredentials.SecurityTokenResponse);
 // Get the user id
 Guid userid = ((WhoAmIResponse)organizationProxy.Execute(new WhoAmIRequest())).UserId;

// Get the calendar id of the user
 Entity systemUserEntity = organizationProxy.Retrieve("systemuser", userid, new ColumnSet(new String[] { "calendarid"}));


// Retrieve the calendar of the user
 Entity userCalendarEntity = organizationProxy.Retrieve("calendar", ((Microsoft.Xrm.Sdk.EntityReference)(systemUserEntity.Attributes["calendarid"])).Id, new ColumnSet(true));

// Retrieve the calendar rules defined in the calendar
 EntityCollection calendarRules = (EntityCollection)userCalendarEntity.Attributes["calendarrules"];

// Create a new inner calendar
 Entity newInnerCalendar = new Entity("calendar");
 newInnerCalendar.Attributes["businessunitid"] = new EntityReference("businessunit", ((Microsoft.Xrm.Sdk.EntityReference)(userCalendarEntity["businessunitid"])).Id);
 Guid innerCalendarId = organizationProxy.Create(newInnerCalendar);

// Create a new calendar rule and assign the inner calendar id to it
 Entity calendarRule = new Entity("calendarrule");
 calendarRule.Attributes["duration"] = 1440;
 calendarRule.Attributes["extentcode"] = 1;
 calendarRule.Attributes["pattern"] = "FREQ=DAILY;COUNT=1";
 calendarRule.Attributes["rank"] = 0;
 calendarRule.Attributes["timezonecode"] = 190;
 calendarRule.Attributes["innercalendarid"] = new EntityReference("calendar", innerCalendarId);

// starting at 12:00 on 1 April
 calendarRule.Attributes["starttime"] = new DateTime(2013, 4, 2,0,0,0,DateTimeKind.Utc);
 calendarRules.Entities.Add(calendarRule);

// assign all the calendar rule back to the user calendar
 userCalendarEntity.Attributes["calendarrules"] = calendarRules;
 // update the user calendar entity that has the new rule
 organizationProxy.Update(userCalendarEntity);

Entity calendarRule1 = new Entity("calendarrule");

// duration of 5 hours
 calendarRule1.Attributes["duration"] = 300;
 calendarRule1.Attributes["effort"] = 1.0;
 calendarRule1.Attributes["issimple"] = true;

// offset 120 i.e. 2 hours from start time (12:00)
 calendarRule1.Attributes["offset"] = 120;
 calendarRule1.Attributes["rank"] = 0;
 calendarRule1.Attributes["subcode"] = 1;
 calendarRule1.Attributes["timecode"] = 0;
 calendarRule1.Attributes["timezonecode"] = -1;
 calendarRule1.Attributes["calendarid"] = new EntityReference("calendar", innerCalendarId);

EntityCollection innerCalendarRules = new EntityCollection();
 innerCalendarRules.EntityName = "calendarrule";
 innerCalendarRules.Entities.Add(calendarRule1);

newInnerCalendar.Attributes["calendarrules"] = innerCalendarRules;
 newInnerCalendar.Attributes["calendarid"] = innerCalendarId;
 organizationProxy.Update(newInnerCalendar);

Hope it helps.