Jira Cheatsheet

JQL

Show tickets created by a user

This will also show them in descending order, which will give you the most recently created issues first.

reporter = <username> order by created DESC

Query by project

project = "Project Name"

Find issues belonging to an inactive user

reporter in (inactiveUsers())

Resource:
https://community.atlassian.com/t5/Jira-questions/Finding-Issues-Owned-by-Inactive-Users-with-JQL-without-buying/qaq-p/686192