How to get filtered result by using Hash Index in ArangoDB?

Question

My data:

{
  "rootElement": {
    "names": {
      "name": [
        "Haseb",
        "Anil",
        "Ajinkya",
        {
          "city": "mumbai",
          "state": "maharashtra",
          "job": {
            "second": "bosch",
            "first": "infosys"
          }
        }
      ]
    },
    "places": {
      "place": {
        "origin": "INDIA",
        "current": "GERMANY"
      }
    }
  }
}

I created a hash index on job field with the API:
http://localhost:8529/_db/_api/index?collection=Metadata

{
  "type": "hash",
  "fields": [
    "rootElement.names.name[*].jobs"
  ]
}

And I make the search query with the API:
http://localhost:8529/_db/_api/simple/by-example

{
  "collection": "Metadata",
  "example": {
    "rootElement.names.name[*].jobs ": "bosch"
  }
}

Ideally, only the document containing job : bosch should be returned as a result. But for me it gives all the documents in the array name[*]. Where I am doing mistake?

Did the answer fullfill your needs? If not, whats missing? If, can you mark it accepted? — dothebart
– dothebart, Commented Apr 25, 2016 at 15:11

dothebart · Accepted Answer · 2016-02-16 11:53:01Z

1

Array asterisk operators are not supported by simple queries.

You need to use AQL for this:

FOR elem IN Metadata FILTER elem.rootElement.names.name[*].jobs = "bosch" RETURN elem

You can also execute AQL via the REST interface - However you should rather try to let a driver do the heavy lifting for you.

answered Feb 16, 2016 at 11:53

dothebart

6,07718 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Haseb Ansari Over a year ago

does in any way Arango handle nested array for fulltext indexing & searching ?

dothebart Over a year ago

The 'translation' exampl demonstates the capabilities of the fulltext index. Deeper nesting is currently unsupported.

Collectives™ on Stack Overflow

How to get filtered result by using Hash Index in ArangoDB?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related