{"metadata":{"image":[],"title":"","description":""},"api":{"url":"","auth":"required","method":"post","params":[],"results":{"codes":[]},"settings":"","examples":{"codes":[]}},"next":{"description":"","pages":[]},"title":"Example query 3: Find cases with given age at diagnosis","type":"endpoint","slug":"example-query-3-find-cases-with-given-age-at-diagnosis","excerpt":"<a href=\"query-datasets\" style=\"color:#132c56\">QUERY DATASETS</a> > <a href=\"about-the-datasets-api\" style=\"color:#132c56\">About the Datasets API</a> > <a href=\"query-via-the-datasets-api\" style=\"color:#132c56\">Query via the Datasets API</a> > Example query 3: find cases with...","body":"Use the following query to see all cases for which the age at diagnosis is between 10 and 50.\n\n\n[block:code]\n{\n \"codes\": [\n {\n \"code\": \"POST /datasets/tcga/v0/query HTTP/1.1\\nHost: cgc-datasets-api.sbgenomics.com\\nX-SBG-Auth-Token: 3210a98c1db9304ea9d9273156740f74\",\n \"language\": \"http\",\n \"name\": \"Request\"\n }\n ]\n}\n[/block]\n\n[block:code]\n{\n \"codes\": [\n {\n \"code\": \"{\\n \\\"entity\\\":\\\"cases\\\",\\n \\\"hasAgeAtDiagnosis\\\": {\\n \\\"filter\\\": {\\n \\\"gt\\\": 10,\\n \\\"lt\\\": 50\\n }\\n }\\n}\",\n \"language\": \"json\",\n \"name\": \"Request body\"\n }\n ]\n}\n[/block]\nNote that the value of the metadata field `hasAgeAtDiagnosis` is a dictionary containing the key `filter`, whose value is a further dictionary with keys `gt` (greater than) and `lt` (less than) for the upper and lower bounds to filter by.\n[block:callout]\n{\n \"type\": \"success\",\n \"body\": \"You can use either integers or strings (like `\\\"10\\\"`) as the upper and lower bounds in `filter`, in the query above.\"\n}\n[/block]\n##Response body\nThe response shows the matching cases.\n[block:code]\n{\n \"codes\": [\n {\n \"code\": \"{\\n \\\"count\\\": 100,\\n \\\"_embedded\\\": {\\n \\\"cases\\\": [\\n {\\n \\\"_links\\\": {\\n \\\"self\\\": {\\n \\\"href\\\": \\\"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/029CE789-123A-45B6-8596-CD94300E7EF5\\\"\\n }\\n },\\n \\\"id\\\": \\\"029CE789-123A-45B6-8596-CD94300E7EF5\\\",\\n \\\"label\\\": \\\"029CE789-123A-45B6-8596-CD94300E7EF5\\\"\\n },\\n {\\n \\\"_links\\\": {\\n \\\"self\\\": {\\n \\\"href\\\": \\\"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/02B5012E-45B6-4423-7890-0B2F5E50926E\\\"\\n }\\n },\\n \\\"id\\\": \\\"02B5012E-45B6-4423-7890-0B2F5E50926E\\\",\\n \\\"label\\\": \\\"02B5012E-45B6-4423-7890-0B2F5E50926E\\\"\\n },\\n \\n <snip>\\n \\n ]\\n }\\n}\",\n \"language\": \"json\"\n }\n ]\n}\n[/block]\n\n[block:callout]\n{\n \"type\": \"success\",\n \"body\": \"For brevity, we have omitted part some of the returned cases.\"\n}\n[/block]\nFor each case matching the query, the following information is listed:\n * Its `href`: this is a path that can be used to obtain full information about the sample. To see all information, issue a `GET` request to this path. See [Example query 1: Find samples connected to a case](doc:example-query-1-find-samples-connected-to-a-case) for details.\n * Its TCGA `id`\n * Its TCGA `label`","updates":[],"order":47,"isReference":false,"hidden":false,"sync_unique":"","link_url":"","link_external":false,"_id":"5845ac222c0fc01900163600","__v":0,"version":{"version":"1.0","version_clean":"1.0.0","codename":"","is_stable":true,"is_beta":true,"is_hidden":false,"is_deprecated":false,"categories":["55faf11ca62ba1170021a9ab","55faf8f4d0e22017005b8272","55faf91aa62ba1170021a9b5","55faf929a8a7770d00c2c0bd","55faf932a8a7770d00c2c0bf","55faf94b17b9d00d00969f47","55faf958d0e22017005b8274","55faf95fa8a7770d00c2c0c0","55faf96917b9d00d00969f48","55faf970a8a7770d00c2c0c1","55faf98c825d5f19001fa3a6","55faf99aa62ba1170021a9b8","55faf99fa62ba1170021a9b9","55faf9aa17b9d00d00969f49","55faf9b6a8a7770d00c2c0c3","55faf9bda62ba1170021a9ba","5604570090ee490d00440551","5637e8b2fbe1c50d008cb078","5649bb624fa1460d00780add","5671974d1b6b730d008b4823","5671979d60c8e70d006c9760","568e8eef70ca1f0d0035808e","56d0a2081ecc471500f1795e","56d4a0adde40c70b00823ea3","56d96b03dd90610b00270849","56fbb83d8f21c817002af880","573c811bee2b3b2200422be1","576bc92afb62dd20001cda85","5771811e27a5c20e00030dcd","5785191af3a10c0e009b75b0","57bdf84d5d48411900cd8dc0","57ff5c5dc135231700aed806","5804caf792398f0f00e77521","58458b4fba4f1c0f009692bb","586d3c287c6b5b2300c05055","58ef66d88646742f009a0216","58f5d52d7891630f00fe4e77","59a555bccdbd85001bfb1442","5a2a81f688574d001e9934f5","5b080c8d7833b20003ddbb6f","5c222bed4bc358002f21459a","5c22412594a2a5005cc9e919","5c41ae1c33592700190a291e","5c8a525e2ba7b2003f9b153c","5cbf14d58c79c700ef2b502e","5db6f03a6e187c006f667fa4","5f894c7d3b0894006477ca01","6176d5bf8f59c6001038c2f7"],"_id":"55faf11ba62ba1170021a9aa","releaseDate":"2015-09-17T16:58:03.490Z","createdAt":"2015-09-17T16:58:03.490Z","project":"55faf11ba62ba1170021a9a7","__v":48},"githubsync":"","user":"5613e4f8fdd08f2b00437620","createdAt":"2016-12-05T18:04:18.897Z","parentDoc":null,"project":"55faf11ba62ba1170021a9a7","category":{"sync":{"isSync":false,"url":""},"pages":[],"title":"DATASETS HUB","slug":"datasets-hub","order":7,"from_sync":false,"reference":false,"_id":"58458b4fba4f1c0f009692bb","createdAt":"2016-12-05T15:44:15.650Z","project":"55faf11ba62ba1170021a9a7","version":"55faf11ba62ba1170021a9aa","__v":0}}
postExample query 3: Find cases with given age at diagnosis
<a href="query-datasets" style="color:#132c56">QUERY DATASETS</a> > <a href="about-the-datasets-api" style="color:#132c56">About the Datasets API</a> > <a href="query-via-the-datasets-api" style="color:#132c56">Query via the Datasets API</a> > Example query 3: find cases with...