Retrieving Data from other Module through Relate Field

[cedcas]

Hello Everyone,

There has been a lot of posts and solutions that I've read in regards of this subject but can't quite find the one specific to my scenario. I would like to apologize ahead of time if this has been resolved in the past and would appreciate pointing me in the right directions.

I have a need to retrieve data from MODULE B going to MODULE A (both custom modules. Here is my code snippet from EDITVIEWDEFS.php of MODULE A:

          array (
            'name' => 'field_a',
              'studio' => 'visible',
              'label' => 'LBL_FIELD_A',
              'validateDependency'=>false,         
            'displayParams' => 
               array (
              'field_to_name_array' => 
                  array (
                   'name' => 'field_a',
                   'from_field_b' => 'field_b',
                   'from_field_c' => 'field_c',
                   'from_field_d' => 'field_d',
                   'from_field_e' => 'field_e',
                   'from_field_f' => 'field_f',
                   'from_field_g' => 'field_g',
                        ),
                     ),
                ),

The code above does what its suppose to do in terms of retrieving values from MODULE B but here is what's happening post-retrieved:

• FIELD A along with the rest of the fields are getting populated
• But during the save process, everything gets saved except for FIELD A (the value reverts to the old value or if its a new record it just gets saved as blank)

Any directions will be much appreciated.

Thanks,

Cedric

[eitrix]

'name' => 'field_a',

are you sure this is ok? Did you try

'field_a' => 'name' // or some other field

[cedcas]

Hello Eitrix,

Yes, that is the correct field name. Actually, without the displayParams array (and down), the RELATE field works perfectly. I did try to play around with the fields in terms of changing them around but no cigar. I think the issue lies somewhere in passing values through variables and somehow it doesn't get to the SQL update at all.

Cedric

[eitrix]

if this is relate field, did you forget to fill up the id that comes with relate field ?

[cedcas]

Thanks Eitrix,

That was actually the solution, which was:

          array (
            'name' => 'field_a',
              'studio' => 'visible',
              'label' => 'LBL_FIELD_A',
              'validateDependency'=>false,         
            'displayParams' => 
               array (
              'field_to_name_array' => 
                  array (
                   'id' => 'field_a_id_c',
                   'from_field_b' => 'field_b',
                   'from_field_c' => 'field_c',
                   'from_field_d' => 'field_d',
                   'from_field_e' => 'field_e',
                   'from_field_f' => 'field_f',
                   'from_field_g' => 'field_g',
                        ),
                     ),
                ),

Thanks again!

[kshaw661]

When i am fetch the data from relate module then some values are come and some are not.
I cant understand why please help me.
my code is
array (
'name' => 'reporting_to_manager_c',
'studio' => 'visible',
'label' => 'LBL_REPORTING_TO_MANAGER',
'displayParams' =>
array (
'field_to_name_array' =>
array (
'id' => 'a1234_managers_id_c',
'name' => 'reporting_to_manager_c',
'designation_c' => 'manager_des_c',
'phone_mobile' => 'mobileno_c',
'manager_code_c' => 'managercode_c',
'alt_number_c' => 'alt_no_c',
),
),

Here the designation_c and
alt_number_c is not comming
why
plese help me
as soon as possible
Thank you
Kunal