Elastic search in Handsontable

Tags: #<Tag:0x00007fc464824a80>

Does handsontable works with Elastic search?

Hey @bashialee

Goog question. I haven’t test that before but I can help you to check this out.

What does it share (JSON, raw data…)

Have you already tried to connect them?

Hey, this is the sample data
        {
        "total": {
            "value": 720,
            "relation": "eq"
        },
        "max_score": 1.0,
        "hits": [
            {
                "_index": "membercrm",
                "_type": "_doc",
                "_id": "131235",
                "_score": 1.0,
                "_source": {
                    "MemberNo": "131235",
                    "addresses": [
                        "Testing Address"
                    ],
                    "people": [
                        "Darri Moore",
                        "Sanrina Moore"
                    ],
                    "phones": [
                        "124323234"
                    ],
                    "IndexDate": "2019-04-25",
                    "EQNNumber": [
                        "12345667"
                    ],
                    "HouseHoldName": "Darri & Sanrina Moore"
                },
                "highlight": {
                    "MemberNo": [
                        "<em>123434</em>"
                    ],
                    "EQNNumber": [
                        "<em>12345</em>"
                    ]
                }
            }
        ]
    }

OK, and what is the construction of you Handsontable? As I understand we should check if the Handsontable (in any given cell) has any of the _source values?

I’m asking as you may try to use this demo https://handsontable.com/docs/7.2.2/demo-searching.html and https://handsontable.com/docs/7.2.2/Options.html#trimRows to remove unnecessary rows.