{"id":111538,"date":"2020-10-24T16:34:35","date_gmt":"2020-10-24T16:34:35","guid":{"rendered":"http:\/\/www.timestored.com\/b\/?p=111538"},"modified":"2021-04-08T07:48:12","modified_gmt":"2021-04-08T07:48:12","slug":"jq-kdb-functions-keywords-support","status":"publish","type":"post","link":"https:\/\/www.timestored.com\/b\/jq-kdb-functions-keywords-support\/","title":{"rendered":"jq supports functions and new keywords."},"content":{"rendered":"<p><a href=\"\/jq\">Jq<\/a> has now added support for:<\/p>\n<ol>\n<li><strong>Functions<\/strong> &#8211; {x+1}. Unnamed parameters beyond x don&#8217;t yet work so please name all your parameters.<\/li>\n<li><strong>Keyed table operations<\/strong>: xkey, 1!, 2!, keys, value.<\/li>\n<li><strong>New keywords<\/strong> supported: in, distinct, inter, except, rank, sv, vs, sum, prd, xlog.<\/li>\n<li><strong>Improved compatibility<\/strong> and support of: null, avg, var, iasc, upper, lower, fills, fill, ^, sublist, prds, sums.<\/li>\n<\/ol>\n<p>The added keywords in most cases will only support the most common types and arguments.<br \/>\nMixed lists in particular are not handled well by most keywords but we will continue to improve.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-111539\" src=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2020\/10\/jq-2020-10-24.png\" alt=\"JQ functions\" width=\"786\" height=\"686\" srcset=\"https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2020\/10\/jq-2020-10-24.png 786w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2020\/10\/jq-2020-10-24-300x262.png 300w, https:\/\/www.timestored.com\/b\/wp-content\/uploads\/2020\/10\/jq-2020-10-24-768x670.png 768w\" sizes=\"(max-width: 786px) 100vw, 786px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jq has now added support for: Functions &#8211; {x+1}. Unnamed parameters beyond x don&#8217;t yet work so please name all your parameters. Keyed table operations: xkey, 1!, 2!, keys, value. New keywords supported: in, distinct, inter, except, rank, sv, vs, sum, prd, xlog. Improved compatibility and support of: null, avg, var, iasc, upper, lower, fills, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111538"}],"collection":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/comments?post=111538"}],"version-history":[{"count":2,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111538\/revisions"}],"predecessor-version":[{"id":111541,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/posts\/111538\/revisions\/111541"}],"wp:attachment":[{"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/media?parent=111538"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/categories?post=111538"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.timestored.com\/b\/wp-json\/wp\/v2\/tags?post=111538"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}