Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is it possible to modify the DB through an External Tool / Process

Assuming I am running JIRA Software on a Server,

I need to modify the SQL DB through an external tool to obtain or modify a field.

for example:

{{customfield_10060}}

I want to be able to modify that later on by having an external Form/Process send into the JIRA's DB and modify that custom field.


is this possible? 

4 answers

1 vote
Brant Schroeder Community Leader May 18, 2021

@Bruno Sergio Pongetti Goldemberg - It is possible but I would not recommend it.  If you are using an external form I would suggest using the Jira API.  https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/

ok, let me go further and ask this:

After the ticket has been resolved and done.

Can I send on the E-mail "Your ticket has been solved" a (Button) through HTML

(something like this:   <a href="Website/CODE/ETC"> Bad </a> then <a href="Website/CODE/ETC"> OK </a> and finally a <a href="Website/CODE/ETC"> Good </a>) 

so I can get it to modify my custom field on the ticket in JIRA? 

That wouldn't be an outside form and it would get the job done , right? 

Any suggestions on how to code that?

not rly good with RESTful API (I know its possible by doing for example:

https://brunogoldemberg.atlassian.net/rest/api/2/issue/DEM-146/(something here to set value of field as "1")

https://brunogoldemberg.atlassian.net/rest/api/2/issue/DEM-146/(something here to set value of field as "2")

https://brunogoldemberg.atlassian.net/rest/api/2/issue/DEM-146/(something here to set value of field as "3")

 

if you can point me on right direction on how to do that it be all I need :)

Brant Schroeder Community Leader May 18, 2021

@Bruno Sergio Pongetti Goldemberg - Are you trying to get them to provide user feedback on the issue, a rating?   If so I would suggest looking at Jira Service Management.  It has what you are describing built-in and allows the customer to rate their experience.  Have you looked at that product.  

issue is that the customers need to be log in to provide Feedback and that is "not" a viable option......

 

 but as I said, I need a way to get feedback from a non-registed customer through Email that they can click on a HTML Button or something and it gets attached to the Ticket that they opened.

if you could provide me with an example or a solution it be much appreciated.

Brant Schroeder Community Leader May 19, 2021

@Bruno Sergio Pongetti Goldemberg Jira service management does not require the customer to have a Jira licence, it provides them with a portal that they can review past and current issues they have submitted, the portal also allows them to submit issues and you to collect information at the time of submittal.  It has built-in feedback and rating that does what you are talking about. They can rate you by clicking an email button that records the rating and takes them to a page where they can provide additional comments about the rating.  You should check out the free cloud product and see if it meets your needs.

Like Joe Pitt likes this
0 votes
Joe Pitt Community Leader May 18, 2021

Directly modifying the JIRA database may lead to corruption and you'll be on your own to fix it. Just don't do it

I am taking all this in consideration too.

just checking my options.

0 votes

Do not do this.

Most people who suggest modifying a Jira database with SQL fail to recognise that they don't really understand it well enough, run their "clever" query and end up with a corrupt database.   

You are totally unsupported from the moment you do it as well

On top of that, the only safe way to do it is to stop Jira, take a full backup of the database, restore it somewhere else to prove it is a good backup, run your SQL, restart Jira and then run a full locking re-index.  You can probably see that that is hours, possibly days, of downtime.

I agree, but as I said, I need a way to get feedback from a non-registed customer through Email that they can click on a HTML Button or something and it gets attached to the Ticket that they opened.


Oh, well, I wouldn't have got anywhere near the database for that.

If you've got Jira Service-Management, then you could set them up as customers (it does mean registering, but not an account that costs anything).

If you don't, then you could ask them to send emails to a monitored box, and have an "email handler" that uses a dummy or dedicated user as the reporter instead of a user account.   (JSM has an equivalent so customers can do all of it by email, it's a bit more powerful than the email handler for plain Jira)

Or you could do that as a dummy, and write your html so that it sends an email for them.

Or you could write html that doesn't bother with email, but pokes something in over the REST API

0 votes
Daniel Ebers Community Leader May 23, 2021

Hi  @Bruno Sergio Pongetti Goldemberg

I agree with Brant to use Jira Service Management own's "Customer Satisfaction Surveys (CSAT)" and also agree with Nic not to touch the database for this.

Just for completeness - here is the documentation in case you want to give this convenient option a try:

Regards,
Daniel

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you