country name in advanced query

The name of the country is defined in the dropdown which is in the metadata, on the file system, not in the database.

This means that you can't get the full name of the country from a query.

 Chris Raffle 's suggestion works well, though you have to introduce the case statement in every advanced report that uses the country.

An alternative would be to create a custom calculated field on Account and populate that with the full country name. Then use that field in your query for the report output.

There is an article in the Sugar Knowledge Base that explains how to copy the value of a dropdown in a calculated field.

https://support.sugarcrm.com/knowledge_base/studio_and_module_builder/sugar_logic/calculated_field__copying_dropdown_value_to_a_text_field/

You would need to recalculate all your Accounts (you can do so from the list view's action menu) to make sure the value is inserted in the formula field:
 https://support.sugarcrm.com/knowledge_base/studio_and_module_builder/sugar_logic/introduction_to_calculated_fields/#Automatically_Updating_Calculated_Values

FrancescaS

The name of the country is defined in the dropdown which is in the metadata, on the file system, not in the database.

This means that you can't get the full name of the country from a query.

 Chris Raffle 's suggestion works well, though you have to introduce the case statement in every advanced report that uses the country.

An alternative would be to create a custom calculated field on Account and populate that with the full country name. Then use that field in your query for the report output.

There is an article in the Sugar Knowledge Base that explains how to copy the value of a dropdown in a calculated field.

https://support.sugarcrm.com/knowledge_base/studio_and_module_builder/sugar_logic/calculated_field__copying_dropdown_value_to_a_text_field/

You would need to recalculate all your Accounts (you can do so from the list view's action menu) to make sure the value is inserted in the formula field:
 https://support.sugarcrm.com/knowledge_base/studio_and_module_builder/sugar_logic/introduction_to_calculated_fields/#Automatically_Updating_Calculated_Values

FrancescaS