Smart values and manual Actions

[Michael simon]

Hi Guy, 

i had an automation which used a smart value from a custom field:
{{issue.customfiledname}}

I had the automation "create subtask" whenever a Issue was created.

This subtask got filled with information from the normal task. 

Everything worked fine!

now i wanted to stop the automation to activte after creating an issue. I now wanted to switch it to "manuel trigger". So i took my existing automation and just replaced the trigger, nothing else. 

Now all my smart values are empty? 
How to fix this?

[Yogesh Mude]

Hi @Manu Mishra

Here is the same question has been posted by one the user, please have a look at it.

For this, you need to run the SQL query on Database.

https://community.atlassian.com/t5/Jira-questions/Database-query-to-check-number-of-issues-associated-to-a-project/qaq-p/447137

Hope it helps.