How to filter activities stream

[wakespirit]

Dear all,

I have create a table name myActivity which inherit from TASK table.
I have define in this table 2 journal input field name Communication and Decision.
Then I have define a form design where I show on it the Communication and Decision field in which user can introduce information based on the type of information to refer.

Then I have added an activity formatter which allows me to filter the type of journal I want to see in the stream.

So far so good.

Now my next step is that the type of information describe above can be filter by department.

What I mean is that if I have department IT, HR, SALES, they can have the same journal type Communication and Decision but then I would like to be able to filter only the stream of journal belonging to HR or SALES or IT.

What should I do in order to offer this possibility, do I need to have an external table named DEPT which is linked to myActivity table or is there an other way to do ? 

Thanks for your advise

[rahulpandey]

Hi,

You can create an ACL to limit the visibility of Journals and it will be effective for filters as well. This would be similar to Worknotes/Comments implementation in task.

[wakespirit]

I think you did not understand what I mean.

What I mean is that HR or SALES OR IT can post some information as well.

I do no want to refuse access to certain department, all what I need is to filter the activity stream by Information type and DEPARTMENT

how to do, do I need to have a new table linked to Activity with Department ID in myActivity table ?