Thanks for the response John, we had seen that but had hoped to be able to avoid creating one to one mappings between ProForma fields and custom fields, instead noted that Proforma stored it's state in the issue's meta data, and hopted there was an example of accessing that in a post function ? or any other cunning way to populate an indexed field ...
I'm Andrew, Support Engineer for ThinkTilt's ProForma product.
ProForma stores its data directly in Jira, without using any external database. The data is stored in Jira entity properties on the issues and projects in your Jira instance. ProForma accesses the data by using Jira's APIs. The forms and form templates are stored as JSON data structures. As yet, we don’t have a public API but it is on the roadmap.
What exactly is your business use-case for accessing the form data? Are you willing to share that? I see you mention Post Functions? We have had other’s who have extracted data and we have supported them to access their data via Scriptrunner etc.
Additional to John's response of linking ProForma form fields to Jira fields, there are some limitations with which in-built Jira fields you can link to. See more info about that -- as well as our suggested workarounds for it -- in our documentation linked here .
Nevertheless, you can create custom Jira fields and link to those fields in your forms for reporting purposes too. It should be noted that any Jira fields linked to a ProForma field will be searchable via JQL.
Currently in terms of data exporting, I thought I would also inform you of the ability to download form data in one of two ways:
Does any of this info help?
Let me know how you go.
wow, thanks for the reply Andrew - our use case is to implement a business impact analysis where there are 5 global regions - each with an high/medium/low impact, further split into the region's countries again with a high/medium/low impact and for all impacts to be reportable via JQL only. This could result in 80+ single select drop down ProForma fields with each having to be mapped to a Jira Custom field. If we had an option of a multi-select field to allow selection of highly/medium/lowly impacted countries this would reduce the number of custom fields mapped dramatically - however given Profields current functionality of storing a document's state in the entity.properties as you describe, we had hoped to be able to extract the individual countries' impact values into a set of Jira Custom 'multi-select' or at least indexed fields within a Post Function with Scriptrunner or similar, any complete/partial snippets of such code would be great headstart for us if you believe that route is appropriate.
Thanks for providing the business context use-case - we're always interested to know how ProForma is trying to be used and applied, and whether we can adapt to satisfy particular business use-cases.
You're in luck - I should inform you that multi-select choice fields is actually an upcoming item that is currently in development and is aimed to be included in our next release, which sounds to be something you would find benefit in. What do you think - would that help?
:) aimed :) ... yep understood, in good faith ... yes the multi-select choice list certainly appears to solve our issue. However we have to justify the Add-on now to our management/procurement.
We face two potentially major issues we hope the multi-select would solve:
1/ Our forms without it are unwieldy - even with e.g. conditional show/hide of sections
2/ The system performance impact that that number of Custom fields (80++) we would need to create and subsequently map to make the data queryable by JQL.
We could hopefully convince management/procurement to live with point 1/ until the new control is available. However the performance impact of having the additional custom fields could be a deal breaker for us, and once the Users approve it they will expect it in our Production instance - it's currently in a Dev/UAT instance - in short order .. so .. back to the original workaround options until the multi-select control is available .. can you shed any light on how to access the entity.properties data and scrape it into a single/fewer custom fields .. or even if that's a possibility or other automatable/scriptable options to expose the Form data? We do understand we've a somewhat square peg for a round hole for this use case and Jira. Thanks for your consideration
... longer term, could ProForms flag values embedded in the entity properties as per below:
The products have access to your properties.
This means that you can write JQL queries based on issue entity properties, enabling users to enjoy the power of JQL on search data that you have defined.
In response to your question
"longer term, could ProForms flag values embedded in the entity properties"
Proforma's form data is already stored in Jira entity properties on the issues and projects in your Jira instance. If you have the Entity Properties app installed alongside ProForma, you'll be able to see the form data, structure, questions answers
where i1 is the first form attached, 2 represents question 2
However usage of this is limited as it does not work well with accessing answers to choice list questions, and hence why we have upcoming work on building an Answers Array to better access all form data fields and values.
That being said, I know it's not helpful right now knowing there are features on the way but not yet released (as you said you need to know what data access solutions ProForma has available in the market currently), but we also have some data download APIs on the way very soon that will provide features such as integration with JQL to allow a better search experience for users, and providing form data in JSON format as well as spreadsheet format if that helps.
We will endeavour to keep you updated when these features are released.
Atlassian's marketplace partners have had a very productive start to 2021! Since our last roundup, our developer community has added over 160 new cloud apps to the Atlassian Marketplace to help you...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events