Sub Panel - Order of Data

[matt.stannard]

Hey there,

Hopefully a simple request, in the sub panels, I'd like to have the data automatically ordered by a field, can someone help point me in the right direction?

Many thanks!!

[madmat]

 layoutdefs -> subpaneldefs -> field -> 'order' => xx, 'sort_order' => 'asc/desc', 'sort_by' => 'field' 
  

you can either use the subpaneldefs.php in "modules/your_module" or even better (upgrade safe) via layoutdefs in your custom folder.

[matt.stannard]

Hi,

Thanks for that - I can't seem to find where to put the code, can you help me?

M

[eitrix]

sugarfolder/modules/module_name/metadata/subpaneldefs.php

If you are making changes copy this file in sugarfolder/custom/modules/modulename/metadata/HERE

if folders does not exist, create them.

Then edit the file and order values. One thing i noticed is after you edit order values and quick repair, sometimes they won't be working either becouse you manualy moved some subpanels and then he remembered your preferences. To sort this out clear out user_preferences table in database, but this will reset all your preferences. I don't know better way yet.