Hi Friends, I have created webresource plugin module to remove issuetypes in javascript I want to retrive jira database values using sqlprocessor or ao, How would I use database values in IssueTypesResctictor.js ? atlassian-plugin.xml*********************************************************** jira.webresources:global-static JavaScript atl.general atl.admin IssueTypesResctictor.js*********************************************************** jQuery(document).ready(function($) { JIRA.bind(JIRA.Events.NEW_CONTENT_ADDED, function (e,context) { hide(); }); hide(); function hide() { $("#issuetype option").each(function() { if($.trim($(this).text()) == 'Bug') { $(this).remove(); } }); } }); *************************************************************************** Thanks in advance & Best Regards Onkar Ahire

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to use sqlprocessor or ao in javascript

Onkar Ahire

Hi Friends,

I have created webresource plugin module to remove issuetypes in javascript I want to retrive jira database values using sqlprocessor or ao,

How would I use database values in IssueTypesResctictor.js ?

atlassian-plugin.xml***********************************************************

&lt;web-resource key="IssueTypesRestrictor-js" name="javascript"&gt;
        &lt;dependency&gt;jira.webresources:global-static&lt;/dependency&gt;
        &lt;description&gt;JavaScript&lt;/description&gt;
        &lt;resource name="IssueTypesRestrictor.js" type="download" location="js/IssueTypesRestrictor.js" /&gt;
        &lt;context&gt;atl.general&lt;/context&gt;
         &lt;context&gt;atl.admin&lt;/context&gt;
&lt;/web-resource&gt;

IssueTypesResctictor.js***********************************************************

jQuery(document).ready(function($) 
{
JIRA.bind(JIRA.Events.NEW_CONTENT_ADDED, function (e,context) {
    hide();
});
hide();      
function hide()
	{
        $("#issuetype option").each(function()
        		{              
                	if($.trim($(this).text()) == 'Bug')
                	{
                		$(this).remove();
                	}
        		});
	}
});

***************************************************************************

Thanks in advance

Best Regards

Onkar Ahire

Accepted answers

RambanamP

create your own rest api using REST plugin module and implement all you logic in that rest

so later you can call that rest in javascript file

check this for rest plugin module

https://developer.atlassian.com/display/DOCS/REST+Plugin+Module

All comments

RambanamP

create your own rest api using REST plugin module and implement all you logic in that rest

so later you can call that rest in javascript file

check this for rest plugin module

https://developer.atlassian.com/display/DOCS/REST+Plugin+Module

Mizan

It seems you are trying to hide certain issue types .

Good way to do is use behaviours plugin and write a groovy script .

Onkar Ahire

@Rambanam as you said to use rest api , can we retrive db values in restapi ?

Onkar Ahire

Thanks Mizan I appriciate it is possible using groovy script and behaviour plugin, Above script is hardcoded.

I am writing a plugin which will save restricted issue types in database using project specific configuration(project-tab-panel) and while creating an issue it will run the above script and validate the restricted issue types which saved in database and remove that issuetypes from issuetypes field but seems it might not possible to use sqlprocessor or ao,

so moving a head I got an idea to write a plugin to extend the capabilities for creating issue, there I can use sql processor or ao at the time of validation and use addfielderror message if issue type is restricted for specific user/roles(restricted issue types will be saved in db as a configuration of project) but again here I stuck with https://answers.atlassian.com/questions/222470/extend-the-capabilities-for-creating-issue

Can anyone suggest solution?

Thanks

RambanamP

yes, you can retrive db values using JDBC or by using JNDI configuration.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira