Queries below require integration with either Github or Bitbucket.
Find CodeRepo with _beginOn > date.now-24hr and _version=1
For a developer whose first name is Charlie:
'Charlie' that OPENED PR with _createdOn > date.now - 5days as PR return PR.displayName, PR.name, PR.webLink
Or, the following query is more accurate but it requires an IdP integration and proper mapping between the dev users and IdP users:
Find Person with firstName='Charlie' that IS (github_user|bitbucket_user) that OPENED PR with _createdOn > date.now - 5days as PR return PR.displayName, PR.name, PR.webLink
This is particularly useful to identify who might be the best person to fix a newly discovered vulnerability.
Find User as u that OPENED PR as PR that HAS CodeRepo with name='repo-name' as repo return u.displayName, u.username, PR.displayName, PR.name, PR._createdOn, repo.name order by PR._createdOn limit 5
Find CodeRepo that relates to (Application|Project) with name='JupiterOne'
Find PR with approved=false and (createdOn > date.now-7days or updatedOn > date.now-7days)
Find PR with validated=false