p6_query_activities
Search Primavera P6 activities by project, status, dates, WBS name, or activity code, with paging and selected fields to analyze schedule progress.
Instructions
Search activities, one page: {total, offset, returned, next_offset, rows}, ordered by start (actual, else early) then Activity ID. status: TK_NotStart, TK_Active or TK_Complete. Dates as YYYY-MM-DD (finish_before includes that day). wbs_name_contains matches the name of the activity's own WBS node only, not its parents: for a whole branch use p6_list_wbs, or an activity code filter. Durations and float in days of each activity's calendar. code_type (activity code type name, e.g. 'Discipline'; the project's own type wins over an EPS or global one) keeps activities with a code of that type; code_value narrows it to a code by path ('CON.MEC'), short name ('MEC': every match) or name, with its child codes unless include_child_codes=False; code_filter tells what was matched. fields= keeps task_code plus the fields named, e.g. ['task_name', 'early_start_date', 'early_end_date', 'total_float_d'], for smaller pages.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows per page (max 200). | |
| fields | No | ||
| offset | No | Rows to skip: pass next_offset from the previous page. | |
| status | No | ||
| project | Yes | Project ID as shown in P6 (p6_list_projects). | |
| code_type | No | ||
| code_value | No | ||
| code_prefix | No | ||
| start_after | No | ||
| finish_before | No | ||
| name_contains | No | ||
| wbs_name_contains | No | ||
| include_child_codes | No | ||
| max_total_float_days | No |