How to add Team filter on dashboard’s gadgets.

By | April 29, 2020

In our previous blog we explained how to add user filter on dashboard gadgets. In this blog we will see how to add teams filter. The steps to add team filter are same as that to add user filter, only few changes in views needs to be done.

New Stuff: Sage CRM 2020 R1: Extended support for Nested Mail Merge – Part 2

We will consider same example as previous blog that is, we want to add opportunity list gadget along with team filter on dashboard. To do this follow below steps:

1) Add dummy field to opportunity entity “oppo_assignedteamID” of text type. Refer below:

Field creation
Field creation

2) Now create view in opportunity entity as below:

select comp_name,Oppo_Description ,oppo_status,Oppo_CreatedDate,
concat(Chan_Description ,'') as oppo_assignedteamID
 from opportunity
left join company 
on Oppo_PrimaryCompanyId = Comp_CompanyId
left join channel on Oppo_ChannelId   = Chan_ChannelId   
where comp_deleted is null and oppo_deleted is null and Chan_Deleted is null

3) Create a view naming vOpportunityTeamDetails , translation as Opportunity Team Details and check the report checkbox as shown below:

View creation
View creation

4) Now using this view create a report “Opportunity List”. If you don’t know how to configure reports in Sage CRM refer blog: Generating simple reports in Sage CRM

5) Now add gadget using this report on dashboard.
6) Assigned Team filter is now added to dashboard gadget, refer below:


You can also refer to our blog related to How to add Assigned User filter on dashboard’s gadgets.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.

Greytrix helps in upgrading Sage ERP and CRM to the latest version and provides migration for Sage Intacct from Sage 300, Sage 100, Sage 50 and QuickBooks; for Sage 100, Sage 300 (Sage Accpac), Sage X3 from Sage Pro, Sage 50 US, Sage 50 CA, Sage 50 US, Sage Business Works, Sage Business Vision and QuickBooks; for Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer

For more information on Sage ERP – CRM migration solutions, please contact us at We will like to hear from you.