Forums
Tech Note: Filtering employee reports to specific roles or groups
Technology Forum
Tech Note: Filtering employee reports to specific roles or groups
Discuss how to choose system that will yield the best results, as well as how to maintain it, and how to calculate its return on investment.
Employee reports (e.g. Employee Hours, etc.) do not have a built-in filter for limiting the employee records returned to specific roles (permission levels) or reporting groups. But you can do this eas
0
Cat:Topic ForumsForum:ForumId57
Cat:Topic ForumsForum:ForumId57Discussion:DiscussionId37055
Forums » Topic Forums » Technology Forum » Tech Note: Filtering employee reports to specific roles or groups
Forums
»
Topic Forums
»
Technology Forum
»
Tech Note: Filtering employee reports to specific roles or groups
|
Tech Note: Filtering employee reports to specific roles or groups
posted at 7/12/2011 4:36 AM EDT
|
Posts: 10
First: 3/24/2010 Last: 7/12/2011 |
Employee reports (e.g. Employee Hours, etc.) do not have a built-in filter for limiting the employee records returned to specific roles (permission levels) or reporting groups. But you can do this easily by creating a custom filter using SQL. To limit employee records to a particular named role you can use something like the following SQL custom filter:
t_user.roleid IN (select id from t_role where name='Employee') To limit employee records to a particular named reporting group you would use something like the following SQL custom filter: t_user.groupid IN (select id from t_group where name in ('Group 001','Group 002')) To exclude a role or group you would use NOT IN instead of IN in the above expressions. You don't have to be a SQL guru to use custom filters, but it helps to know the basics. An excellent source for information can found at W3 Schools. Jason Trend Pacific Timesheet http://www.pacifictimesheet.com |
Forums » Topic Forums » Technology Forum » Tech Note: Filtering employee reports to specific roles or groups
