# Can't create Visualize Library using span.db.statement field

**URL:** <https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471>\
**Category:** Kibana\
**Created:** [July 13, 2022, 3:45am UTC](https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471 "2022-07-13T03:45:46Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmad\_Arif](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmad_arif/32/108224_2.png) [@Ahmad\_Arif](https://discuss.elastic.co/u/Ahmad_Arif)\
**Post date:** [July 13, 2022, 3:45am UTC](https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471/1 "2022-07-13T03:45:46Z")

</div>

Why I can't add field **span.db.statement** in Visualize Library?  
I want to show what query with long duration process, btw I'm using APM nodejs Agent.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/d/7dbb9a9eac466811afebf078432ac9bdb7b0bfcf.png)

Thanks

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [July 13, 2022, 4:31pm UTC](https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471/2 "2022-07-13T16:31:55Z")

</div>

What kind of field is it? You cannot do terms aggregation for text fields, but for keyword fields. Please verify in your stack management panel if that's the case.

 ![Screenshot 2022-07-13 at 18.30.57](https://us1.discourse-cdn.com/elastic/original/3X/b/d/bd59f466cf23566ebe6470fe5f13450ac353de12.png)

---

<div class="post-metadata">

**Author:** ![Ahmad\_Arif](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmad_arif/32/108224_2.png) [@Ahmad\_Arif](https://discuss.elastic.co/u/Ahmad_Arif)\
**Post date:** [July 14, 2022, 2:30am UTC](https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471/3 "2022-07-14T02:30:27Z")

</div>

Hi Marta, thanks for the response.

I want to use some field in Span details just like image below, some span field I can use in Visualize terms, but for span.db.statement I can't use it.  
Is it mean I need to add span.db.statement field in Stack Management?

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/8/18ce08ce9f18c6fb783a8a82b34dd732ae7b3820.png)

---

<div class="post-metadata">

**Author:** ![Ahmad\_Arif](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ahmad_arif/32/108224_2.png) [@Ahmad\_Arif](https://discuss.elastic.co/u/Ahmad_Arif)\
**Post date:** [July 14, 2022, 2:45am UTC](https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471/4 "2022-07-14T02:45:59Z")

</div>

Got it, now I can add span.db.statement in Visualize library.  
Thank you so much 😀

---

<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:** [August 11, 2022, 2:46am UTC](https://discuss.elastic.co/t/cant-create-visualize-library-using-span-db-statement-field/309471/5 "2022-08-11T02:46:43Z")

</div>

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