Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Best way to connect to the JIRA database and pull data so that we can show on a management dashboard

Jeremy Doyle
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 18, 2021

We want to be able to pull the JIRA requests into a SQL database to display requests for Managers and what is in their current queue.  What is the best way to do that?

1 answer

1 accepted

1 vote
Answer accepted
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 18, 2014

Interesting... do you think this this an HTML problem or an issue with i18n in jira?

How does it look when you view RTL languages in the browser, is it correct?

If it's an HTML issue have you tried using the dir attrib as per http://www.i18nguy.com/markup/right-to-left.html?

Tsol
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 19, 2014

If i use

<div dir="rtl">
$m_t_u
</div>

in code the text is alligned on the right. I have just tested it.

Using

<div align="right">
$m_t_u
</div>

has exactly the same results.

Finally, it was not an HTML problem nor a i18n in JIRA. I was using wrong script in post function. :(

Thanks for the help

Tsol
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 19, 2014

I'm trying to add a conditional expression in email's body but in email i get printed the conditional expression also.

what i use is the following

content = """\

<% if (issue.getCustomFieldValue( customField_language ).toString() == "Arabic") out << '<div dir="rtl">
	  $m_t_u
	  </div>' else out << '<div>
	  $m_t_u
	  </div>'%>
"""

And the email i get is the following

<% if (issue.getCustomFieldValue( customField_language ).toString() == "Arabic") out << '
test
tetetest
testtesttest

' else out << '
test
tetetest
testtesttest

'%>

Any idea what's wrong in the syntax i use?

Thanx in advance

JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 22, 2014

I think it should be like this:

<% if (issue.getCustomFieldValue( customField_language ).toString() == "Arabic") %>
	'<div dir="rtl">$m_t_u
<% else %>
    ....

Tsol
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
February 23, 2014

I have tried your suggestion but it seems that the way the syntax is ignores the condition. Html works though.

The condition i have used is the following

<% if (issue.getCustomFieldValue( customField_language ).toString() == "Arabic") %>
    '<div dir="rtl">$m_t_u</div>
<% else %>
'<div>$m_t_u</div>

The result i get is in the next screenshot

I have tried different modifications, without luck.

Suggest an answer

Log in or Sign up to answer