Hi guys,
We are looking for some help / share of knowledge about the Visibility Framework, and more particularly the definition of the elasticsearch filter.
We coded a visibility query using the following article : https://support.sugarcrm.com/documentation/sugar_developer/sugar_developer_guide_14.0/architecture/teams/custom_record_visibility/#Visibility_Class.
Our business case is to restrict the visibility of cases to only assigned cases (easy part) ; then, according to those cases, the user can only see the records linked to those case. For instance, only the accounts that are linked to a case they are assigned to. Or only the tasks, meetings, calls etc. linked to the case they are assigned to.
The SQL filter definition to restrict the record visibilty in Sugar is OK.
But now we are more struggling about the way to define the same filter for elasticsearch ; for example, how to code the filter : display only the tasks that are linked to an open case that is assigned to the current user.
Any help / tips / tricks / code is welcome.
Best regards,
Fred