有懂 elasticsearch 的吗，这样的数据结构如何索引查询

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 1652 days ago, the information mentioned may be changed or developed.

{
    "sheets": {
        "Sheet1": {
            "name": "Sheet1",
            "data": {
                "dataTable": {
                    "0": {
                        "0": {
                            "value": 0
                        }
                    },
                    "1": {
                        "1": {
                            "value": 0,                           
                            "formula": "A1+B1"
                        }
                    }
                }
            },
            "index": 0
        },
        "Sheet2": {
            "name": "Sheet2",
            "data": {
                "dataTable": {
                    "0": {
                        "0": {
                            "value": 0,
                            "formula": "C1+D1"
                        }
                    }
                }
            },
            "index": 1
        }
    }
}

数据格式如上，要查询 formula 包含"A1"的应该怎么操作。

3 replies • 2021-10-22 15:52:27 +08:00