Tuesday, January 19, 2010

How to lookup the task with specific words in the synopsis

Hi,

as you know, tasks in Synergy have a short description called "task_synopsis" and the long one, called "task_description". To locate a task with specific words in either of the fields you may run the following query (note the release name is put there to shorten the search only, you may use any other known attribute, like owner, to limit the search).

This is how the query command should look in the CLI session:

ccm query -type task "release='<task release>' and task_synopsis match 'word to search for *' "

e.g.

ccm query -type task "release='MYRelease' and task_synopsis match 'cleanup*'"

In the Query dialog there is no need to include outer double quotes:

In the Custom criteria just type the actual query criteria:

e.g.

release='MyRelease' and task_synopsis match 'cleanup*'

Please note the quotes, they are important.

Sunday, January 17, 2010

Monday, January 11, 2010

How to find if an object is associated with a task and if so - what is it's check out status?

ccm query "name=<file name> and is_associated_object_of('task<task ID>#1:task:probtrac')" -u -f %status
If an object is associated with this specific task, the output will contain its status (working for checked out files, integrate - for checked in), if the file is not associated with this task, output will present an empty new line.
example:
>ccm query "name='strings.xml' and is_associated_object_of('task180795#1:task:probtrac')" -u -f %status
>integrate