Loading TOC...
XQuery cts:column-range-query

MarkLogic 10 Product Documentation
cts.columnRangeQuery

cts.columnRangeQuery(
   schema as String,
   view as String,
   column as String,
   value as (String | Number | Boolean | null | Array | Object)[],
   [operator as String?],
   [options as String[]],
   [weight as Number?]
) as cts.tripleRangeQuery

Summary

Returns a cts.query matching documents matching a TDE-view column equals to an value. Searches with the cts.columnRangeQuery constructor require the triple index; if the triple index is not configured, then an exception is thrown.

Parameters
schema The TDE schema name.
view The TDE view name.
column The TDE column name.
value One or more values used for querying.
operator Operator for the $value values. The default operator is "=".

Operators include:

"<"
Match range index values less than $value.
"<="
Match range index values less than or equal to $value.
">"
Match range index values greater than $value.
">="
Match range index values greater than or equal to $value.
"="
Match range index values equal to $value.
"!="
Match range index values not equal to $value.
options Options to this query. The default is ().

Options include:

"cached"
Cache the results of this query in the list cache.
"uncached"
Do not cache the results of this query in the list cache.
"score-function=function"
Use the selected scoring function. The score function may be:
linear
Use a linear function of the difference between the specified query value and the matching value in the index to calculate a score for this range query.
reciprocal
Use a reciprocal function of the difference between the specified query value and the matching value in the index to calculate a score for this range query.
zero
This range query does not contribute to the score. This is the default.
"slope-factor=number"
Apply the given number as a scaling factor to the slope of the scoring function. The default is 1.0.
weight A weight for this query. The default is 1.0.

Usage Notes

This function returns a cts:triple-range-query, and all functions which takes cts:triple-range-query as an input can be used (e.g. cts:triple-range-query-subject).

Example

'use strict'; 
const q=cts.columnRangeQuery("MySchema","MyView","value",xs.decimal(12), "<")  
cts.uris(null,null,q)

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