# Query not working as expected with data api

**URL:** <https://forum.bubble.io/t/query-not-working-as-expected-with-data-api/173317>\
**Category:** Bugs\
**Created:** [October 11, 2021, 3:32am UTC](https://forum.bubble.io/t/query-not-working-as-expected-with-data-api/173317 "2021-10-11T03:32:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![himanshu1](https://avatars.discourse-cdn.com/v4/letter/h/7cd45c/32.png) [@himanshu1](https://forum.bubble.io/u/himanshu1)\
**Post date:** [October 11, 2021, 3:32am UTC](https://forum.bubble.io/t/query-not-working-as-expected-with-data-api/173317/1 "2021-10-11T03:32:26Z")

</div>

Hello,

I am trying to use the bubble data api to get data from bubble database of my app.  
For the same I am using a GET method.  
I need to perform filter on a text column of a thing and for the same I am using constraints as specified at [Data API - Bubble Docs](https://manual.bubble.io/core-resources/api/data-api#search-constraints)  
The problem is the constraint text contains searches the text as a word instead of performing a ‘like’ search.  
For example - say my column text has value ‘NSE-BANK-NIFTY’ and I am sending string search constraint as ‘AN’ it returns an empty list but if I send ‘NSE’ or ‘BANK’ or ‘NIFTY’ then it successfully returns the above data set.  
Kindly check.  
Regards  
Himanshu

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [October 25, 2021, 3:32am UTC](https://forum.bubble.io/t/query-not-working-as-expected-with-data-api/173317/2 "2021-10-25T03:32:38Z")

</div>

This topic was automatically closed after 14 days. New replies are no longer allowed.