717 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
4
votes
1
answer
159
views
How to retrieve metrics from Couchbase query?
Looking for an async solution? Look here. Otherwise read on.
I am trying to delete documents that have expired via a query. I am not using Couchbase's feature of expiring documents as I need better ...
1
vote
2
answers
123
views
Couchbase query where flag must not be true
I have documents in Couchbase that contain data like this:
{
"name": "doc1",
"is_deleted": true
}
{
"name": "doc2",
"is_deleted"...
2
votes
2
answers
70
views
Is it possible to use multiple UNNEST in one query?
I'm trying to write a Couchbase query to get result from my JSON given below. I am using UNNEST operation to but somehow not getting expected result.
Can we use multiple UNNEST in one query? If so, ...
2
votes
1
answer
71
views
Couchbase Order By date in decending order not working
I am trying to select record order by date in descending order and its not working for me please help. Same query without DESC working fine for Ascending order
select data.id, data.modified_date from `...
2
votes
2
answers
68
views
N1QL query issue in Couchbase lite SQL++ for Mobile
I have a couchbase collection called "books" in "cloud" scope. This is the document structure -
{
"doc_type": "book_item",
"plumap": {
"000": {
...
2
votes
1
answer
83
views
How to prevent sql injection when using spring data couchbase with Query annotation?
I am having Controller, Service, Repository kind of Spring web project having enterprise couchbase server as DB, I am using spring-data-couchbase for querying data of couchbase, and I am using @Query ...
2
votes
1
answer
297
views
How to form a SELECT query in Couchbase for objects based on a field in an array
I have a couchbase with documents (in a bucket called myBucket) each of whose structure is like so:
{
"id": 1234
"name": "Smith",
"properties": [
{
...
1
vote
1
answer
71
views
How to fix couchbase update SQL with CTE causing an error?
I have a CTE based SUBQUERY block named sq_filter which returns this kind of JSON:
{
"aId": "2769ba8f",
"bId": "5837c902",
"tn": "oi&...
1
vote
1
answer
104
views
Are full or outer joins directly possible in Couchbase?
Are full or outer joins directly possible in Couchbase, without doing any extra operations?
0
votes
1
answer
48
views
Couchbase SQL++ Left Join Query with CASE acts as inner join
I have the following query :
SELECT i.id, i.docId, i.proId, i.invRecipientType
FROM pulse i
WHERE i.type = 'pulseInvoice'
AND i.invRecipientType IN ['cpam', 'b2b', 'b2c']
AND i.orgId = '...
1
vote
2
answers
98
views
Spring in Kotlin: Getting data from couchbase server using special query brings back an empty object
I have a Spring micro-service that has been working for months now.
The owner wanted to add 2 additional function, one of them required a custom query:
SELECT Meta().id AS __id, *
FROM `bucket`
WHERE ...
1
vote
3
answers
88
views
How do you modify a Couchbase record that contains a fairly complex object and sub-object?
I have a couchbase database full of records that look like this:
{
"_class": "com.discussoftware.server.shared.model.bo.licenseBo",
"customerId": "A1A2",
&...
1
vote
2
answers
116
views
Couchbase Spring Data returns objects by ID without an index, but the Couchbase Query UI will not
I have a super simple Couchbase-Spring-Data project hooked up to a Couchbase 6.6 instance, based on the walkthrough from bealdung
The project works as expected and I'm able to create and read ...
2
votes
1
answer
117
views
i cannot use let or for clauses in my query, it always says its a reserved keyword
why i cannot use let or for clauses in my query, it always says its a reserved keyword, following is my query:
for "FOR" clause:
`SELECT properties.hotelId, MIN(ARRAY_AVG(rate.base_rate) FOR ...
0
votes
1
answer
61
views
How to update values in array using n1q1
My couchbase bucket document looks like below
{
"Records":
[
{
"record_id": "21",
"amount": 10,
"count": 2
},
{
&...