Search

The search looks up full words in Tasknames (name) and Taskdescriptions (description) without giving special search commands in the search string. The search will result in a tasklist.

Task search fields

• task_id (NUMERIC):
• assigned_user (TEXT):
• assigned_user_missing (BOOLEAN):
• name (TEXT):
• description (TEXT):
• state (TEXT):
  • The state of a Task. It is one of the following states: Open, Finished, Closed, Cancelled
• targetdate (DATETIME):

Project related fields

• project_id (NUMERIC):
• project_name (TEXT):
• project_description (TEXT):

Comment related field

• comment (TEXT):

Search syntax (Whoosh)

Logic operators

• AND
  • Example: "foo AND bar" - Search will find all items with foo and bar.
• OR
  • Example: "foo OR bar" - Search will find all items with foo, bar or with foo and bar.
• NOT
  • Example: "foo NOT bar" - Search will find all items with foo and no bar.

Search in specific fields

A search pattern like foo:bar does look for bar in the field named foo.

This search pattern can also be combined with other search text via logical operators.

Search for specific content

• Wildcards:
• Range:
  • From To:
  • Above:
  • Below:
• Named constants:
  • now: Current date
  • -[num]y: Current date minus [num] years
  • +[num]mo: Current date plus [num] months
  • -[num]d: Current date minus [num] days
  • ...

Examples

• project_id:1 gives results with all tasks of project number #1.
• project_id:1 AND assigned_user:dirk gives results with all tasks of project number #1 which are assigned to 'dirk'.
• assigned_user:dirk AND targetdate:[2000 to +5d] gives results with tasks having a targetdate within the next 5 days and assigned to 'dirk'.