You can actually navigate to the Filters module and delete filters. If you go to your instance and set the module to Filters in the URL (see below) you can sort and mass delete filters there. Sugar does not have any navigation to get to this module directly or to adjust the layout without code.
http://docker.local/sugar/#Filters
vs http://docker.local/sugar/#Accounts
You can access Advanced Reports by going to Reports->Advanced Reports->View Custom Queries.
Or navigate to /#bwc/index.php?module=CustomQueries&action=index&return_module=CustomQueries&return_action=DetailView
As you've probably seen before just replace with the URL of your instance ie https://instance.sugarondemand.com/
Create a query and paste the below query in the Query Field. This should give you a list of the filters shared. I added the creator, who it was shared with, the filter name, and date.
SELECT f.name AS 'filter_name'
, f.module_name as 'filter_module'
, CONCAT(u1.first_name, ' ', u1.last_name) AS 'filter_creator'
, CONCAT(u2.first_name, ' ', u2.last_name) AS 'filter_owner'
, fo.description AS 'original_filter_id'
, fo.date_entered AS 'filter_create_date'
FROM filters f
JOIN users u1 ON f.created_by = u1.id AND u1.deleted = 0 AND f.deleted = 0
JOIN filters fo ON fo.description = f.id
JOIN users u2 ON fo.created_by = u2.id
ORDER BY fo.description, fo.date_entered ASC
I hope all is well with you. Are you talking about Filters shared by using the little '+' icon on the filter itself. Meaning more user shares rather than Admin pushed?
Based on your question I am guessing this is the case. There isn't a direct way for Filter Deployer to show this information because we do not store any separate records when the Filters are shared. However, I believe there is a way to get the information. The information you are looking for is on the filters table.
In particular with the fields [id, created_by, description] we can derive the information you want. Do you have access to the database either being self hosted or via Advanced Reports (Meaning you are on Sell or Enterprise?)
If so let me know if you'd like some help writing the query to get the information you'd like. Thanks a lot and take care.
Sounds good Vincent. If you start any trials again just email me and I'll send over a modified version you can use that won't update the date_modifed/ modified by.
Yes that is possible. In the short term if you like I can just modify an installable package to do just that. I think would be a nice configuration feature but I won't have time to implement that for the next few weeks.
if you are interested please just start a trial and let me know at shad@jackalsoftware.com and I'll send you over a modified version you can install.
Hello Vincent and thank you for your question. In the end the job simply saves the record using the bean save functionality. So to answer your question at this time it will update the date modfied and modified by.
This is a good point though and having that as a configuration option is a good idea. Are you saying for the use case you have you'd prefer to not have those fields updated?
Hello,
Thank you for your trial of the Background Updater and sorry you are having issues. Sorry but I do not see the image with the error you mentioned.
Can you please attach it here or send it to shad@jackalsoftware.com please? Also would you please forward the Sugarlog by going to Admin->Diagnostic Tools and selecting sugarcrm.log. After running you will be directed to download a diagnostic file. If you could forward that as well I'd appreciate it very much.
Are these Dashlets that are already deployed? If so the only way I can think to accomplish this is to switch the filter on the Dashlet to the new one. Of course this pretty much negates the purpose of the plugin.
Another option may be the Dashboard Manager plugin I make. It will copy the Dashlets in the Dashboards along with the filters.
Hello Muhammad. I think you have the idea. However, if I’m not mistaken in your example it would be the USD field converted to 50.
This is for the stock fields. I find organizations often create their own conversion fields with their own business logic. Not updating once an Opportunity is closed for example.
Thanks again for your interest and I’d be happy to answer any other questions.
There is no impact from historical exchange rates on reports. However, as exchange rates are updated and records get re-saved with the new exchange rate the base rate conversion fields (stock or custom) will change with the new exchange rate. This update can impact reports but should reflect more accurate data.
The plugin does not automatically conversion fields. Another process would need to handle those updates.