Filter Pop-up based on relationship

You have to create a filter in Contacts module in custom/Extension/modules/Contacts/Ext/clients/base/filters/basic

$viewdefs['Contacts']['base']['filter']['basic']['filters'][] = array(
    'id' => 'filterContactsByAccountId',
    'name' => 'LBL_FILTER_CONTACTS_BY_ACCOUNT_ID',
    'filter_definition' => array(       
        array(
            'account_id' => ''
        )
    ),
    'editable' => true,
    'is_template' => true,
);

And then in record.php of module RTPOL_OLP in the field Contact you call the initial filter:

array (
    'name' => 'intermediary_contact_name',
    'label' => 'LBL_INTERMEDIARY_CONTACT_NAME',
	  //the name of the filter template
	'initial_filter' => 'filterContactsByAccountId',

	//the display label for users
	'initial_filter_label' => 'LBL_FILTER_CONTACTS_BY_ACCOUNT_ID',

	//the dynamic filters to pass to the templates filter definition
	//please note the index of the array will be for the field the data is being pulled from
	'filter_relate' => array(
		'intermediary_account_id' => 'account_id'
	),
  ),

I got this from a previous post but I didn't kept the link....

I hope this help....

I tried but this is not working. I created the filter exact as you have shown, then added the reference in the record.php like so

 array (
                'name' => 'contacts_rtpol_olp_1_name',
                'label' => 'LBL_CONTACTS_RTPOL_OLP_1_NAME_FIELD_TITLE',
                //the name of the filter template
                'initial_filter' => 'filterContactsByAccountId',

                //the display label for users
                'initial_filter_label' => 'LBL_FILTER_CONTACTS_BY_ACCOUNT_ID',

                //the dynamic filters to pass to the templates filter definition
                //please note the index of the array will be for the field the data is being pulled from
                'filter_relate' => array(
                  'accounts_rtpol_olp_1accounts_ida' => 'account_id'
                ),
              ),

I must still be missing something.

Also, here is the link you are looking for Sugar Developer Guide 13.1 - Sugar Support (sugarcrm.com).

Show the code of the relation between module  RTPOL_OLP and the module Accounts.

<?php
// created: 2023-09-12 08:21:18
$dictionary["accounts_rtpol_olp_1"] = array (
  'true_relationship_type' => 'one-to-many',
  'from_studio' => true,
  'relationships' => 
  array (
    'accounts_rtpol_olp_1' => 
    array (
      'lhs_module' => 'Accounts',
      'lhs_table' => 'accounts',
      'lhs_key' => 'id',
      'rhs_module' => 'RTPOL_OLP',
      'rhs_table' => 'rtpol_olp',
      'rhs_key' => 'id',
      'relationship_type' => 'many-to-many',
      'join_table' => 'accounts_rtpol_olp_1_c',
      'join_key_lhs' => 'accounts_rtpol_olp_1accounts_ida',
      'join_key_rhs' => 'accounts_rtpol_olp_1rtpol_olp_idb',
    ),
  ),
  'table' => 'accounts_rtpol_olp_1_c',
  'fields' => 
  array (
    'id' => 
    array (
      'name' => 'id',
      'type' => 'id',
    ),
    'date_modified' => 
    array (
      'name' => 'date_modified',
      'type' => 'datetime',
    ),
    'deleted' => 
    array (
      'name' => 'deleted',
      'type' => 'bool',
      'default' => 0,
    ),
    'accounts_rtpol_olp_1accounts_ida' => 
    array (
      'name' => 'accounts_rtpol_olp_1accounts_ida',
      'type' => 'id',
    ),
    'accounts_rtpol_olp_1rtpol_olp_idb' => 
    array (
      'name' => 'accounts_rtpol_olp_1rtpol_olp_idb',
      'type' => 'id',
    ),
  ),
  'indices' => 
  array (
    0 => 
    array (
      'name' => 'idx_accounts_rtpol_olp_1_pk',
      'type' => 'primary',
      'fields' => 
      array (
        0 => 'id',
      ),
    ),
    1 => 
    array (
      'name' => 'idx_accounts_rtpol_olp_1_ida1_deleted',
      'type' => 'index',
      'fields' => 
      array (
        0 => 'accounts_rtpol_olp_1accounts_ida',
        1 => 'deleted',
      ),
    ),
    2 => 
    array (
      'name' => 'idx_accounts_rtpol_olp_1_idb2_deleted',
      'type' => 'index',
      'fields' => 
      array (
        0 => 'accounts_rtpol_olp_1rtpol_olp_idb',
        1 => 'deleted',
      ),
    ),
    3 => 
    array (
      'name' => 'accounts_rtpol_olp_1_alt',
      'type' => 'alternate_key',
      'fields' => 
      array (
        0 => 'accounts_rtpol_olp_1rtpol_olp_idb',
      ),
    ),
  ),
);

Here you go.

take a look at this:

sugarclub.sugarcrm.com/.../29733

I am not sure why you referenced that link. My relationships are working fine, just none of my filters work. I have created three separate filters, 2 based on relationships and one just based on a field that might or might not be empty. None of those filters work at all.

Do you have "links" in both side of the relationship?

I think the problem is the value that you use on the filter relate. 

'filter_relate' => array(
    'accounts_rtpol_olp_1accounts_ida' => 'account_id'
),

In my code "'intermediary_account_id'" is a link created on the custom module side.

I suggested that post because for me it was fundamental to understand and create the links on both side of the modules.

'filter_relate' => array(
	'intermediary_account_id' => 'account_id'
),

Do you have "links" in both side of the relationship?

I think the problem is the value that you use on the filter relate. 

'filter_relate' => array(
    'accounts_rtpol_olp_1accounts_ida' => 'account_id'
),

In my code "'intermediary_account_id'" is a link created on the custom module side.

I suggested that post because for me it was fundamental to understand and create the links on both side of the modules.

'filter_relate' => array(
	'intermediary_account_id' => 'account_id'
),

Ok now the filter is popping up but the dynamic field is blank. I had to create a calculated field that is supposed to populated with the account_id.

Ok that Filter is working. Thank you. I had to create a calculated field with related($accounts_rtpol_olp_1,"id") as a formula.

nice!!!

So do you know how to use the operator $not_empty in a filter?

I never used that operator. If you are having difficulties using it I think is better to create another post with that subject.

Ok Thanks again