Is it possible to create dashlet filter by many to many relationship?
Example:
Tasks have many to many relationship on Security Groups.
I would like to show in Tasks dashlet records that have relation to specific SecurityGroup.
Currently, I don’t believe SuiteCRM or Security Groups supports this type of dashlet integration as yet. Jason Eggers and the Security Suite team may have more information on this and may be able to confirm/expand on my statement.
Thanks for the reply.
It is not necessary to be Security Group, that was just an example. My focus is on many to many relationship.
To be more specific I have custom module, in which I created additional many to many relationship on Users, and I would like to show record in dashlet if current user has relationship to the record.
I have managed to do it by overriding process function in dashlet class and adding custom SQL in ‘$lvsParams’ variable.
However it would be nice to have some easier way to do it, e.g. for one-to-many relationship it is possible to just add relationship name to ‘search fields’ in /Dashlets/MyDashlet/MyDashlet.data.php, or /metadata/dashletviewdefs.php .