Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to execute LIKE statement in AQL

Udara Manupriya February 19, 2025

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\" "}


AQL.png

 

0 answers

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
ENTERPRISE
TAGS
AUG Leaders

Atlassian Community Events