Using AQL i would like to lookup a word in a string

Question

hello,

We have a complex scenario where we read keywords to the ticket summary and determine the component and auto assign the ticket. Current this is all a manual multi-step process of IF-Else statements. this is getting too big and hard to manage. Hence the idea is to use assets or a lookup table to determine the component based on keywords.

I was able toc create assets etc. but problem is in finding the keyword within the summary using AQL . Please let me know if anyone has a similar issue and have a solution for it.

Ashok Shirppi · Answer

Thanks for your response. this will not work in my case as most of the tickets we receive is through the email channel and we would like to parse out the key words from the summary to determine the Components.

Marc -Devoteam- · Answer

Hi @Ashok Shirppi

This could be possible but, this would require a summary attribute on the objectType component in assets

For example, if you wanted to only show a list of components owned by the current summary, you could configure the Filter Issue Scope (AQL) field by typing objectType = “Component” AND "Owner" LIKE ${summary.label}.

Jira system filed are case-sensitive and must be typed exactly as below.

In your case I don't think this will work, as you don't use the full summary and the case sensitivity issue

I think you would need to create a more elaborate assets scheme and create custom fields, populated with assets data and let customers select there needs and assign issues based on this.

I hope this gives you direction, but I don't know if this is where you would like to go.