Hello, On Jira on-prem version I was able to use IQL on Jira Cloud not able to find. Any suggestions? I have a like 7 layers structure with inbound and outbound references. I would like to f...
Buenas tardes... Tengo dos preguntas en la base de datos de los activos de insight. 1.- Quiero crear un filtro dinámico según la selección del campo "Departamento" tipo objeto. para si es IT ...
Is there any way to compare two dates attributes of the same Object Type in an Insight IQL search Example (not working) "Start Project Date" = "End Project Date" Thanks
...ame. In my imagination, it should look like this: project = ITSMDEV AND labels = Potential_problem ORDER BY iqlFunction("assetName = \"Business Application\" ORDER BY \"Name\" ASC")&n...
I am racking my brain - can someone help? I have 2 object Types Organization Attribute: Orgshort value = Superstore &nbs...
I am trying to learn about IQL, specifically inbound and outbound references. All the Atlassian documentation references are confusing as I do not have a schema to cross-reference. Is there a...
Hi all :) we have two Assets ObjectTypes - "Groups" and "Items" - with a parent-/child entity. Now we like to filter for "Items" that belongs to a "Group", but only if "Group" is given, meaning if ...
Hi all, I have tried to death this guide on limited selection using AQL Placeholders for Create/Edit objects and it works in some cases but when I try to expand this to anything outside of a very ba...
I am importing a CSV and using IQL to do the mapping. I have references to a different schema. According to some of the videos I have watched, I should be able reference d...
...how products that belong to the country of the previously selected Company(SUPP). Here is my configuration for: Product DEV (customfield_13602): Object Schema: MyProject Filter Scope (IQL...
Hello All! I am a new Jira admin (I mean brand new), who is taking over a new site that has some uploaded Assets data that includes customers, employees, roles, etc. We have a custom field for...
I would like to search for all object of a specific objecttype, if they only have an inbound reference from another type with a specific name. Basically I have all my servers linked to from an IT ...
Greetings, Is it possible to write an AQL query that will parse the string after the index of specified character? I want to use it for matching attributes when importing objects with refer...
Hi all, assuming three object types: building every building has it's ID and name room every room has it's ID and name (not unique) and referenced object "building" device every device ha...
Hello, I have just started to use Assets and using it for the purpose of hardware and license management. I want to set up an automation that when a license is about to expire, an ema...
We have Insight Schemes where Country and Locations have been stored as objects like in below structure Object Schema Country (10) Location (20) Number in braces indicates number of objec...
Is there a user interface where I can prepare and test complete IQL statements for my Automations in the Atlassian Cloud? Using Advanced Search to create JQL statements is extremely helpful. As s...
We're testing Insight and using Jira Automation. I see we can use IQL in Automation branches, but how can we get other attribute values from the branched object? For testing, just adding an a...
I am using Jira webhook to callback the issue created/updated, which requires me to write down a JQL to filter out some results. When I check the log of the returned JSON, there are a lot ...
When creating an custom field in Jira for and Insight Object, we can define the "Filter issue scope (IQL)" What issue-related smart values can we use here as replacement values? I was hoping I c...
...bsp; <Computers> Filter Scope (IQL) objectSchema =name of objectschema <Laptops> Filter Issue Scope (IQL) o...
...ameNot. I want to connect both attributes to the object type "Notifications, so I marked them in my attributes as objects and reffer to Norification. In the import I give the IQL syntax "Label = ${I...
There's probably an obvious solution, but is there an IQL I can use to exclude objects with connectedTickets? Here is my current IQL: "Ship Date" <= now(-17d) AND "Ship Date" >= n...
Hi. I need to find specific objects in Insight (Assets) which contain a specific word in the comments. Is it possible to query the object comments, using IQL?
...orks fine: Filter Scope (IQL): objectType="System" Filter Issue Scope (IQL): objectType="System" But when I add the 'order by' clause (I tried multiple attributes), the d...
Copied to clipboard