# Query with Filter not return doc **URL:** \ **Category:** Elasticsearch\ **Created:** [December 18, 2019, 11:13am UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306 "2019-12-18T11:13:17Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Hung\_Nguyen\_Manh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hung_nguyen_manh/32/55197_2.png) [@Hung\_Nguyen\_Manh](https://discuss.elastic.co/u/Hung_Nguyen_Manh)\ **Post date:** [December 18, 2019, 11:13am UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/1 "2019-12-18T11:13:17Z")
Hell everyone! I have a question. I do query filter in ES with field is "会員情報", it has value "D022FD29-DEA8-E311-947C-0626A2F00075", but not return doc. help me! pls. Thank a lot This is my query { "query": { "bool": { "filter": [ {"term": {"会員情報": "D022FD29-DEA8-E311-947C-0626A2F00075"}} ] } } } ---
**Author:** ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Post date:** [December 18, 2019, 11:33am UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/2 "2019-12-18T11:33:53Z")
Hi @Hung_Nguyen_Manh. what error or issue you are facing ? > I Think you are not getting any response from your query? `it may be you are missing index name ,fields or ES severe something` > please share some of sample data/code here if possible so people can reach to help you? Thanks HadoopHelp ---
**Author:** ![Hung\_Nguyen\_Manh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hung_nguyen_manh/32/55197_2.png) [@Hung\_Nguyen\_Manh](https://discuss.elastic.co/u/Hung_Nguyen_Manh)\ **Post date:** [December 18, 2019, 2:57pm UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/3 "2019-12-18T14:57:52Z")
@rameshkr1994 thank u! In doc contains "会員情報": "D022FD29-DEA8-E311-947C-0626A2F00075". query with fields have value number are fine, but fields have value string are fail. This is a doc in ES. { "会員情報": "D022FD29-DEA8-E311-947C-0626A2F00075", "支社": "東京支社", "求職ステータス": "フォロー落ち", "メインエージェント (会員)": "山田 花子W", "病院担当者01": "", "クリニック": "0", "緊急度": "", "成約目標月": "", "売上見込": 2500000.0 } ---
**Author:** ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Post date:** [December 18, 2019, 3:35pm UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/4 "2019-12-18T15:35:18Z")
Hi @Hung_Nguyen_Manh. I got your problem :- you are trying to access string fields using --term-- > but term only accept integer or date format. > your solution is here : > change code as below :- > `{ "query": { "bool": { "must": [{ "match": { "Membership Information": "D022FD29-DEA8-E311-947C-0626A2F00075" } }] } } }` > above query based on below data index as you shared! `{ "Membership Information": "D022FD29-DEA8-E311-947C-0626A2F00075", "Branch": "Tokyo Branch", "Job Status": "Follow Follow", "Main Agent (Member)": "Hanako Yamada W", "Hospital Staff 01": "", "Clinic": "0", "Urgent": "", "Target Month": "", "Expected sales": 2500000.0 }` > I hope this will resolve your problem. Thanks HadoopHelp ---
**Author:** ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Post date:** [December 18, 2019, 3:38pm UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/5 "2019-12-18T15:38:00Z")
こんにちは@Hung\_Nguyen\_Manh。 私はあなたの問題を得た：- --term--を使用して文字列フィールドにアクセスしようとしています > ただし、用語は整数または日付形式のみを受け入れます。 > あなたの解決策はこちら： > 以下のようにコードを変更します：- > `{ 「クエリ」：{ 「bool」：{ 「必須」：[{ 「一致」：{ 「会員情報」：「D022FD29-DEA8-E311-947C-0626A2F00075」 } }] } } } ` > 共有した以下のデータインデックスに基づいたクエリの上！ `{ 「会員情報」：「D022FD29-DEA8-E311-947C-0626A2F00075」、 「支店」：「東京支店」、 「ジョブステータス」：「フォローする」、 「メインエージェント（メンバー）」：「山田花子W」、 「病院スタッフ01」：「」、 「クリニック」：「0」、 「緊急」：「」、 「対象月」：「」、 「予想売上」：2500000.0 } ` > これで問題が解決することを願っています。 ありがとう HadoopHelp ---
**Author:** ![Hung\_Nguyen\_Manh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hung_nguyen_manh/32/55197_2.png) [@Hung\_Nguyen\_Manh](https://discuss.elastic.co/u/Hung_Nguyen_Manh)\ **Post date:** [December 18, 2019, 6:26pm UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/6 "2019-12-18T18:26:42Z")
@rameshkr1994 yeah, but your query always return all doc, It contains the docs without "D022FD29-DEA8-E311-947C-0626A2F00075" value in the field "会員情報". I just want docs contain "D022FD29-DEA8-E311-947C-0626A2F00075" value in the field "会員情報". Can u help me! Thank u!!! ---
**Author:** ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\ **Post date:** [December 19, 2019, 7:33am UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/7 "2019-12-19T07:33:28Z")
こんにちは@Hung\_Nguyen\_Manh。 私はこのコードを自分の側から確認しました... `{ 「クエリ」：{ 「bool」：{ 「必須」：[{ 「一致」：{ 「患者名」：「アブデルマウグード・エドリス」 } }] } } } ` > 以下を含むデータのみを取得します：- > `"会員情報 "：" D022FD29-DEA8-E311-947C-0626A2F00075 "` > これはすべてのフィールドに存在します。もう一度確認してください。 > 私はあなたと私のコードを以下のように共有しています：- > 一致するレコードのみに影響します：- `{ 「クエリ」：{ 「bool」：{ 「必須」：[{ 「一致」：{ 「患者名」：「アブドゥード・エドリス」 } }] } } } ` ありがとう HadoopHelp ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 16, 2020, 7:33am UTC](https://discuss.elastic.co/t/query-with-filter-not-return-doc/212306/8 "2020-01-16T07:33:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.