duannengling4705 2018-08-15 11:06
浏览 68
已采纳

Elasticsearch搜索结果过滤

I am new to Elasticsearch and I am using REST API for PHP to play around with data returned. I am using following code to retrieve data.

$params = [
        'index' => 'my_search',
        'type' => 'mytype',
        'from' => 0,
        'size' => 10,
        'body' => [
            'query' => [
                'bool' => [
                    'must' => [
                        [ 'match' => [ 'validated' => true ] ],
                        [ 'match' => [ 'image' => true ] ]
                    ]
                ]
            ],
            'sort' => [
                'created_at' => [ 'order' => 'asc']
            ]
        ]
    ];

Above code returns data perfectly matching "validated=>true" and "image=>true".

Further I want to add open text search like we use /_search/?q=Apple macbook. I have tried to use match, multi_match, query_string options, but couldn't get success.

So, I want to retrieve results from ES that have "validated=>true", "image=>true" and matches with text "Apple macbook".

Thanks in advance.

  • 写回答

2条回答 默认 最新

  • douzhanbai9526 2018-08-15 11:33
    关注

    You can try with query_string or simple_query_string

    $params = [
        'index' => 'my_search',
        'type' => 'mytype',
        'from' => 0,
        'size' => 10,
        'body' => [
            'query' => [
                'bool' => [
                    'must' => [
                        [ 'match' => [ 'validated' => true ] ],
                        [ 'match' => [ 'image' => true ] ],
                        [ 'query_string' => [ 'query' => 'Apple macbook' ] ]
                    ]
                ]
            ],
            'sort' => [
                'created_at' => [ 'order' => 'asc']
            ]
        ]
        ];
    
    
    
    $params = [
        'index' => 'my_search',
        'type' => 'mytype',
        'from' => 0,
        'size' => 10,
        'body' => [
            'query' => [
                'bool' => [
                    'must' => [
                        [ 'match' => [ 'validated' => true ] ],
                        [ 'match' => [ 'image' => true ] ],
                        [ 'simple_query_string' => [ 'query' => 'Apple macbook' ] ]
                    ]
                ]
            ],
            'sort' => [
                'created_at' => [ 'order' => 'asc']
            ]
        ]
        ];
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 请问一下这个运行结果是怎么来的
  • ¥15 这个复选框什么作用?
  • ¥15 单通道放大电路的工作原理
  • ¥30 YOLO检测微调结果p为1
  • ¥20 求快手直播间榜单匿名采集ID用户名简单能学会的
  • ¥15 DS18B20内部ADC模数转换器
  • ¥15 做个有关计算的小程序
  • ¥15 MPI读取tif文件无法正常给各进程分配路径
  • ¥15 如何用MATLAB实现以下三个公式(有相互嵌套)
  • ¥30 关于#算法#的问题:运用EViews第九版本进行一系列计量经济学的时间数列数据回归分析预测问题 求各位帮我解答一下