# Query Datalist Operator

**URL:** <https://community.yeeflow.com/t/query-datalist-operator/229>\
**Category:** Development and integrations\
**Created:** [December 28, 2023, 6:32am UTC](https://community.yeeflow.com/t/query-datalist-operator/229 "2023-12-28T06:32:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![andy\_wong](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.yeeflow.com/andy_wong/32/363_2.png) [@andy\_wong](https://community.yeeflow.com/u/andy_wong)\
**Post date:** [December 28, 2023, 6:32am UTC](https://community.yeeflow.com/t/query-datalist-operator/229/1 "2023-12-28T06:32:59Z")

</div>

Hi All,

I have a user requirement that getting rows from query datalist API that returning all rows with Tracking No. contains some keywords such as “034” in “20231218-000341”

I use the API and the operator type “In” (value = 9)

{  
“Filters”: [  
{  
“Field”: “Text7”,  
“Value”: “0341”,  
“Type”:  
},  
],  
“PageIndex”:1,  
“PageSize”:1000  
}

I expect the API returns some rows but it returns zero row  
{  
“Data”: ,  
“Status”: 0,  
“Message”: null,  
“TotalCount”: 0  
}

May I know there is any operator like SQL “%xxx%”?

Thanks a lot

Best regards,  
Andy

---

<div class="post-metadata">

**Author:** ![frank](https://avatars.discourse-cdn.com/v4/letter/f/3d9bf3/32.png) [@frank](https://community.yeeflow.com/u/frank)\
**Post date:** [December 29, 2023, 5:36am UTC](https://community.yeeflow.com/t/query-datalist-operator/229/2 "2023-12-29T05:36:10Z")

</div>

Hi Andy, sorry that the wildcard search is not supported in Open API.