Looking to submit a support request? We are now a Perforce company, please submit any requests on our new support page.

The Find query language

Hansoft has an extensive language for writing queries. This way of writing queries is available everywhere you can find items, tasks, bugs or other things in Hansoft.

In the report tool you can model your queries in a visual query builder.

Find query language format

Parenthesis ()

(Programmers OR Artists) AND (BugStatus ="New" OR BugStatus ="Assigned")

AND (alternatively +).

(BugStatus = "New" AND WorkRemaining >= 5)


BugStatus ="New" OR BugStatus = "Assigned"

NOT (alternatively !)

NOT BugStatus = "Verified"

- (a combination of AND and NOT)

BugStatus = "New" AND NOT WorkRemaining >= 5

BugStatus = "New" -WorkRemaining >= 5

Finding data in a column

If you write the name of a column before the keyword separated with an operator (such as : which means contains) you can find data only confined within that column.


BugStatus = "New"

Operators and syntax

An operator is written between a column and a keyword. A common operator is : which means contains, for example description:code (result will be all items with a description which contains the keyword code).

Text columns

When finding data in a text column (such as Description), these are the most important operators:



Starts with


Exactly matches


Description:Code means all items that contains the text Code.

User columns

When finding data in a user column (such as Users or CC new comments to), these are the most important operators:

Any of selected


None of selected


All of selected, no other


At least all of selected


users:"Example Team User" means an item where one of the assigned users are Example Team User.

Date columns

When finding data in a date column (such as Start, Finish, a custom date column, last commented on or last updated on), these are the most important operators:

On date


After date


Before date


On or after date


On or before date




start >= 2009-10-01 means start is on or after the October 1st 2009.

Please note that dates has to be written in standard ISO 8601 standard format YYYY-MM-DD. This is because queries written in plain text should not be dependent on local date formatting settings.

Other columns

Finding data in any other column (such as numeric column Work Remaining), at least these operators are available:

Equals to


Greater than


Less than


Greater than equal


Less than equal




Example: workremaining >= 15 means work remaining on agile items are greater than or equal to 15 hours.

Special keywords

mywork and assignedtome gives all work assigned to the logged in user using the keyword

weekX (for example week15 week17) find items that are scheduled during those weeks

fromdatetodate(2008-01-01, 2010-01-01) find dates in the specified range in all columns were it can be applied. Can be combined with now formatting, fromdatetodate(now-15d, now+25d).

Assignedto:Resource("Programmers") finds all items where any column has a member of the user group as value

projects (only in Portfolio find and the To do list, for example "Product Alpha") finds all items within the specified project


In a scheduling project

(Start >= 2009-03-02 AND Start <= 2009-03-31) AND (Itemname: code OR Itemname: art)

In a agile project

(Itemstatus= "Not done" OR Itemstatus= "In progress") AND (Workremaining >= 1 AND Workremaining <= 10)

In a quality assurance project

(Bugstatus= Assigned OR Bugstatus= New OR Bugstatus= "Re-open") AND (Severity= "Severity A" OR Severity= "Severity B")

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request