Dynamics Community Forum Thread Details

odata query with null results

Hi,

I am writing an oData query which can result null values. If the result is a null value, I would like to show/hide some fields. But my script fails to do so. Someone please take a look at it and let me know what could be the reason.



function getUserCounty(userId) {
debugger;


var createdOn=Xrm.Page.getAttribute("createdon").getValue();
                if(createdOn!=null)
                {
                return; 
                }

	    var serverUrl = Xrm.Page.context.getClientUrl();
	    var ODataPath = serverUrl + "/XRMServices/2011/OrganizationData.svc"; 
	    var userRequest = new XMLHttpRequest(); 
	    userRequest.open("GET", ODataPath + "/SystemUserSet(guid'" + userId + "')", false); 
	    userRequest.setRequestHeader("Accept", "application/json"); 
	    userRequest.setRequestHeader("Content-Type", "application/json; charset=utf-8"); 
	    userRequest.send();
	    if (userRequest.status === 200) {
	    var retrievedUser = JSON.parse(userRequest.responseText).d; 
            var county = retrievedUser.new_county; 

return county;
}
	    else {
	        return "error";
	    }
	}

		
		var owner = Xrm.Page.getAttribute("ownerid").getValue();
		if(owner!=null) {
		var ownerId = owner[0].id;
		var county = getUserCounty(ownerId);

if(county!=null)//county with null value passes this condition which it shouldn't
		{

		var countyValue = new Array();
		countyValue[0] = new Object();
		countyValue[0].id = county.Id;
		countyValue[0].name = county.Name;
		countyValue[0].entityType = county.LogicalName;

		Xrm.Page.getAttribute("new_county").setValue(countyValue);
		}
else//it never shows this field for a null county
{

Xrm.Page.ui.controls.get("new_formField").setVisible(true);
}

		}

Thanks.

Quick Links