How to assign the action of an automation rule result to a user rather than the automation owner

[Miguel Rodriguez]

I created some automation rules that inherit some fields and labels from parent tickets when the new child is created. However in the History it appears as if I did the change of fields. Is there an option to make the history appear under the name of the person who is creating the new child issue or a "system" change, rather than my name?  

[Moses Thomas]

@Prasanth Sai Shiramshetti You  can  do something like this  make your have the time tracking enable, script runner for Jira.

You  can write the JQL query to  get  it

project in (CompanyA,CompanyB,.....) AND issueFunction in aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()")

best!

[Prasanth Sai Shiramshetti]

@Moses Thomas could you please explain me more elaborately as I am not much proficient with JIRA. Where I can write this query ? Can you please provide me the navigation path or the screen shots. Thank you.

[Moses Thomas]

@Prasanth Sai Shiramshetti You can  type it in the search for issues  box advanced mode.

[Prasanth Sai Shiramshetti]

@Moses Thomas

I need to find the time for all the ticket for a Company based on Created Date and Act QA Completion Date. Is it possible? if yes, can you provide me the query for this. Thank you

[Prasanth Sai Shiramshetti]

@Moses Thomas 

I would like to know the time difference between two fields in JIRA for all the tickets completed for one customer at a time.  One is Actual QA Completion date and the other is Created date. This would give me the total handling time of the ticket. 

For ex:  In the above screenshot, I would exactly require the difference of Act QA Completion date which is 28/May/2018 and Created date which is 18/May/2018. The result would be approx 10 days. SO, I need this operation to be performed for all the tickets for one customer at a time. When I tried, I have got the below error. Please provide me the solution for this requirement. Thank you.

[Moses Thomas]

@Prasanth Sai ShiramshettiYou need to  install script runner  plugin for JIra

[George Mihailoff]

This addon provides totals for time spent on tickets https://marketplace.atlassian.com/apps/1218809/quantify-ai. Time is calculated automatically based on statuses, and you can adjust what to include in the calculation.