# Elastic How to retrieve such 'JT221\_20180101, A98068\_20180321' product information

**URL:** <https://discuss.elastic.co/t/elastic-how-to-retrieve-such-jt221-20180101-a98068-20180321-product-information/151817>\
**Category:** Elasticsearch\
**Created:** [October 10, 2018, 10:28am UTC](https://discuss.elastic.co/t/elastic-how-to-retrieve-such-jt221-20180101-a98068-20180321-product-information/151817 "2018-10-10T10:28:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zhen\_Zhang](https://avatars.discourse-cdn.com/v4/letter/z/2acd7d/32.png) [@Zhen\_Zhang](https://discuss.elastic.co/u/Zhen_Zhang)\
**Post date:** [October 10, 2018, 10:28am UTC](https://discuss.elastic.co/t/elastic-how-to-retrieve-such-jt221-20180101-a98068-20180321-product-information/151817/1 "2018-10-10T10:28:50Z")

</div>

This field stores multiple product information using the letter "," where "\_" is preceded by the product code," \_" followed by the purchase time, and how to retrieve the customer information that matches the results based on the product code and purchase time.

```
"_source": {
"cust_id": 5,
"sex": "Male",
"pro_code": "JT2929,A98068",
"pro_time": "JT221_20180101, A98068_20180321"
}
```

---

<div class="post-metadata">

**Author:** ![dakrone](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dakrone/32/23351_2.png) [@dakrone](https://discuss.elastic.co/u/dakrone)\
**Post date:** [October 11, 2018, 8:30am UTC](https://discuss.elastic.co/t/elastic-how-to-retrieve-such-jt221-20180101-a98068-20180321-product-information/151817/2 "2018-10-11T08:30:14Z")

</div>

I apologize, this is still a little unclear as to what you are trying to do, can you explain what sort of query text you want to use for this?

---

<div class="post-metadata">

**Author:** ![Zhen\_Zhang](https://avatars.discourse-cdn.com/v4/letter/z/2acd7d/32.png) [@Zhen\_Zhang](https://discuss.elastic.co/u/Zhen_Zhang)\
**Post date:** [October 12, 2018, 9:10am UTC](https://discuss.elastic.co/t/elastic-how-to-retrieve-such-jt221-20180101-a98068-20180321-product-information/151817/4 "2018-10-12T09:10:08Z")

</div>

It may be that I have not described enough. es store a product field. The value of this field is composed of "product code + product time". There will be multiple data. Use "," to distinguish. I fill in the on the page Product Code and Product Time, how should I search for data that meets both criteria

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 9, 2018, 9:10am UTC](https://discuss.elastic.co/t/elastic-how-to-retrieve-such-jt221-20180101-a98068-20180321-product-information/151817/5 "2018-11-09T09:10:09Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.