Follow

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)

OR

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.

Description:Code

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:

Contains

:

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

<=

Contains

:

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

<=

Contains

:

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

Examples

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

Comments