Try executing this code in your case form OnLoad function:
function GetCompletedActivities() {
//set the path to the odata rest service
//this can be hardcoded using the Organization Rest Service URL under Customizations->Developer Resources
var odataPath = "https://" + window.location.host + "/XRMServices/2011/OrganizationData.svc";
//get the parent account lookup
var caseid = Xrm.Page.data.entity.getId();
//set up the odata query
var retrieveReq = new XMLHttpRequest();
var odataQuery = odataPath + "/ActivityPointerSet?$select=ActivityId,StateCode&$filter=StateCode/Value eq 1 and RegardingObjectId eq guid'" + caseid + "'";
retrieveReq.open("GET", odataQuery, false);
//make sure we get json back
retrieveReq.setRequestHeader("Accept", "application/json");
retrieveReq.setRequestHeader("Content-Type", "application/json; charset=utf-8");
//request/response will execute asynchronously, so we need a callback function
retrieveReq.onreadystatechange = function () { HasClosedActivity(this); };
//send the request
retrieveReq.send();
}
//callback function to parse the response and react accordingly
function HasClosedActivity(retrieveReq) {
//4 means a complete response
if (retrieveReq.readyState == 4) {
//parse response to json
var retrieved = this.parent.JSON.parse(retrieveReq.responseText).d;
if(retrieved.length>0)
{
Xrm.Page.getAttribute("YOUR_CHECKBOX_NAME").setValue(true);
}
};
}
It uses OData to retrieve all completed activities that are linked to the case. Then it passes the array of retrieved records to a callback function. The callback function checks the length of the array, and if it is > 0, then it checks a checkbox on
the form. You could just as easily pop an alert message, put text in a field, disable/enable a field, etc.
I haven't actually checked that code completely, but I think it's at least pretty close.
Lucas Alexander
Twitter
Blog
