{"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: 7942f56901534434a054dafc3813bc96\",\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/029CE650-5E5A-4100-8596-CD94300E7EF5\\\"\\n          }\\n        },\\n        \\\"id\\\": \\\"029CE650-5E5A-4100-8596-CD94300E7EF5\\\",\\n        \\\"label\\\": \\\"029CE650-5E5A-4100-8596-CD94300E7EF5\\\"\\n      },\\n      {\\n        \\\"_links\\\": {\\n          \\\"self\\\": {\\n            \\\"href\\\": \\\"https://cgc-datasets-api.sbgenomics.com/datasets/tcga/v0/cases/02B5012E-F7AC-4423-8978-0B2F5E50926E\\\"\\n          }\\n        },\\n        \\\"id\\\": \\\"02B5012E-F7AC-4423-8978-0B2F5E50926E\\\",\\n        \\\"label\\\": \\\"02B5012E-F7AC-4423-8978-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"],"_id":"55faf11ba62ba1170021a9aa","releaseDate":"2015-09-17T16:58:03.490Z","createdAt":"2015-09-17T16:58:03.490Z","project":"55faf11ba62ba1170021a9a7","__v":47},"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":6,"from_sync":false,"reference":false,"_id":"58458b4fba4f1c0f009692bb","createdAt":"2016-12-05T15:44:15.650Z","project":"55faf11ba62ba1170021a9a7","version":"55faf11ba62ba1170021a9aa","__v":0}}