Script/ database change to "shared with" parametr to share all my filters with all logged users

[Joanna Bajda]

Hi,

I'm lookig for a script/ a way to share all jira filters with "all logged users" at once.

I have around 3k filters and need to change permissions for all of them, anyone can help with that?

Best Regards

Joanna

[Dinesh]

List of User Logins/Logouts from Audit

This groovy script creates an xml output of the audit log filtered by the User Access category, so dates of when users logged in or logged out.

script:

1. import com.axeda.drm.sdk.device.ModelFinder  
2. import com.axeda.drm.sdk.Context  
3. import com.axeda.common.sdk.id.Identifier  
4. import com.axeda.drm.sdk.device.Model  
5. import com.axeda.drm.sdk.device.DeviceFinder  
6. import com.axeda.drm.sdk.device.Device  
7. import com.axeda.drm.sdk.audit.AuditCategoryList  
8. import com.axeda.drm.sdk.audit.AuditCategory  
9. import com.axeda.drm.sdk.audit.AuditEntryFinder  
10. import com.axeda.drm.sdk.audit.SortType  
11. import com.axeda.drm.sdk.audit.AuditEntry  
12. import groovy.xml.MarkupBuilder  
13.   
14. /* 
15. * AuditEntryList.groovy 
16. * 
17. * Creates an xml output of the audit log filtered by the User Access category, so dates of when users logged in or logged out. 
18. * 
19. * @param days        -   (REQ):Str number of days to search. 
20. * 
21. * @author Sara Streeter <sstreeter@axeda.com> 
22. */  
23.   
24. def writer = new StringWriter()  
25. def xml = new MarkupBuilder(writer)  
26.   
27. try {  
28.     def ctx = Context.getUserContext()  
29.     ModelFinder modelFinder = new ModelFinder(ctx, new Identifier(1))  
30.     Model model = modelFinder.find()  
31.     DeviceFinder deviceFinder = new DeviceFinder(ctx, new Identifier(1))  
32.     Device device = deviceFinder.find()  
33.     AuditCategoryList acl = new AuditCategoryList()  
34.     acl.add(AuditCategory.USER_ACCESS)  
35.     long now = System.currentTimeMillis()  
36.     Date today = new Date(now)  
37.     def paramdays = parameters.days ? parameters.days: 5  
38.     long days = 1000 * 60 * 60 * 24 * Integer.valueOf(paramdays)  
39.   
40.     AuditEntryFinder aef = new AuditEntryFinder(ctx)  
41.     aef.setCategories(acl)  
42.     aef.setToDate(today)  
43.     aef.setFromDate(new Date(now - (days)))  
44.     aef.setSortType(SortType.DATE)  
45.     aef.sortDescending()  
46.     List<AuditEntry> audits = aef.findAll()  
47.   
48. // assemble the response  
49.     xml.Response() {  
50.         audits.each { AuditEntry audit ->  
51.          
52.             Audit() {  
53.                 id(audit?.id.value)  
54.                 user(audit?.user?.username)  
55.                 date(audit?.date)  
56.                 category(audit?.category?.bundleKey)  
57.                 message(audit?.message)  
58.             }  
59.         }  
60.     }  
61.   
62. } catch (def ex) {  
63.     xml.Response() {  
64.         Fault {  
65.             Code('Groovy Exception')  
66.             Message(ex.getMessage())  
67.             StringWriter sw = new StringWriter();  
68.             PrintWriter pw = new PrintWriter(sw);  
69.             ex.printStackTrace(pw);  
70.             Detail(sw.toString())  
71.         }  
72.     }  
73. }  
74.   
75. return ['Content-Type': 'text/xml', 'Content': writer.toString()] 

[Joanna Bajda]

Hi Dinesh,

It's not what I"m looking for I'm afraid, 

I need to change permissions for all my filters, and what to do this with script if it's possible.

Joanna

[Dinesh]

Hi Joanna,

      Try this script in script runner plugin and if possible send the screenshot of your requirement where you should change the permissions of all your filters. 

Dinesh.

[Joanna Bajda]

This script does not work at all, please see screen shot, but as I said before it's not what I'm looking for (This groovy script creates an xml output of the audit log filtered by the User Access category, so dates of when users logged in or logged out)

What I need is:

I have over 2k shared filters - shared with some groups, projects, public etc. I

need to change Shared With parametr all of my filters to "Shared with all logged users". All users in my company need to be able to see all filters,

Doing this one by one will take ages, so I'm looking for a script or maybe database change will do the job.

[Dinesh]

ok

[Dinesh]

Hi,

Script to change permissions

import com.atlassian.jira.bc.JiraServiceContextImpl
import com.atlassian.jira.bc.filter.SearchRequestService
import com.atlassian.jira.bc.issue.search.SearchService
import com.atlassian.jira.component.ComponentAccessor
// import com.atlassian.jira.issue.search.SearchRequest
import com.atlassian.jira.sharing.SharePermissionImpl
import com.atlassian.jira.sharing.SharedEntity
import com.atlassian.jira.sharing.type.ShareType
import com.atlassian.jira.issue.search.SearchRequestManager
import com.atlassian.jira.issue.search.SearchRequest

def searchRequestService = ComponentAccessor.getComponent(SearchRequestService)
def user = ComponentAccessor.jiraAuthenticationContext?.getLoggedInUser()
def searchService = ComponentAccessor.getComponent(SearchService)
def serviceContext = new JiraServiceContextImpl(user)
long filterId = ------
def searchRequestManager = ComponentAccessor.getComponent(SearchRequestManager)
def ab = searchRequestManager.getSearchRequestById(filterId)
def sharePerm = new SharePermissionImpl(null, ShareType.Name.GLOBAL, null, null)
ab.setPermissions(new SharedEntity.SharePermissions([sharePerm] as Set))

Try this and do some changes according to your requirement.