I assume you mean from the UI? there is nothing special with "-". Are you sure that you did not end up with a different character than you think. Unicode helpfully has lots of hyphen characters.

I trust you spelt BusinessApplicationInstance correctly in the query.

If you look in tw_svc_model.log does it show the correct query?

Check your quoting characters

I copied from your post, and the 2 searches that look for equality 2 single quotes before and after the string.

The search using 'matches' shows 1 double quote before and after the string.The courier font facse shows that very clearly:

search BusinessApplicationInstance where name = ''Query Language - Special Characters''

search BusinessApplicationInstance where name matches "Query Language -"

search BusinessApplicationInstance where name = ''Query Language -''

I tried to do a similar search, just using the hyphen characters, but in SoftwareInstance, like this:

search SoftwareInstance where name matches '-'

yields results in 11.1, and 11.2 but

search SoftwareInstance where name matches ''-''

yields no results in 11.1

and Expression Not Supported in 11.2+

Your first query may work if you just used 1 single quote for the string

Your second query should work, unless there are other white space characters in the name that we cannot see.

Your third query should return nothing, even when fixing the quotes for the string.

You could also try some more regex specific pattern matching like

search BusinessApplicationInstance where name matches regex '^(?i)Query\s+Language\s+-'

HTH

Bob

You cannot be matching the actual value. If the first case works then that would imply you need to be looking at the beginning of the value.

As Andrew said, if the first case is not working, then there are some other 'white space' characters (more spaces, tabs, new-line, carriage-return, etc) in the actual BAI name.

Try searching for the word 'Query' in the BusinessApplicationInstance name, as this removes any attempt to also find 'white space' characters.

search BusinessApplicationInstance where name matches regex '(?i)query' show fmt('-->%s<--', name) as 'Formatted Name'

This debugging query just adds some 'pinchers' around the name attribute which helps to un-hide some leading or trailing white-space characters.

If this brings back expected one of your sought-after BAIs, the problem is more than likely in one of 2 places:  Either the 'copy and paste' of the BusinessApplicationInstance name included some 'white-space' characters that were not matched in the first search queries, or the code where the BusinessApplicationInstance 'name' attribute is generated is including some white-space characters that are not being matched in the first search queries.

Just curious, how were the BAIs created? With SAAM, CAM, or your own custom patterns?

There is no interpretation of a dash.

Have you tried exporting to a CSV file so you can exactly see the name.

Sounds like the  %app_name% variable has a \n or \r on the end of it which would be an artifact of how you are getting that value.  It may help to do a

log.debug("App Name: %bai_name%");

This could account for it if you know there are one or more (space, tab, new line, return, )

search BusinessApplicationInstance where name matches regex '(?i)y\s+- Special Characters' show fmt('-->%s<--', name) as 'Formatted Name'