list_work_items
List and search work items in a Polarion project using Lucene queries or native SQL for advanced filtering.
Instructions
List and search work items in a Polarion project.
Lucene query (type:requirement, title:SRS*) or omit for all. Leading
wildcards 400. module and body text are NOT indexed — use the SQL prefix
for module scope, read_document_parts for body.
SQL prefix. A query starting with SQL:( runs native SQL for
patterns Lucene can't express. Escape ' as '' (no bind params).
C_DESCRIPTION LIKE does NOT match; LIKE is rejected inside
EXISTS — keep it top-level via INNER JOIN. Before writing any SQL
call get_sql_query_recipes and adapt a recipe — it holds the common
patterns (document scope, custom-field, traceability); do not hand-write.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| project_id | Yes | Polarion project ID. | |
| query | No | Optional Lucene filter (e.g. 'type:requirement', 'title:SRS*') OR a 'SQL:(...)' prefix for native SQL. | |
| page_size | No | ||
| page_number | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| items | Yes | ||
| total_count | Yes | ||
| page | Yes | ||
| page_size | Yes | ||
| has_more | No |