-
Type:
Suggestion
-
Resolution: Unresolved
-
None
-
Component/s: API and Integrations, Assets - IQL and Object Search
-
1
Customers may be using Assets to manage their assets in Jira, still having other external systems for various opperations
To make it easier for Users of external systems (e.g. Salesforce) - we can save and share IQL filters from assets, however, we can only do that manually.
It will be beneficial to allow a REST API to return all Filters accessible to a user, so the filters can be used for hyperlinks on a 3rd party application page, created automatically.
A Workaround to achieve this today (simplified, general outline - can be adjusted/more elaborated):
Add an Object Type called "Filter", see attributes below.
Configure a DB Import (As a Jira Admin) from the Jira DB, mapping the Filter object type using the selector (postgres):
SELECT * FROM "AO_8542F1_IFJ_ON_FILTER"
Map the following Datalocators to attributes of the Filter Object Type:
NAME >>> Filter Name (text)
CRITERIA >>> AQL (text)
ID >>> Filter ID (INT)
SCHEMA_ID >>> Schema ID (INT)
OWNER_USER_KEY >>> Owner (User)
....
Add an Attribute (Text or URL) called "Filter URL"
And configure an Automation rule to update this attribute:
WHEN: Object Created
IF: objectType=Filter
THEN: Action > Attribute Value:
Set the attribute "Filter URL"
with a value:
<JiraBaseURL>/secure/insight/search?filter=${Filter ID}&schema=${Schema ID}
======
The import will create and populate Filter objects, and trigger the automation rule.
The Automation rule will populate the "Filter URL" Attribute with the Filter URL.
The 3rd party addon can now use the Assets REST API to get the Filter objects (e.g. AQL with Attributes) - and parse / use the "Filter URL" Attribute to set a hyperlink to a saved filter in Assets ...
- links to