How to execute LIKE statement in AQL

Udara Manupriya

Hi All,
I need to execute the below query  AQL  for the object type = "Intune Devices"
It seems the LIKE condition is not working properly, It returns all the data that "objectType" = "Intune Devices"

My requirement is to execute an query like below for "objectType"="IntuneDevices"

"Device Name" NOT LIKE "avd" AND "Device Name" NOT LIKE "zaus" AND "Device Name" NOT LIKE " zbord" AND "Device Name" STARTSWITH "z"

This is the Request Body which I created 

{"qlQuery": "objectType = \"Intune Devices\" AND \"Device Name\" != \"avd%\" AND \"Device Name\" != \"zaus%\" AND \"Device Name\" != \"zbord%\" AND \"Device Name\" LIKE \"z\" "}

 

Fabio Racobaldo _Catworkx_

Hi @Udara Manupriya ,

did u try the following :

{"qlQuery": "objectType = \"Intune Devices\" AND \"Device Name\" not like \"avd\" AND \"Device Name\" not like \"zaus\" AND \"Device Name\" not like \"zbord\" AND \"Device Name\" LIKE \"z\" "}

Please let me know,

Fabio