AQL Condition on Automation

[Bryan Tito]

Is there a way to enable this? We wanted to fetch the user data from asset (Employee Directory) into our Automation. It seems that we can't query and object and add asset field

[Dirk Ronsmans]

Hey @Bryan Tito ,

The Automation is not looking for a Asset but for an Asset field meaning it will take the issue that it was triggered on and then use the data from the specific Asset field.

What are you using as the trigger for your Automation?

If you wish to simply query the object Schema, you can do that using a Scheduled trigger OR you can use the Lookup Objects action which will allow you to run any AQL and use the results of that AQL further down the automation in a smartvalue.

Otherwise you'll have to specific a field that is on the issue on which it will fetch the data

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-objects

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-insight/#Lookup-objects

[Bryan Tito]

Hi @Dirk Ronsmans thank you for checking on this. 

What are you using as the trigger for your Automation?

- We used the Field value changed of a customfield that we have created. When this field is updated by an agent it will add or remove him/her from a group.

[Bryan Tito]

Also when we add an AQL the mapping it disappears.

[Dirk Ronsmans]

Can you elaborate a bit on the automation use case itself?

So,

1. Field "Turn on Autoassign?" is updated
2. look in Assets for that person?
3. If value of the field = Yes -> Do something (and what exactly?)
4. If value of the field = No -> Do something else? (and what exactly?)

is this pretty much what you are trying to do?

[Bryan Tito]

Surething,

1. Field "Turn on Autoassign?" is updated
2. look in Assets for that person? - It will look for an attribute for on agent/user. Example: location.
3. If value of the field = Yes -> Do something (and what exactly?) - the agent will be added to the group that will do a round robin assigning of ticket on that group.
4. If value of the field = No -> Do something else? (and what exactly?) - will remove the agent from the group.

Thanks you,

[Stephen Wright _Elabor8_]

Hi @Bryan Tito 

Why won't it let you query them? Will it not let you enter anything into the Assets Field / Query boxes?

For Assets Field, this is a search box, not a drop-down menu. It will show results as you begin typing into it.

For help with AQL, see this help page.

Ste

[Bryan Tito]

Hi @Stephen Wright _Elabor8_ thank you for checking on this.

On the Query tab, it won't let me type on the text box, while on the Assets nothing comes up on it even though we have already have created some Assets.

[Stephen Wright _Elabor8_]

Hi @Bryan Tito 

And you are creating the Objects rule at a Global level, as the purple note suggests in your screenshot?

Ste

[Bryan Tito]

Helo @Stephen Wright _Elabor8_ we have tried it via Global Automation but it seems it is the same.

Please see screenshot.