Search for tasks created through the support center

Through the search for tasks or through the sql query, I want to find only tasks created through the support center. How to do it?

In which table in the database this information is stored?

Or what is the name of the field for the JQL query?

1 answer

Community moderators have prevented the ability to post new answers.

1 vote

Answer accepted

If you mean you wish to find issues created via the portal then the following JQL should work for you.

Project = xxx and request-channel-type = portal

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Exactly what is needed! Thank you very much

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.