Team Calendars for Confluence: 2000 user tier?

[IT Support]

I see that Confluence Team Calendars for server has the following licensing tiers:

• 250 users: 2000 USD/mo
• 500 users: 2000 USD/mo
• 4000 users: 4000 USD/mo

So the cost for 500 and 250 users is the same (2000 USD) but the next tier jumps all the way to 4000 users at 400/USD/mo.

I am not used to seeing monthly rates for server licenses, but OK...

However, is it really the case that, even though we have a 2000-user confluence license, we would have to pay for a 4000-user license for Team Calendars?  At a monthly rate?  At 4000 USD... per month?  In other words: 48,000 USD / year, which is much more than what Confluence costs itself at our tier (16,000 year 1)?

Just curious.

-Michael

team calendars for confluence.png

team calendars for confluence- price.PNG

confluence pricing.PNG

[PD Sheehan · Accepted solution]

Using the scriptrunner script editor, create a file with a name like "totalProjectRatingCalculationBehaviour.groovy"

Add the following to the file:

import com.atlassian.jira.issue.customfields.option.Option
import com.onresolve.jira.groovy.user.FieldBehaviours
import groovy.transform.BaseScript

@BaseScript FieldBehaviours fieldBehaviours

def strategicImportanceFld = getFieldByName('Strategic Importance')
def customerImpactFld = getFieldByName('Customer Impact')
def stakeholderBuyInFld = getFieldByName('Stakeholder Buy-In')
def timeToImplementFld = getFieldByName('Time to Implement')
def resourceRequirementFld = getFieldByName('Resource Requirement')
def totalProjectRatingFld = getFieldByName('Total Project Rating')

def strategicImportanceValue = (strategicImportanceFld.value as Option).value as Integer
def customerImpactValue = (customerImpactFld.value as Option).value as Integer
def stakeholderBuyInValue = (stakeholderBuyInFld.value as Option).value as Integer
def timeToImplementValue = (timeToImplementFld.value as Option).value as Integer
def resourceRequirementValue = (resourceRequirementFld.value as Option).value as Integer

def totalProjectRatingValue = strategicImportanceValue * 0.25 +
        customerImpactValue * 0.25 +
        stakeholderBuyInValue * 0.25 +
        timeToImplementValue * 0.15 +
        resourceRequirementValue * 0.1

totalProjectRatingFld.setReadOnly(true).setFormValue(totalProjectRatingValue)

From scriptrunner behaviour, create a new behaviour configuration that maps to the correct projects/issue type.

Add each of your 5 source fields to the behaviour configuration. For each field, add a server-side script and then change the script from in-line to file. Point to the file you created above.

Save the behaviour.

Now, each time you modify any of your five fields, the Total Project Rating field will automatically update with a fresh calculation.

[Parsa Mounika]

Hi @PD Sheehan , the script is not working. I tried it in listeners and behavior also but still not working.

[PD Sheehan]

This is a behaviour script. I can only work in a behaviour configuration like I described.

Can you please include screenshots of your behaviour configuration?

Also can you verify that the field names in the script are spelled 100% correctly?

Are you finding any errors in the <jira-home>/log/atlassian-jira.log when you try to create issues?

[Marta Woźniak-Semeniuk]

Here is a thread where script runner solution was proposed for similar calculation https://community.atlassian.com/t5/Jira-questions/Calculation-custom-field-based-on-other-custom-field-during/qaq-p/863490 :) 

Also here https://community.atlassian.com/t5/Jira-questions/custom-fields-and-calculated-custom-fields/qaq-p/870102

and herehttps://community.atlassian.com/t5/Jira-Core-Server-questions/Custom-field-calculated-from-other-drop-down-fields/qaq-p/1150592

Check it out - it might help

[Parsa Mounika]

Hi @Marta Woźniak-Semeniuk those are not related to my requirement.