Tuncay Senturk _Snapbytes_ Community Champion

Hello, The SQL query you attached seems to be correct. What is the result or error when you run this query?

Now it is clear, You want to send notification to assignee if assignee is not A or B. There is no such feature currently You can use project role but this way every time the users who have role will get notified (no matter the issue is assigned to them or not) Regards

Did you check Jira's email queue for errors? Do those A and B users have valid email addresses? What do A and B have in common and they are different from other users? Do you have an idea?

Hello Marzi Could you please clarify? How can an assignee be both A and B? It should be either A or B, and TTS should send the notification to any of them.

Hello @tom-42mo They have very different architectures (servlet, REST service and xml and soy template etc). I generally implement a single service to generate report data and use this service both in gadget and report. I'm afraid, UI layer should be written separate. If you find any better solution, please share ;) Cheers

So, you should define those user/date fields, then write script to copy/store JEP field values to those customfields.

Hello @Prashanth I think we're talking about Enhancer Plugin, aren't we? If correct, JEP fields are also custom fields. Why do you want to migrate them to other custom fields? I think you want to copy JEP field value to another custom field (e.g. date field) and after migration and reindexing you want to compare the new…

Hello Cameron, Actually you did everything except joining those tables. Try below SQL SELECT jiraissue.issuenum, jiraissue.summary, projectversion.vname, projectversion.description FROM projectversion, jiraissue WHERE projectversion.released = 'true' and projectversion.project = <project_id> AND projectversion.project =…

Welcome Mehmet to the community ;)

You're very welcome 

Hello Satish, I'm not sure but it sounds like a race condition. The issue fires the event just before persisting to database. Is it possible to wait a while before running issueManager.getIssueObject(jira_defectId) code?

Hello Satish, Please clarify more Are you trying to create a workflow post function to transition the related tasks? Can you share your code? Are you getting any error/exception? Or the problem is uncompleted transition for the two related issues? Thanks

I don't think you could do that without an app. There are multiple solutions to add user(s) to watchers list upon issue creation.

Click on search icon on the left, then click on View all issues. Specify your search results for your next gen projects. When issue nav lists your issues then click on (...) on the top right. It should be there if you have Bulk Edit global permission.

Hello, I'm not sure but it seems that you're running both applications in same server and their cookies are overridden. You should separate their context urls as described here. Hope it helps

Hello, Using the JQL of the board search issues in issue navigator, click on Tools > All n issues for bulk operation. Selecting the issues in the screen click Next and then select Watch Issues and Next to confirm. If I'm not missing anything this should help you without any 3rd party apps.

100 users license would work

Hello, It may depend on the app but for most of the Atlassian apps, the app tier should match the maximum tier of the licensed Jira product. For Jira 7.0 or later, the app tier should match the maximum tier of the licensed Jira products on your instance. For example, if you're running Jira Software (500 users) and Jira…

Hi Joseph, Did you check the Jira log file (atlassian-jira.log)? There should be something wrong there which may give us clue.

Hello Richa, As far as I know you can't do that without an app Enhancer Plugin has Reopening Counter custom field. If you define the custom field you can use below query: fixVersion = 1.0 and "Reopening Counter" > 0

Hello, I don't know the exact answer but I faced the similar issue. That's why I often use java.util.Date in my entities. Anyway, if you have interesting findings, please share with us.

Hello, If you reindex Jira, those values will also be populated. I mean you'll have values for already existing issues after reindexing Jira/project. Best

Hello In workflow post function you can use below methods to get issue before transition and after transition Issue issueAfterTransition = (Issue) transientVars.get("issue"); Issue issueBeforeTransition = (Issue) transientVars.get("originalissueobject"); So, you can use issue.getStatus() for both to get old and new value.…

Hello Mehak, IMHO, getting those values from database is not a good practice. Those tables (changegroup and changeitem) are one of the most used tables for Jira application so that hitting database for such queries may affect your Jira performance. At least you need to run the query from T - 1 database. Think twice before…

Hello @Brian Moudy Did that work?

@Monique vdB * After getting 100 accepted solutions badge I earned Badge-Me March badge * Then I earned First Article Written badge * Then I earned 25 Topics created badge So, would I earn Re-Badge-Me March badge?

Hello, I think you're getting this problem if the field value is empty. If so you should add a null check as below. Or you can change accordingly. I mean if there's no version selected you can return false or true if (null == currentValue) return false; if (['R12-Current', 'ml-current'].contains(currentValue[0].name)) {…

Both single and multi value version selector returns an array. And the code that I sent you is tested. Can you share the whole code and the error you're getting?

I think this error is not related with database configuration but lacking of guava dependency. Try adding following dependency <dependency> <groupId>com.google.guava</groupId> <artifactId>guava</artifactId> <version>26.0-jre</version> <scope>provided</scope> </dependency> Hope it helps

I can be the one who grabbed the first badge of March. I earned 100 accepted answers on 1st of March. If we can't count that I'm totally lost like @Fadoua