Hi,
I'm using SuiteTalk REST Web Services. When I want to filter "task" records of which timed event field is not false using IS_NOT operator (mentioned in NetSuite doc), the service returned 400 Bad Request Error with message "Invalid search query".
The same issue occurs when I'm trying to filter with other boolean fields on "task" or other records. This error also appears when using END_WITH operator on string-based fields.
------------- POSTMAN request -------------
GET https://test.suitetalk.api.netsuite.com/services/rest/record/v1/task?offset=0&limit=499&q=timedEvent+IS_NOT+false
User-Agent: PostmanRuntime/7.31.0
Authorization: Bearer .....(token)
Accept: application/json
Accept-language: en-US
------------- Response -------------
{
"type":"https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1",
"title":"Bad Request",
"status":400,
"o:errorDetails":[{
"detail":"Invalid search query. Detailed unprocessed description follows. Search error occurred: Operator IS_NOT is not valid for given search filter.",
"o:errorQueryParam":"q",
"o:errorCode":"INVALID_PARAMETER"
}]
}
Please suggest any solutions. Thanks!
