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.
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.
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')
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
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
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 Partners 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 X3, Sage Intacct, Sage 100, Sage 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 the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, 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 the 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: