Hi
I am trying to use the "$expand" to retrieve two columns from a different entity. Can't see what I am doing wrong.
The primary entity is "new_casedatasheettemplatemodel".
The secondary entity is "new_casemodel".
Here's my error message:

Here's my code:
function buildCaseModelSDK() {
var caseId = $("#form_caseid").val();
var caseDataSheetTemplateId = $("#form_casedatasheettemplateid").val();
if (caseId != null && caseDataSheetTemplateId != null) {
var iselect = "?$select=new_CaseId";
iselect += "&$expand=new_new_casemodel_new_casedatasheettemplatemodel_CaseModelId($select=new_ModelId,new_SampleGroupId)"
var ifilter = "&$filter=(new_CaseId/Id eq guid'" + caseId.replace(/{/g, "").replace(/}/g, "") + "'";
ifilter += " and new_CaseDataSheetTemplateId/Id eq guid'" + caseDataSheetTemplateId.replace(/{/g, "").replace(/}/g, "") + "'";
ifilter += ")";
var iorderby = "&$orderby=new_name";
var options = iselect + ifilter + iorderby;
SDK.REST.retrieveMultipleRecords("new_casedatasheettemplatemodel", options, buildCaseModelCallBack, function (error) { alert(error.message + "[" + options); }, buildCaseModelCompleted);
}
}
///---------------
function buildCaseModelCallBack(caseModels) {
var models = caseModels;
}
function buildCaseModelCompleted() {
}
*This post is locked for comments
I have the same question (0)