ProjectPipe Help Center

How do I create custom queries?

While viewing a table or outline, click "query" in the command bar to go to the query builder.

In the "Define Search Criteria" section, you specify values to look for. All searches are case insensitive.

Search Type	Example	Description
Simple	name: Run	Search for "run" (as always case insensitively) anywhere in name field.
Wildcard	name: Run%Home	Search name field for "run" followed by any number of characters followed by "home".
Multiple Fields	name: Run description: Complexity	Search name field for "run" AND description field for "complexity". When multiple fields given then ALL fields must match.
Multiple Values	status: New, Open, not Assigned, not Fixed	Search for status field completely matching "new" OR "open" AND status field not matching "assigned" AND status field not matching "fixed". Multiple values are separated by comma and the entire field must match any one of the values and must not match any of the negative values. In this example, "new" would match but "renew" would not match. Wildcards are not allowed.
Negative	name: not Run	Search for items where "run" is nowhere in the name field. You can also use wildcards in this negative search.

Searching Tags field:
- Searches must match the entire field -- e.g., searching for "tag: Complex" finds items tagged with "complex" but not "complexity".
- Negative searches are supported -- e.g., searching for "tag: not Complex" finds all items not tagged with "complex".
- Multiple values and wildcards are not supported.
Searching Linksin and Linksout:
- The value is matched against the name field of the linked object -- e.g., searching for "linksout: Car" finds items that have links out to items with "car" anywhere in the name field.
- Wildcard and negative searches are supported -- e.g., searching for "linksout: not Car%Runs" finds items that do NOT have links out to items with the pattern "car%runs" anywhere in the name field.
- Multiple values are not supported.