Remove an element from struct type array using search query in vespa

Question

I need to remove the element of an array of struct type.My json is given below.So what would be my query if I want search results where userID is "abcd" and I should get the elements of an array "data" where dd is equal to 1.I mean I should not get that element in which dd is equal to 0 in an array.

{
  "fields": {
    "userId":"abcd",
        "data": [
             {
                "aa": "Text 1",
                "bb": 15,
                "cc": 100000000000,
                "dd": 1
            },
            {
                "aa": "Text 2",
                "bb": 15,
                "cc": 100000000000,
                "dd": 1
            },
            {
                "aa": "Text 3",
                "bb": 15,
                "cc": 100000000000,
                "dd": 1
            },
            {
                "aa": "Text 4",
                "bb": 15,
                "cc": 100000000000,
                "dd": 0
            }
        ]
    }
}

Please help!!

Could you resolve this question? Thanks – Jo Kristian Bergum Dec 11 '18 at 10:37 — Jo Kristian Bergum, Dec 11 '18 at 10:37
I couldn't solve this problem.I changed my use case – Mohammad Sunny Dec 11 '18 at 13:57 — Mohammad Sunny, Dec 11 '18 at 13:57

score 1 · Answer 1 · answered Nov 29 '18 at 11:52

1

You cannot modify the document itself by a search.

To search a array of structyou should use sameElement. Plenty of examples using sameElement here https://docs.vespa.ai/documentation/query-language.html

answered Nov 29 '18 at 11:52

Jo Kristian Bergum

2,984
5
8

Remove an element from struct type array using search query in vespa

1 Answers1