AnsweredAssumed Answered

How to add/set custom fields in QLI on quotes in Sugar 7.9.2?

Question asked by Usman Saeed on Oct 23, 2017
Latest reply on Jan 15, 2018 by Conrad Hodge

Like • Show 0 Likes0
Comment • 3

Hi All,
On Quotes when adding QLI, we need to add a custom field total_units_c that will be fetched from ProductCataloge and can be editable by user.

Please note that, total_units_c is in Products (QLI) and same name in ProductCataloge as well.

I am able to add the custom field but its value is not fetched from Productcatalog.

I followed the article http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.9/Architecture/Quotes/

But it did not help for custom fields.
Can anybody know where we need to add the custom field that it will fetch from ProductCatalog.

Any help is really appreciated.

Regards,

Usman

Francesca Shiekh Oct 25, 2017 6:24 AM

Correct Answer

To populate the value from the catalog, add the field to the populate_list in your vardef extensions:

custom/Extension/modules/Products/Ext/Vardefs/your_extension_file.php (path corrected per Usman Saeed, Thank you for catching that!)

$dictionary['Product']['fields']['product_template_name']['populate_list']['total_units_c'] = 'total_units_c';

HTH,

FrancescaS

See the reply in context

No one else had this question

Outcomes

Francesca Shiekh Oct 25, 2017 6:24 AM

To populate the value from the catalog, add the field to the populate_list in your vardef extensions:

custom/Extension/modules/Products/Ext/Vardefs/your_extension_file.php (path corrected per Usman Saeed, Thank you for catching that!)

$dictionary['Product']['fields']['product_template_name']['populate_list']['total_units_c'] = 'total_units_c';

HTH,

FrancescaS

1 person found this helpful

Actions

Usman Saeed @ Francesca Shiekh on Oct 25, 2017 1:06 AM

Hi Francesca Shiekh. Thank you for the guidance and help. It worked.

1 small change, I added file in extension dir, at the path custom/Extension/modules/Products/Ext/Vardefs/

Regards,

Usman

Actions

Conrad Hodge Jan 15, 2018 3:50 AM

I tried to do a similar thing by defining the following populate_list:

$dictionary['Product']['fields']['product_template_name']['populate_list']['partner_type_c'] = 'partner_subsidiary_c';
$dictionary['Product']['fields']['product_template_name']['populate_list']['emis_servia41deements_ida'] = 'emis_servi902aeements_ida';
$dictionary['Product']['fields']['product_template_name']['populate_list']['emis_servicelevelagreements_producttemplates_1_name'] = 'emis_servicelevelagreements_products_1_name';

This is defined in the `custom/Extension/modules/Products/Ext/Vardefs/sugarfield_product_template_name.php` file .

The problem is I then get these errors in the browser console:

ERROR[2017-12-28 17:22:15]: Fail to populate the related attributes: attempt to access undefined key - ProductTemplates::partner_type_c
ERROR[2017-12-28 17:22:15]: Fail to populate the related attributes: attempt to access undefined key - ProductTemplates::emis_servia41deements_ida
ERROR[2017-12-28 17:22:15]: Fail to populate the related attributes: attempt to access undefined key - ProductTemplates::emis_servicelevelagreements_producttemplates_1_name

After some debugging I found that this seems to be caused by the field type (`quote-data-relate`) used for the `product_template_name` field in the `custom/modules/Products/clients/base/views/quote-data-group-list/quote-data-group-list.php` file.

If you take a look at the `modules/Products/clients/base/fields/quote-data-relate/quote-data-relate.js` file, the `_getPopulateMetadata` function has been overridden to return the metadata for the Products module. This causes the error in the `initialize` function in the `clients/base/fields/relate/relate.js` file. I commented out the overridden function and it works - so no idea why is was overridden.

Did anyone else have this problem?

Actions

3 Replies

Francesca Shiekh Oct 25, 2017 6:24 AM
Unmark Correct
Correct Answer
To populate the value from the catalog, add the field to the populate_list in your vardef extensions:
custom/Extension/modules/Products/Ext/Vardefs/your_extension_file.php (path corrected per Usman Saeed, Thank you for catching that!)

$dictionary['Product']['fields']['product_template_name']['populate_list']['total_units_c'] = 'total_units_c';

HTH,
FrancescaS
1 person found this helpful
Like • Show 1 Like1
Actions
- Usman Saeed @ Francesca Shiekh on Oct 25, 2017 1:06 AM
  Mark Correct
  Correct Answer
  Hi Francesca Shiekh. Thank you for the guidance and help. It worked.
  1 small change, I added file in extension dir, at the path custom/Extension/modules/Products/Ext/Vardefs/
  
  Regards,
  Usman
  Like • Show 0 Likes0
  Actions
Conrad Hodge Jan 15, 2018 3:50 AM
Mark Correct
Correct Answer
I tried to do a similar thing by defining the following populate_list:
```
$dictionary['Product']['fields']['product_template_name']['populate_list']['partner_type_c'] = 'partner_subsidiary_c';
$dictionary['Product']['fields']['product_template_name']['populate_list']['emis_servia41deements_ida'] = 'emis_servi902aeements_ida';
$dictionary['Product']['fields']['product_template_name']['populate_list']['emis_servicelevelagreements_producttemplates_1_name'] = 'emis_servicelevelagreements_products_1_name';
```
This is defined in the `custom/Extension/modules/Products/Ext/Vardefs/sugarfield_product_template_name.php` file .

The problem is I then get these errors in the browser console:

ERROR[2017-12-28 17:22:15]: Fail to populate the related attributes: attempt to access undefined key - ProductTemplates::partner_type_c
ERROR[2017-12-28 17:22:15]: Fail to populate the related attributes: attempt to access undefined key - ProductTemplates::emis_servia41deements_ida
ERROR[2017-12-28 17:22:15]: Fail to populate the related attributes: attempt to access undefined key - ProductTemplates::emis_servicelevelagreements_producttemplates_1_name

After some debugging I found that this seems to be caused by the field type (`quote-data-relate`) used for the `product_template_name` field in the `custom/modules/Products/clients/base/views/quote-data-group-list/quote-data-group-list.php` file.

If you take a look at the `modules/Products/clients/base/fields/quote-data-relate/quote-data-relate.js` file, the `_getPopulateMetadata` function has been overridden to return the metadata for the Products module. This causes the error in the `initialize` function in the `clients/base/fields/relate/relate.js` file. I commented out the overridden function and it works - so no idea why is was overridden.

Did anyone else have this problem?
Like • Show 0 Likes0
Actions

How to add/set custom fields in QLI on quotes in Sugar 7.9.2?

Outcomes

Related Content

Recommended Content