Minus function in Optic Query

Question

I have requirement to do minus in one of the use case but in MarkLogic I am not able to use minus function. Is there any alternate way to do this?

select table1.value1 from table1 where table1.date = '2020-11-27'
minus
select table1.value1 from table1 where table1.date = '2020-11-26'

score 2 · Accepted Answer · edited Jan 05 '21 at 17:44

2

The "MINUS" operator is a SPARQL operator. Similar functionality is supported in MarkLogic's Optic API using the op:except() operator. You can also use the "MINUS" operator in SPARQL and op:from-sparql() in the Optic API, and the "EXCEPT" operator in SQL and op:from-sql() in the Optic API.

edited Jan 05 '21 at 17:44

Mads Hansen

63,927
12
112
147

answered Jan 05 '21 at 14:52

John Snelson

941
4
4

score -1 · Answer 2 · edited Jan 06 '21 at 14:16

-1

The minus/subtraction operator in XQuery is "-", like in most languages. The rest of your code looks a bit like SQL to me (though I last used SQL about 30 years ago) and it will all need changing.

I don't now what "Optic Query" is, I'm afraid.

edited Jan 06 '21 at 14:16

marc_s

732,580
175
1,330
1,459

answered Jan 05 '21 at 09:43

Michael Kay

156,231
11
92
164

There is an option to use sql in marklogic but many SQL functions are not supported in MarkLogic – ramz123 Jan 05 '21 at 12:49
MarkLogic has an XQuery function library for relational style querying called Optic API. – John Snelson Jan 05 '21 at 14:53
Perhaps it was a mistake to tag the question XQuery. – Michael Kay Jan 08 '21 at 09:37

Minus function in Optic Query

2 Answers2