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.
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?
@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 :)
@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.
@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.
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.
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
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:
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