Filter contitions OR relation

Discuss problems installing or using TrackStudio.

Filter contitions OR relation

Postby tsman » Sat Nov 10, 2012 2:20 am

Dear Support!

In my company/department I am responsible for Trackstudio customization.Now I am looking for a complex filter solution.

We use "BugTicket" and "DevTask" and "SupQuestion" categories all of them have their own workflow, armed with the "USER" type custom field : "involved people"

I'd like to do filter which:
1. list all BugTicket and DevTask and Sup Question ;
2. Iam the ASSIGNEE of the task OR I am in the "involved people" user list. ; <--- here is what Iam looking for
3. where task are in running status

I would be very convenient for everyone to see hher/his own task in one filter.

Any other solution would be appreciated.


thanks in advance
tsman
 
Posts: 11
Joined: Thu Nov 25, 2010 2:19 am

Re: Filter contitions OR relation

Postby Petr » Sat Nov 10, 2012 10:01 am

Hello.
Well It is a real basic task. You need to create a calculated UDF, which checks this condition.

You can use a script like this.
Code: Select all
return sc.getUserId().equals(task.getHandlerUserId()) || ((List) task,getUdfVallue("your_name_of_udf")).contain(task,getHandlerUserId()) ? 1 : 0;

So far you should set this condition on your filter.
Стань Java программистом с www.job4j.ru
Petr
 
Posts: 2929
Joined: Wed Aug 12, 2009 4:38 pm

Re: Filter contitions OR relation

Postby tsman » Sat Nov 10, 2012 3:21 pm

Hello Petr !

Just to clarify my question I attached the filter photo.
Involved people is already a calculated value, contains all the previous assignees

REQUIRED LOGIC:
Category in set[BUG,DEVTASK,SUPPORTQUESTION] AND
State in set [.../ongoing] AND
(Assignee in set [--Me--] OR
involved People(wfBUG) in set [--Me--] OR
involved People(wfDEV) in set [--Me--] OR
involved People(wfSUP) in set [--Me--] OR
)

Is the calculated UDF is still a solution ?
Attachments
filter_condition_relation_p1.jpg
filter_condition_relation_p1.jpg (134.08 KiB) Viewed 20359 times
tsman
 
Posts: 11
Joined: Thu Nov 25, 2010 2:19 am

Re: Filter contitions OR relation

Postby Petr » Sat Nov 10, 2012 4:43 pm

Yes It is. You should use a calculated field. I understand that it degrades a system performance but we can not solve this task another way. Right now we don't have a full implementation of Boolean logic like OR XOR.
Стань Java программистом с www.job4j.ru
Petr
 
Posts: 2929
Joined: Wed Aug 12, 2009 4:38 pm

Re: Filter contitions OR relation

Postby tsman » Mon Nov 12, 2012 2:37 pm

well, I cant find any posibility in the filter options where I could define UDF.

UDF, can be defined at WORKFLOW level and for certain TASKS/TASK NUMBER level. At these levels the calculated field cant join UDF values from different task, only the task and its childs and so on.

Am I rigth, or still misunderstanding . Which one sholud I use?
Attachments
CREATE_WF_LEVEL_UDF.jpg
works for certain WORKFLOW types only
CREATE_WF_LEVEL_UDF.jpg (43.12 KiB) Viewed 20353 times
CREATE_TASK_LEVEL_UDF.jpg
good for only one task ??
CREATE_TASK_LEVEL_UDF.jpg (47.95 KiB) Viewed 20353 times
tsman
 
Posts: 11
Joined: Thu Nov 25, 2010 2:19 am

Re: Filter contitions OR relation

Postby Petr » Mon Nov 12, 2012 5:53 pm

I recommend you to use UDF which is defined to TASKS/TASK NUMBER.
Actually you misunderstood about how to use it.
Calculated UDFs can get data from all tasks. When you or filter views the task calculated UDFs calculate data for particular task.
Just try it. Don't worry if you can not understand how it works inside.
Стань Java программистом с www.job4j.ru
Petr
 
Posts: 2929
Joined: Wed Aug 12, 2009 4:38 pm

Re: Filter contitions OR relation

Postby tsman » Mon Nov 19, 2012 12:18 pm

Hello Pter !

I will try your solution, as soon as our Java programmer get in work again.

Till that, thanks for your supoort which is really helpful !!!
tsman
 
Posts: 11
Joined: Thu Nov 25, 2010 2:19 am


Return to TrackStudio Support

Who is online

Users browsing this forum: No registered users and 6 guests

cron