Query Datalist Operator

Development and integrations
1

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

2

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