| name | jira-search-jql |
| description | Find issues by criteria (status, assignee, priority, etc.) using JQL. Create filters, export results to CSV/JSON, bulk update. Ideal for reporting and automation. |
| version | 1.0.0 |
| author | jira-assistant-skills |
| license | MIT |
| allowed-tools | ["Bash","Read","Glob","Grep"] |
jira-search
Query and discovery operations for JIRA issues using JQL (JIRA Query Language).
Risk Levels
| Operation | Risk | Notes |
|---|
| Query/search | - | Read-only |
| Validate JQL | - | Read-only |
| Export results | - | Read-only (local file) |
| List filters | - | Read-only |
| Create filter | - | Easily reversible (can delete) |
| Update filter | ! | Can be reverted |
| Share filter | ! | Can be unshared |
| Delete filter | !! | Filter lost, but can recreate |
| Bulk update | !! | Use --dry-run first; changes reversible but tedious |
Risk Legend: - Safe, read-only | ! Caution, modifiable | !! Warning, destructive but recoverable | !!! Danger, irreversible
When to use this skill
Perfect for:
- Search by criteria: "Find all bugs assigned to me in the current sprint"
- Reporting: Export sprint results or metrics to CSV/JSON
- Bulk operations: Update labels, priority, or assignee on 50+ issues at once
- Automation: Create saved filters for monitoring or dashboards
Not ideal for:
- Single issue operations - Use jira-issue skill
- Workflow transitions on many issues - Use jira-lifecycle skill
- Complex issue relationships - Use jira-relationships skill
- Sprint/board management - Use jira-agile skill
Quick Start
jira-as search query "assignee = currentUser() AND status != Done"
jira-as search query "project = PROJ AND type = Bug AND status = Open"
jira-as search export "project = PROJ" --output report.csv
jira-as search filter create -n "My Bugs" -j "type = Bug AND assignee = currentUser()" -f
For detailed setup, see docs/QUICK_START.md.
Available Commands
IMPORTANT: Always use the jira-as CLI. Never run Python scripts directly.
| Command | Purpose | Example |
|---|
jira-as search query | Execute JQL queries | jira-as search query "project = PROJ" |
jira-as search export | Export to CSV/JSON | jira-as search export "JQL" -o report.csv |
jira-as search validate | Check JQL syntax | jira-as search validate "your query" |
jira-as search build | Build JQL from clauses | jira-as search build --clause "project = PROJ" --clause "status = Open" |
jira-as search bulk-update | Bulk update issues from search | jira-as search bulk-update "JQL" --add-labels bug --dry-run |
jira-as search suggest | Get field value suggestions | jira-as search suggest --field status --no-cache |
jira-as search fields | List available JQL fields | jira-as search fields --custom-only |
jira-as search functions | List available JQL functions | jira-as search functions --with-examples |
jira-as search filter list | List saved filters | jira-as search filter list --favourites |
jira-as search filter create | Save a reusable filter | jira-as search filter create --name "Name" --jql "JQL" |
jira-as search filter update | Update an existing filter | jira-as search filter update 10042 --name "New Name" |
jira-as search filter run | Run a saved filter | jira-as search filter run --id 10042 |
jira-as search filter favourite | Toggle favourite status | jira-as search filter favourite 10042 --add |
jira-as search filter share | Share filter with users/groups | jira-as search filter share 10042 --project PROJ |
jira-as search filter delete | Delete a saved filter | jira-as search filter delete 10042 --yes |
All commands support --help for full documentation.
What this skill does
- JQL Search: Execute custom queries with sorting, pagination, field selection
- JQL Builder: Build and validate queries interactively
- Query History: Save queries locally for quick reuse
- Saved Filters: Full CRUD on JIRA filters with sharing
- Filter Subscriptions: View email subscriptions on filters
- Export Results: CSV, JSON, JSON Lines with streaming for large datasets
- Bulk Updates: Update multiple issues from search results
Common Options
| Option | Description |
|---|
--help, -h | Show help message and usage |
--output, -o | Output format: text (default), json |
--max-results, -m | Maximum results to return |
--fields | Comma-separated list of fields |
--show-links, -l | Show issue links in output |
--show-time, -t | Show time tracking info |
--show-agile, -a | Show agile fields (story points, sprint) |
--page-token, -p | Pagination token for large results |
Examples by Category
Search
jira-as search query "project = PROJ AND status = Open"
jira-as search query "project = PROJ" --fields key,summary,status,assignee
jira-as search query "project = PROJ" --max-results 50
JQL Building
jira-as search validate "project = PROJ AND status = Open"
jira-as search validate "project = PROJ" --show-structure
jira-as search validate "project = PROJ" --output json
jira-as search build --clause "project = PROJ" --clause "status = Open" --validate
jira-as search build --clause "status = Open" --clause "status = Closed" --operator OR
jira-as search build --clause "assignee = currentUser()" --order-by created --desc
jira-as search build --template sprint-backlog
jira-as search build --list-templates
jira-as search suggest --field status
jira-as search suggest --field status --prefix "In"
jira-as search suggest --field assignee --prefix "john"
jira-as search suggest --field priority --no-cache
jira-as search suggest --field status --refresh
jira-as search fields
jira-as search fields --custom-only
jira-as search fields --system-only
jira-as search fields --filter priority
jira-as search functions
jira-as search functions -t list
jira-as search functions --list-only
jira-as search functions --with-examples
Saved Filters
jira-as search filter create -n "Sprint Issues" -j "sprint IN openSprints()" -f
jira-as search filter create -n "Team Filter" -j "project = PROJ" -d "Team issues" --share-project PROJ
jira-as search filter list --favourites
jira-as search filter list --my
jira-as search filter list --search "Sprint"
jira-as search filter list --owner "john@co.com"
jira-as search filter list --project PROJ
jira-as search filter list --id 10042
jira-as search filter run --id 10042
jira-as search filter run --name "Sprint Issues"
jira-as search filter run --id 10042 --max-results 50
jira-as search filter update 10042 --name "New Name" --jql "updated JQL"
jira-as search filter update 10042 --description "New description"
jira-as search filter favourite 10042 --add
jira-as search filter favourite 10042 --remove
jira-as search filter share 10042 --project PROJ
jira-as search filter share 10042 --project PROJ --role Developers
jira-as search filter share 10042 --group jira-users
jira-as search filter share 10042 --global
jira-as search filter share 10042 --list
jira-as search filter share 10042 --unshare 10100
jira-as search filter delete 10042 --dry-run
jira-as search filter delete 10042 --yes
Bulk Update
jira-as search bulk-update "project = PROJ AND status = Open" --add-labels needs-review --dry-run
jira-as search bulk-update "project = PROJ AND status = Open" --add-labels needs-review --yes
jira-as search bulk-update "type = Bug AND labels = stale" --remove-labels stale --dry-run
jira-as search bulk-update "project = PROJ AND priority = Low" --priority Medium --dry-run
jira-as search bulk-update "project = PROJ" --add-labels batch1 --max-issues 50 --dry-run
Export
jira-as search export "project = PROJ" -o report.csv
jira-as search export "project = PROJ" -o data.json --format json
jira-as search export "project = PROJ" -o report.csv --fields key,summary,status,assignee
jira-as search export "project = PROJ" -o report.csv --max-results 500
Using Filters in Queries
jira-as search query --filter 10042
jira-as search query --filter 10042 --max-results 100
jira-as search query "project = PROJ" --save-as "My New Filter"
Exporting Large Datasets
For large exports, optimize your query and field selection:
| Result Size | Recommendation |
|---|
| < 1000 | jira-as search export "JQL" -o file.csv |
| 1000-5000 | jira-as search export "JQL" -o file.csv --fields key,summary,status |
| > 5000 | Split by date ranges using created/updated filters |
jira-as search export "project = PROJ" -o report.csv --fields key,summary,status,assignee
jira-as search export "project = PROJ AND created >= -30d" -o recent.csv
jira-as search export "project = PROJ AND created >= -60d AND created < -30d" -o older.csv
Exit Codes
| Code | Meaning |
|---|
| 0 | Success |
| 1 | General error (API, validation) |
| 2 | Invalid arguments |
| 130 | User interrupted (Ctrl+C) |
Troubleshooting
Quick diagnostics:
jira-as search validate "your query"
jira-as search fields
jira-as search suggest --field status
jira-as search functions
For detailed troubleshooting, see references/TROUBLESHOOTING.md.
Configuration
Requires JIRA credentials via environment variables (JIRA_SITE_URL, JIRA_EMAIL, JIRA_API_TOKEN).
Documentation
Templates
Pre-configured JQL templates:
assets/templates/jql_templates.json - Common search patterns
assets/ERROR_SOLUTIONS.json - Error catalog
Related skills
- jira-issue: For creating and updating individual issues
- jira-lifecycle: For transitioning issues found in searches
- jira-collaborate: For bulk commenting on search results
- jira-agile: For sprint and board operations
- jira-relationships: For issue linking and dependencies
- jira-bulk: For large-scale bulk operations