How to remove the current case from the results retrieved by Web API

(0) Share

Report

Posted on by D365Admin

Hi,

I am working on showing sibling cases whose parent is same by retrieving the child cases based on parent case using WebAPI retrieve where I would like to remove the current case from the list of results returned.

For example: Lets say...I have

Parent Case ABC got three child cases Test1, Test2 and Test 3.

If I am on Test 2 case, I would like to see...Test1 and Test3 cases as sibling cases but not all three of them. At present, I am retrieving all the three cases based on parent case but I would like to remove the current case from the list returned. Could someone please suggest me is there any way to achieve this. Thanks

All responses (3)

Answers (2)

D365Admin 77 on at

Like (1)

Report

RE: How to remove the current case from the results retrieved by Web API

It worked. Thank you.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to remove the current case from the results retrieved by Web API

Hi D365Admin,

As Andrew Butenko said, the request url should be like this: var url = [organization URI] + "/api/data/v9.2/incidents?$select=title&$filter=parentcaseid/incidentid eq " + parentCaseID + " and incidentid ne " + caseID;

Here is my ajax request sample :

function openUrl(executionContext) {
var parentCaseID = "xxx";
var caseID = "xxx";
var url = "[organization URI]" + "/api/data/v9.2/incidents?$select=title&$filter=parentcaseid/incidentid eq " + parentCaseID + " and incidentid ne " + caseID;
var request = new XMLHttpRequest();
request.open("get", url , true);
request.setRequestHeader("OData-MaxVersion", "4.0");
request.setRequestHeader("OData-Version", "4.0");
request.setRequestHeader("Accept", "application/json");
request.setRequestHeader("Content-Type", "application/json; charset=utf-8");
request.onreadystatechange = function () {
if (request.readyState === 4) {
console.log(JSON.parse(request.responseText));
}
}
request.send();
}
Verified answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: How to remove the current case from the results retrieved by Web API

Hello,

I believe you have the id of the current incident and id of the parent case so the query should look like "Select cases where parent case id equals PARENTCASEID and case id is not equal Test2. Should be simple enough.