Skip to content

Instantly share code, notes, and snippets.

SELECT *
FROM (
SELECT
team_name, pipeline_name, job_name, build_name, version, count(version) OVER (PARTITION by team_name, pipeline_name, job_name, version) AS counter
FROM (
SELECT
b.name build_name,
t.name team_name,
SELECT team_name, pipeline_name, job_name
FROM (
SELECT
team_name, pipeline_name, job_name, count(version) OVER (PARTITION by team_name, pipeline_name, job_name, version) AS counter
FROM (
SELECT
t.name AS team_name,
p.name AS pipeline_name,
@robwhitby
robwhitby / create-xray-role.xqy
Last active August 29, 2015 14:11
Create xray role
xquery version "1.0-ml";
declare default function namespace "local";
import module namespace sec = "http://marklogic.com/xdmp/security" at "/MarkLogic/security.xqy";
declare variable $xray-role := "xray-role";
declare function invoke($fn as xdmp:function) {
xdmp:invoke-function(function() {
try { $fn() }
var http = require("http"),
request = require("request"),
lynx = require("lynx"),
metrics = new lynx("localhost", 8125)
var port = process.env.PORT || 8080,
rendererBaseUrl = process.env.RENDERER_BASE_URL || "http://fulltext-renderer.dev.cf.springer-sbm.com/",
esiBaseUrl = process.env.ESI_BASE_URL || "http://fulltext.springer.akamai.com/",
esiMaxBytes = process.env.ESI_MAX_BYTES || 1000000
@robwhitby
robwhitby / cts-element-values-non-concurrent.xqy
Created January 3, 2012 17:42
cts:element-values non-concurrent example
xquery version "1.0-ml";
declare variable $query as cts:query := cts:and-query(());
declare variable $facets as element(facets) :=
<facets>
<facet name="Language" ns="sample-namespace">
<option>frequency-order</option>
<option>collation=http://marklogic.com/collation/codepoint</option>
</facet>
@robwhitby
robwhitby / cts-element-values-concurrent.xqy
Created January 3, 2012 17:36
cts:element-values concurrent example
xquery version "1.0-ml";
declare variable $query as cts:query := cts:and-query(());
declare variable $facets as element(facets) :=
<facets>
<facet name="Language" ns="sample-namespace">
<option>frequency-order</option>
<option>collation=http://marklogic.com/collation/codepoint</option>
</facet>