User Filter based on Custom field in Sage CRM

By | August 26, 2021

In Sage CRM, dashboard gadgets help us to summarized data from different entities in one place and we can assign a gadget template on the basis of reports. Recently one of our clients came up with a requirement to filter the gadget that should display data on basis of the logged-in user set in the custom user field.

New Stuff: Sage CRM 2021 R2: UX improvements – Configuration of Quote/Order merge document names

We have created a gadget against the Opportunity entity without checking a ‘Filter by Current User’ checkbox. So it shows all users on a gadget based on the ‘Assigned To’ field.

Gadget With No Filter
Gadget With No Filter

After that, we have checked the ‘Filter by Current User’ checkbox in a report and save the report. As per standard functionality, it shows the logged in user is filtered into the gadget on basis of the ‘Assigned To’ field.

Gadget With Assigned To Filter
Gadget With Assigned To Filter


But, as per the Client’s requirement gadget should filter on basis of the custom user field on Opportunity i.e. Manager Field.  So we have proposed the below solution,

Follow below steps for the same,
1) Copy and paste below lines of code in Microsoft SQL Server Management Studio to check Assigned Userid.

select bord_AssignedUserId,* from custom_tables
where bord_caption in ('opportunity','company')
Select SQL
Select SQL

2) So we have update the bord_AssignedUserId column.
Copy and paste below lines of code to update the custom table to display current user.

update custom_tables
set bord_AssignedUserId = 'oppo_manager'
where Bord_TableId = 10
Update SQL
Update SQL

3) Resave the report and check the gadget. Here we can see the gadget were filtered on the basis of the custom user field i.e. Manager

Gadget With Custom Field Filter
Gadget With Custom Field Filter

Note:  To reflect the changes, it is mandatory to give metadata and resave the report on which gadget is created. This filter functionality will apply to all the reports of the opportunity entity where this custom user field is used.

By following the above steps users can filter gadgets using custom fields.

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 and expertise, 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 has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500 and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service Signature and Sage CRM CTI Framework. Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.

Also Read:

  1. How to add Team filter on dashboard’s gadgets.
  2. Data Resource unavailable for Gadgets of Custom Entity
  3. Build Interactive Dashboard Gadgets using Saved Searches in Sage CRM