What options exist for creating a custom field in Conlfuence projects that would have options determined by the results of a query to external data source? I've seen varied approaches (from using a custom ajax service to inject picklist values upon page load, to middleware, etc) but I was wondering if there's anything analogous to the nFeed product for JIRA (in either a plugin or even an open source format).
Thank you Diep, I have responded to you via email but wanted to post this in case others come across the question and had more input. This is just one approach, obviously :)
My main need is to have a database connector to Salesforce.com(which has both Ajax, REST and SOAP Apis available) where I can map a query result to a custom field in Confluence that provides users a select list (single pick list or multi-select) to choose one or many values.
The custom field would have a flag for " single or multiple" value. In addition to this, the data stored in the custom field on confluence would probably need to be multipart – consisting of data pairs (to support a multiple select) :
I assume you could map the fields from the SOQL query back to the confluence values either by using order (1st is Id, next field is DisplayName) or SOQL aliasing.
Example SOQL statement with alias to Conlfuence field names : [ SELECT Id externalId, Degree_Catalog_Name_c conlfuenceDisplayValue FROM Degrees_c WHERE Active_c = true ]
Example Use Case:
In confluence we have Pages where a page represents a Class in our university. We'd like to associate the page to Degrees that offer it.
I'd add a custom field to the Class page template, name it "Degree Program", choose whether it can have single or multiple values (multiple in this case), then I'd be able to write a Salesforce query (SOQL language) in a text box that can define the records that would appear as pick list options when a Conlfuence user was filling in the field. Ideally, in the setup screen where you are defining the custom field's query, there would be a "test query" button and a feedback box to confirm data returned by the query - (show a row count of returned records or display any error messages like 'invalid query: field does not exist")
Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...
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