{"_id":"56677dc45d76870d00159c8e","githubsync":"","__v":1,"project":"5667237eee53940d00516244","user":"56672364f672550d00085227","version":{"_id":"5667237fee53940d00516247","__v":4,"project":"5667237eee53940d00516244","createdAt":"2015-12-08T18:37:51.439Z","releaseDate":"2015-12-08T18:37:51.439Z","categories":["56672380ee53940d00516248","5667789f575ec10d00640b80","566779078c573e0d00023d96","56677e2bbe6e390d004eb463"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"category":{"_id":"56672380ee53940d00516248","project":"5667237eee53940d00516244","__v":5,"version":"5667237fee53940d00516247","pages":["56672381ee53940d0051624a","5667783dbe6e390d004eb45c","56677c2476f8430d00b259b9","56677c96c4caed0d0029b2c1","56677dc45d76870d00159c8e"],"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2015-12-08T18:37:52.060Z","from_sync":false,"order":0,"slug":"documentation","title":"Getting Started"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-12-09T01:03:00.294Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":2,"body":"[block:code]\n{\n  \"codes\": [\n    {\n      \"code\": \"new jinqJs( { globalSettings... } )\\n\\t\\t.from()                 <-- 1 to many arguments for union all\\n    \\t.on()            (Optional For inner joins)\\n    .union()\\n    .concat()\\n    .join()                 <-- 0 to many times\\n    \\t.on()\\n    .leftJoin()             <-- 0 to many times\\n    \\t.on()\\n        .fullJoin()\\t\\t    <-- 0 to many times\\n          .on()\\n    .not()\\t\\t\\t    <-- Optionally used by .in()\\n    .in()\\n    .update()\\n    \\t.at()\\n    .delete()\\n    \\t.at()\\n    .where() || .filter()\\n    .groupBy()\\n    .sum()\\n    .count()\\n    .avg()\\n    .min()\\n    .max()\\n    .distinct()\\n    .orderBy()\\n    .identity()\\n    .skip()\\n    .top()\\n    .bottom()\\n    .select()\\n\",\n      \"language\": \"javascript\",\n      \"name\": \"Functions\"\n    }\n  ]\n}\n[/block]\nAs shown, some of these functions can be called multiple times, some can call a predicate, some can take custom JSON objects to have more of granular effect and in special cases the from() function can be executed asynchronously or synchronously. The jinqJs object relies heavily on function chaining. Methods are called one after another in a top down fashion. Using jinqJs you can query collections and you can also perform in-place updates on collections similar to SQL.","excerpt":"","slug":"typical-order-of-functions","type":"basic","title":"Typical Order of Functions"}

Typical Order of Functions


[block:code] { "codes": [ { "code": "new jinqJs( { globalSettings... } )\n\t\t.from() <-- 1 to many arguments for union all\n \t.on() (Optional For inner joins)\n .union()\n .concat()\n .join() <-- 0 to many times\n \t.on()\n .leftJoin() <-- 0 to many times\n \t.on()\n .fullJoin()\t\t <-- 0 to many times\n .on()\n .not()\t\t\t <-- Optionally used by .in()\n .in()\n .update()\n \t.at()\n .delete()\n \t.at()\n .where() || .filter()\n .groupBy()\n .sum()\n .count()\n .avg()\n .min()\n .max()\n .distinct()\n .orderBy()\n .identity()\n .skip()\n .top()\n .bottom()\n .select()\n", "language": "javascript", "name": "Functions" } ] } [/block] As shown, some of these functions can be called multiple times, some can call a predicate, some can take custom JSON objects to have more of granular effect and in special cases the from() function can be executed asynchronously or synchronously. The jinqJs object relies heavily on function chaining. Methods are called one after another in a top down fashion. Using jinqJs you can query collections and you can also perform in-place updates on collections similar to SQL.