Query Datalist Operator

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”,

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,

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