You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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")