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