Sort List Layout by Custom Field

[colinake]

I've added a custom field in several places and in some cases added them to the list layout in their particular module. However, I can't sort the results by this field. Is there something I'm overlooking in studio that would allow me to do this? I can't find anything elsewhere on the forums or the wiki about this issue.

Let me know if I'm straight up missing something or if it takes wearing a special hat and holding your tongue a certain way.

Thanks

[colinake]

Does anyone have any insight into this? I've dug around a bit more but still can't find anything that would make these custom fields sortable.

Is the only way to do this messing with the PHP? And if we do that, wouldn't it be lost in the case of an upgrade?

Thanks in advance

[DragonflyMaster]

It's a thing you can do via php.
If you created a module via module builder, open <sugar-root>/custom/modules/<your_module>/metadata/listviewdefs.php
you'll see the list of all fields, locate yours and add the line 'sortable' => true, (comma included) as in the following example:

 'MY_FIELD_NAME' => 
    array (
      'width' => '10',
      'label' => 'LBL_MY_FIELD',
      'sortable' => true, 
      'default' => true,
    ), 
  

Since it's inside <sugar-root>/custom/modules/<your_module>/metadata/ you will not loose this mod when you update or change things via studio (unless you remove this field of course...)

[colinake]

Thanks, DragonFlyMaster. I really appreciate it. If I make this change inside a standard module (like Opportunities, in this case), I'm assuming it won't be in the custom folder and the changes will be lost when an upgrade is made?

Thanks once again

[DragonflyMaster]

Thanks, DragonFlyMaster. I really appreciate it. If I make this change inside a standard module (like Opportunities, in this case), I'm assuming it won't be in the custom folder and the changes will be lost when an upgrade is made?

Thanks once again

If you modify a standard module via Studio, you'll get a <module_name> folder in custom/modules/ containing the proper files for your customizations.
In your case, go to admin->studio->opportunities->layouts->listview and make some changes, then save and deploy. This will create the file <sugar-root>/custom/modules/Opportunities/metadata/listviewdefs.php. Open it, locate your custom field and add that line

 'sortable' => true, 
  

[colinake]

If you modify a standard module via Studio, you'll get a <module_name> folder in custom/modules/ containing the proper files for your customizations.
In your case, go to admin->studio->opportunities->layouts->listview and make some changes, then save and deploy. This will create the file <sugar-root>/custom/modules/Opportunities/metadata/listviewdefs.php. Open it, locate your custom field and add that line

 'sortable' => true, 
  

This will do the trick. Thanks so much - I appreciate the help!