Why did you create a database view between task and journal table? The sys_journal_field table already has that relationship and it includes the 'created by', so you also have the user.
Although your requirement is something you should put your question marks to and maybe even try to move them away from it (micro managing much?) you could create a data base view between the sys_user_grmember table and the sys_journal_field table, so you can also see it by group.
If someone really wants to know how often I place a comment, I think I would be looking for a different job, because it really sounds like a huge lack of trust. Did they tell you the 'why' of this requirement?
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
