Automation AQL Regular Expressions

[Dustin Alcock]

Hi All.

Attempting to use a regular expression within AQL for automation but nothing's working. Is it even possible? To simplify testing, I'm trying the AQL directly in Assets by using the AQL filter on the listing. Trying to simplify from writing a ton of OR statements.

Goal: Find all Objects that the Application Name starts with 0-9

I've tried many, here are a couple though that didn't work:

• objectSchema = "Software Catalog" AND "Application Name" STARTSWITH "/^[cr][0-9a-z]*$/i"
• objectSchema = "Software Catalog" AND "Application Name" StartsWith "^[0-9]"

WORKS (non-expression):

• objectSchema = "Software Catalog" AND "Application Name" StartsWith "1"