{"_id":"563302048c9cda0d002526ff","project":"5614a5066ebd340d006a1bcc","version":{"_id":"5614a5076ebd340d006a1bcf","project":"5614a5066ebd340d006a1bcc","__v":5,"createdAt":"2015-10-07T04:52:23.031Z","releaseDate":"2015-10-07T04:52:23.031Z","categories":["5614a5076ebd340d006a1bd0","5614aa6253a1830d0098e962","5633048649e16d0d00122539","563305b08c9cda0d00252704","563305dc8c9cda0d00252705"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"user":"5614a4b8b283fb0d00a487d3","__v":7,"parentDoc":null,"category":{"_id":"5614a5076ebd340d006a1bd0","pages":["5614a5086ebd340d006a1bd2","5614a68fb283fb0d00a487d5","5614aab0163a7d2100ab5f02","563301637b563e0d00904900","56330184b904a10d0032f797","563302048c9cda0d002526ff","5633020e62c48a0d00334df3","5633022c10b6040d0087946b","5633024010b6040d0087946d","5633026fb904a10d0032f799","5633034538f8aa0d00d31002","5633035062c48a0d00334df5","5633036949e16d0d00122537","5633037b38f8aa0d00d31005","5633038d38f8aa0d00d31007","5633039bb904a10d0032f79b","56330b63b904a10d0032f7a6","56330e587b563e0d00904908","56370adb0704070d00f06c0c","563bc913dfa1282b000dd33e","56ad51b279011b0d00c32aba"],"version":"5614a5076ebd340d006a1bcf","__v":21,"project":"5614a5066ebd340d006a1bcc","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-10-07T04:52:23.567Z","from_sync":false,"order":1,"slug":"reference","title":"Reference"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-10-30T05:37:08.949Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":3,"body":"[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"What is a “query” and how is it different from a search?\"\n}\n[/block]\nFieldbook lets you do much more than search and filter—for instance, you can also sort and group. We call any combination of search, filter sort and group a *query*, so instead of a search bar there is a “query bar”. Each bubble in the query bar is a *term*.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/GyrerI2UTYyqM4WlFpjG_Screen%20Shot%202015-11-01%20at%209.31.20%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.31.20 PM.png\",\n        \"707\",\n        \"132\",\n        \"#fa703f\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Simple keyword search\"\n}\n[/block]\nType any keyword to search. This filters the sheet to rows containing that keyword (in any column).\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/C9hCNu38QIyJVZUlHHFv_Screen%20Shot%202015-11-01%20at%209.39.02%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.39.02 PM.png\",\n        \"224\",\n        \"66\",\n        \"#70dca2\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Column search\"\n}\n[/block]\nTo search just one column for a keyword, type the column name and the keyword together like `status:new`.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/98vmu2Z6TneF85A5rvbB_Screen%20Shot%202015-11-01%20at%209.40.40%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.40.40 PM.png\",\n        \"268\",\n        \"70\",\n        \"#6ae1a2\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nIf the keyword is actually multiple words, use quotes:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/6E3MUsOTwCgsdgyN6Q5d_Screen%20Shot%202015-11-01%20at%2010.17.52%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.17.52 PM.png\",\n        \"400\",\n        \"67\",\n        \"#6ada9f\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Filter on any formula\"\n}\n[/block]\nFor a more advanced search, use the `filter` keyword. Some examples:\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/vLShRp29R72p6Hvp3rRD_Screen%20Shot%202015-11-01%20at%209.55.28%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.55.28 PM.png\",\n        \"382\",\n        \"67\",\n        \"#fc713e\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/dsuygYTXRHubdC9Icr69_Screen%20Shot%202015-11-01%20at%209.56.06%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.56.06 PM.png\",\n        \"382\",\n        \"67\",\n        \"#fc713e\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/6lRuxqx5RdScZOFakvRs_Screen%20Shot%202015-11-01%20at%209.56.33%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.56.33 PM.png\",\n        \"382\",\n        \"67\",\n        \"#fa713f\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/v66tmgMQvGItFOf6Nwt2_Screen%20Shot%202015-11-01%20at%209.58.03%20PM.png\",\n        \"Screen Shot 2015-11-01 at 9.58.03 PM.png\",\n        \"382\",\n        \"67\",\n        \"#f9713f\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/ZkYf8vRMTNyP82ByNFsD_Screen%20Shot%202015-11-01%20at%2010.00.04%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.00.04 PM.png\",\n        \"457\",\n        \"67\",\n        \"#f67140\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Sort\"\n}\n[/block]\nUse the `sort` keyword to sort on any column or formula.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/Qqt8H4puT0uy6ThlSP6x_Screen%20Shot%202015-11-01%20at%2010.01.23%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.01.23 PM.png\",\n        \"400\",\n        \"67\",\n        \"#55cbdb\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/qaJUCczuQ6m4J6DxO1nE_Screen%20Shot%202015-11-01%20at%2010.05.46%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.05.46 PM.png\",\n        \"400\",\n        \"67\",\n        \"#57cad9\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nUse the `desc` keyword to sort in descending order.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/TqDQac85SnmP8iJpM53I_Screen%20Shot%202015-11-01%20at%2010.01.47%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.01.47 PM.png\",\n        \"400\",\n        \"67\",\n        \"#55cddd\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nIf you give a list of columnns, the first one will be the primary sort, and each subsequent one will be used to break ties.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/3cYl4VMzQiyajs04KMsU_Screen%20Shot%202015-11-01%20at%2010.05.24%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.05.24 PM.png\",\n        \"400\",\n        \"67\",\n        \"#58cede\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Group\"\n}\n[/block]\nThe `group` keyword creates a grouped view.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/2mHiCpExSUWtWDdpAs6p_Screen%20Shot%202015-11-01%20at%2010.19.40%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.19.40 PM.png\",\n        \"400\",\n        \"66\",\n        \"#fcc338\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nYou can drag rows between groups, and drag groups to reorder them. This is great for tracking any pipeline or workflow.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/LKcPCiqTQGWvnhLAJ97f_Screen%20Shot%202015-11-01%20at%2010.20.16%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.20.16 PM.png\",\n        \"820\",\n        \"534\",\n        \"#36a13c\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Saved views\"\n}\n[/block]\nYou can save any query as a saved view, to get back to it at any time.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/YFn0fuaiRTqnXUKlEkCC_Screen%20Shot%202015-11-01%20at%2010.11.39%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.11.39 PM.png\",\n        \"585\",\n        \"60\",\n        \"#2da334\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nThe link will show up on the left. You can bookmark the link as well.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/yHU2YXgOQjsIatz5y46Q_Screen%20Shot%202015-11-01%20at%2010.12.49%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.12.49 PM.png\",\n        \"239\",\n        \"95\",\n        \"#64b464\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]\nIf you're already on a saved view, and you change the query, your options will be to\n\n  * update the current view to use the new query, or\n  * save the query as a new view.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/XBNUzZHxTp6oWPjV4UoR_Screen%20Shot%202015-11-01%20at%2010.12.10%20PM.png\",\n        \"Screen Shot 2015-11-01 at 10.12.10 PM.png\",\n        \"775\",\n        \"64\",\n        \"#30a745\",\n        \"\"\n      ]\n    }\n  ]\n}\n[/block]","excerpt":"","slug":"queries","type":"basic","title":"Queries (filter, sort & group)"}

Queries (filter, sort & group)


[block:api-header] { "type": "basic", "title": "What is a “query” and how is it different from a search?" } [/block] Fieldbook lets you do much more than search and filter—for instance, you can also sort and group. We call any combination of search, filter sort and group a *query*, so instead of a search bar there is a “query bar”. Each bubble in the query bar is a *term*. [block:image] { "images": [ { "image": [ "https://files.readme.io/GyrerI2UTYyqM4WlFpjG_Screen%20Shot%202015-11-01%20at%209.31.20%20PM.png", "Screen Shot 2015-11-01 at 9.31.20 PM.png", "707", "132", "#fa703f", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Simple keyword search" } [/block] Type any keyword to search. This filters the sheet to rows containing that keyword (in any column). [block:image] { "images": [ { "image": [ "https://files.readme.io/C9hCNu38QIyJVZUlHHFv_Screen%20Shot%202015-11-01%20at%209.39.02%20PM.png", "Screen Shot 2015-11-01 at 9.39.02 PM.png", "224", "66", "#70dca2", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Column search" } [/block] To search just one column for a keyword, type the column name and the keyword together like `status:new`. [block:image] { "images": [ { "image": [ "https://files.readme.io/98vmu2Z6TneF85A5rvbB_Screen%20Shot%202015-11-01%20at%209.40.40%20PM.png", "Screen Shot 2015-11-01 at 9.40.40 PM.png", "268", "70", "#6ae1a2", "" ] } ] } [/block] If the keyword is actually multiple words, use quotes: [block:image] { "images": [ { "image": [ "https://files.readme.io/6E3MUsOTwCgsdgyN6Q5d_Screen%20Shot%202015-11-01%20at%2010.17.52%20PM.png", "Screen Shot 2015-11-01 at 10.17.52 PM.png", "400", "67", "#6ada9f", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Filter on any formula" } [/block] For a more advanced search, use the `filter` keyword. Some examples: [block:image] { "images": [ { "image": [ "https://files.readme.io/vLShRp29R72p6Hvp3rRD_Screen%20Shot%202015-11-01%20at%209.55.28%20PM.png", "Screen Shot 2015-11-01 at 9.55.28 PM.png", "382", "67", "#fc713e", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/dsuygYTXRHubdC9Icr69_Screen%20Shot%202015-11-01%20at%209.56.06%20PM.png", "Screen Shot 2015-11-01 at 9.56.06 PM.png", "382", "67", "#fc713e", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/6lRuxqx5RdScZOFakvRs_Screen%20Shot%202015-11-01%20at%209.56.33%20PM.png", "Screen Shot 2015-11-01 at 9.56.33 PM.png", "382", "67", "#fa713f", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/v66tmgMQvGItFOf6Nwt2_Screen%20Shot%202015-11-01%20at%209.58.03%20PM.png", "Screen Shot 2015-11-01 at 9.58.03 PM.png", "382", "67", "#f9713f", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/ZkYf8vRMTNyP82ByNFsD_Screen%20Shot%202015-11-01%20at%2010.00.04%20PM.png", "Screen Shot 2015-11-01 at 10.00.04 PM.png", "457", "67", "#f67140", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Sort" } [/block] Use the `sort` keyword to sort on any column or formula. [block:image] { "images": [ { "image": [ "https://files.readme.io/Qqt8H4puT0uy6ThlSP6x_Screen%20Shot%202015-11-01%20at%2010.01.23%20PM.png", "Screen Shot 2015-11-01 at 10.01.23 PM.png", "400", "67", "#55cbdb", "" ] } ] } [/block] [block:image] { "images": [ { "image": [ "https://files.readme.io/qaJUCczuQ6m4J6DxO1nE_Screen%20Shot%202015-11-01%20at%2010.05.46%20PM.png", "Screen Shot 2015-11-01 at 10.05.46 PM.png", "400", "67", "#57cad9", "" ] } ] } [/block] Use the `desc` keyword to sort in descending order. [block:image] { "images": [ { "image": [ "https://files.readme.io/TqDQac85SnmP8iJpM53I_Screen%20Shot%202015-11-01%20at%2010.01.47%20PM.png", "Screen Shot 2015-11-01 at 10.01.47 PM.png", "400", "67", "#55cddd", "" ] } ] } [/block] If you give a list of columnns, the first one will be the primary sort, and each subsequent one will be used to break ties. [block:image] { "images": [ { "image": [ "https://files.readme.io/3cYl4VMzQiyajs04KMsU_Screen%20Shot%202015-11-01%20at%2010.05.24%20PM.png", "Screen Shot 2015-11-01 at 10.05.24 PM.png", "400", "67", "#58cede", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Group" } [/block] The `group` keyword creates a grouped view. [block:image] { "images": [ { "image": [ "https://files.readme.io/2mHiCpExSUWtWDdpAs6p_Screen%20Shot%202015-11-01%20at%2010.19.40%20PM.png", "Screen Shot 2015-11-01 at 10.19.40 PM.png", "400", "66", "#fcc338", "" ] } ] } [/block] You can drag rows between groups, and drag groups to reorder them. This is great for tracking any pipeline or workflow. [block:image] { "images": [ { "image": [ "https://files.readme.io/LKcPCiqTQGWvnhLAJ97f_Screen%20Shot%202015-11-01%20at%2010.20.16%20PM.png", "Screen Shot 2015-11-01 at 10.20.16 PM.png", "820", "534", "#36a13c", "" ] } ] } [/block] [block:api-header] { "type": "basic", "title": "Saved views" } [/block] You can save any query as a saved view, to get back to it at any time. [block:image] { "images": [ { "image": [ "https://files.readme.io/YFn0fuaiRTqnXUKlEkCC_Screen%20Shot%202015-11-01%20at%2010.11.39%20PM.png", "Screen Shot 2015-11-01 at 10.11.39 PM.png", "585", "60", "#2da334", "" ] } ] } [/block] The link will show up on the left. You can bookmark the link as well. [block:image] { "images": [ { "image": [ "https://files.readme.io/yHU2YXgOQjsIatz5y46Q_Screen%20Shot%202015-11-01%20at%2010.12.49%20PM.png", "Screen Shot 2015-11-01 at 10.12.49 PM.png", "239", "95", "#64b464", "" ] } ] } [/block] If you're already on a saved view, and you change the query, your options will be to * update the current view to use the new query, or * save the query as a new view. [block:image] { "images": [ { "image": [ "https://files.readme.io/XBNUzZHxTp6oWPjV4UoR_Screen%20Shot%202015-11-01%20at%2010.12.10%20PM.png", "Screen Shot 2015-11-01 at 10.12.10 PM.png", "775", "64", "#30a745", "" ] } ] } [/block]