Hi guys,
With RetrieveMulitpleRecords, what exactly we need to use or write for the filter ? I am following this blog : https://carldesouza.com/retrieve-and-retrievemultiple-javascript-using-xrm-webapi/
but feel getting lost and lost. Have tried several way on the filter, by using schema name, entity set name, no name etc, but error after error returning until my head spinning already.
So the last script is like this ->
function retrieveJournal() {
//read lookup value
if (Xrm.Page.getAttribute("jm_serviceorder").getValue() != null && Xrm.Page.getAttribute("jm_serviceorder").getValue()[0].id != null)
{
var OrderId = Xrm.Page.getAttribute("jm_serviceorder").getValue()[0].id;
var OrderNum = Xrm.Page.getAttribute("jm_serviceorder").getValue()[0].name;
Xrm.Page.getAttribute("jm_description").setValue(OrderNum);
//pass entity, fields, we can use expand to get related entity fields
var Select = "?$select=jm_journalid";
var Filter = "&$filter=jm_serviceorder/jm_ServiceOrder eq "+ OrderId ;
Xrm.WebApi.retrieveMultipleRecords('jm_expensedetail', Select + Filter ).then(
function success(result) {
if (result != null) {
if (result.jm_journalid != null)
Xrm.Page.getAttribute("jm_journalid").setValue(result.jm_journalid);
}
},
function(error) {
alert(error.message);
}
);
}
}
With that script now, I get this error :
The problem, if I'm correct, is the filter string, what exactly I should use in order to satisfy this function ? and the field "jm_serviceorder" is a lookup type, same as the blog that I'm following.
Please help.
Thanks
