Loading TOC...


   select as String,
   [qualifier as String],
   [options as String]
) as ModifyPlan


This function dynamically constructs a row set based on a SPARQL SELECT query from triples.

select A SPARQL SELECT query expressed as a string.
qualifier Specifies a name for qualifying the column names. An "@" in front of the name specifies a parameter placeholder. A parameter placeholder in the SPARQL string must be bound to a parameter value in the result() call.
options Options consisting of key-value pairs that set options. At present, the options consist of dedup and base. Option dedup can take an on|off value to enable or disable deduplication. Deduplication is off by default. Option base takes a string as the initial base IRI for the query.

Usage Notes

The fromSPARQL function is one of the Data Access Functions.


// List all of the people born in Brooklyn.

const op = require('/MarkLogic/optic');

  op.fromSPARQL('PREFIX db: <http://dbpedia.org/resource/> \
                 PREFIX foaf: <http://xmlns.com/foaf/0.1/> \
                 PREFIX onto: <http://dbpedia.org/ontology/> \
                 SELECT ?person ?name WHERE { ?person onto:birthPlace db:Brooklyn; foaf:name @name .}')
    .result(null, {name:'Mae West'});



    // List the firstname of the people with id <http://marklogicsparql.com/id#5555>

    const op = require('/MarkLogic/optic');

    op.fromSPARQL('PREFIX ad: <http://marklogicsparql.com/addressbook#> '+
                    'SELECT ?firstName '+
                    'WHERE {<#5555> ad:firstName ?firstName .}'
                 , 'sparql', {dedup:'on',base:'http://marklogicsparql.com/id#'})


Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.