topic Re: Using Asterisk literal in set analysis count function? in App Development

Using Asterisk literal in set analysis count function?

mbeccaria — Tue, 14 Sep 2021 19:27:22 GMT

I'm trying to get a COUNT of [Services.Service Name] where the [Service Name] starts with an asterisk.

This works for the letter "A":

Count({<[Services.Service Name] = {"A*"}>}[Services.Service Name])

But I can't figure out how to use an asterisk as a string literal in a set aggregate function. I tried multiple things. Any ideas?

Re: Using Asterisk literal in set analysis count function?

stevejoyce — Tue, 14 Sep 2021 19:48:34 GMT

What if you try

Count({<[Services.Service Name] = {"=left([Services.Service Name] ,1)='*'"}>}[Services.Service Name])

Re: Using Asterisk literal in set analysis count function?

Kushal_Chawda — Tue, 14 Sep 2021 21:07:28 GMT

@mbeccaria not sure how exactly do you want to search asterisk but you could try below if you just want to search asterisk

Count({<[Services.Service Name] = {"?*?"}>}[Services.Service Name])

Re: Using Asterisk literal in set analysis count function?

mbeccaria — Wed, 15 Sep 2021 12:45:37 GMT

That did it! I didn't think to use the left operator. I was working on using replace to replace the * with an alternate character that would work in a query. This is much more elegant. Thanks!

Re: Using Asterisk literal in set analysis count function?

stevejoyce — Wed, 15 Sep 2021 12:50:23 GMT

Yea i think that's the other option. But i agree, if you know it's your first character, this is much easier to read. i would do replace if it could be anywhere in your string.