How to create an automation rule that updates an Epic's custom field with its completion percentage?

[Fernando Martinez]

I am trying to build an automation rule that meets the following requirements:

1. Executes weekly.
2. Selects target Epics via JQL.
3. For each of the Epics selected, the percentage completion of the Epic is computed. Completion of each child issue is defined as the issue being resolved.
4. For each of the Epics selected, the computed percentage completion is set into an existing field in the Epic.

I am not sure how to implement step (3). I was hoping to put the percentage completion into a smart value for each Epic, and then use that value in step (4).

[Nic Brough -Adaptavist-]

What do you mean by "tied"? 

At a guess, you mean "user who has some level of access to the project", which is not a simple lookup.

Instead of looking for a technical answer that might not really be useful for what you're trying to do, could you explain why you ask?  What are you trying to achieve?  What is the question you're trying to answer with "a list of user ids and project"?

[Krishna Chaitanya]

I would like to fetch the user ids and all the projects they were associated with the project roles in oracle

[Nic Brough -Adaptavist-]

Again,

Instead of looking for a technical answer that might not really be useful for what you're trying to do, could you explain why you ask?  What are you trying to achieve?  What is the question you're trying to answer with "a list of user ids and project"?