Wednesday, March 16, 2011

CRM 2011 - Get and set Java Script Microsoft CRM 2011

Xrm.Page.getAttribute('statuscode').getValue()
Xrm.Page.getAttribute('statuscode').setValue(1)


Set value in picklist type :
Xrm.Page.getAttribute('statuscode').setValue(1).getSelectOption().text


Nicola Grillo

Friday, February 18, 2011

SQL SERVER - Database Suspected in SQL Server 2008

Connected to your database and check if it is in emergency mode, else run this comand:
ALTER DATABASE DB_NAME SET EMERGENCY
set single user in the database property and run this command:
DBCC CHECKDB ('DB_NAME',REPAIR_ALLOW_DATA_LOSS)

Nicola Grillo

Tuesday, January 11, 2011

CRM 4.0 - Assign entity using Javascript CRM 4.0


function assign(userid,recordid){
  var header = GenerateAuthenticationHeader();

  var target = "TargetOwned<Entityname>";
  var xml = "" +
  "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
  "<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
  header +
  "  <soap:Body>" +
  "    <Execute xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
  "      <Request xsi:type=\"AssignRequest\">" +
  "        <Target xsi:type=\""+ target +"\">" +
  "          <EntityId>"+ recordid +"</EntityId>" +
  "        </Target>" +
  "        <Assignee>" +
  "          <PrincipalId xmlns=\"http://schemas.microsoft.com/crm/2006/CoreTypes\">"+ userid +"</PrincipalId>" +
  "          <Type xmlns=\"http://schemas.microsoft.com/crm/2006/CoreTypes\">User</Type>" +
  "        </Assignee>" +
  "      </Request>" +
  "    </Execute>" +
  "  </soap:Body>" +
  "</soap:Envelope>" +
  "";
  var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
  xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
  xmlHttpRequest.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Execute");
  xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
  xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
  xmlHttpRequest.send(xml);

  var resultXml = xmlHttpRequest.responseXML;

 }


Nicola Grillo