# Query: Field A contains Field B\`s value **URL:** \ **Category:** Kibana\ **Tags:** kql-kibana-query-language\ **Created:** [March 17, 2021, 12:37pm UTC](https://discuss.elastic.co/t/query-field-a-contains-field-b-s-value/267505 "2021-03-17T12:37:35Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![ksremo](https://avatars.discourse-cdn.com/v4/letter/k/5fc32e/32.png) [@ksremo](https://discuss.elastic.co/u/ksremo)\ **Post date:** [March 17, 2021, 12:37pm UTC](https://discuss.elastic.co/t/query-field-a-contains-field-b-s-value/267505/1 "2021-03-17T12:37:35Z")
Hello, i unsuccessfully try to query a document with his field a contains (not is equal) the value of field b. then negate this. can anybody help? here an example to clarify: fieldA:"test-MATCH", fieldB:"MATCH" -\> no match fieldA:"MATCH-test", fieldB:"MATCH" -\> no match fieldA:"test-test", fieldB:"MATCH" -\> match fieldA:"MATCH",fieldB"MATCH" -\> no match ---
**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\ **Post date:** [March 22, 2021, 9:57am UTC](https://discuss.elastic.co/t/query-field-a-contains-field-b-s-value/267505/2 "2021-03-22T09:57:52Z")
KQL won't allow you to do this. You can replicate this by using a scripted field: [Scripted fields | Kibana Guide [7.11] | Elastic](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) The script should do the contains check and return the result (true/false). Then you can filter by this scripted field in Discover or Visualize. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 19, 2021, 9:58am UTC](https://discuss.elastic.co/t/query-field-a-contains-field-b-s-value/267505/3 "2021-04-19T09:58:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.