Creating a count field

[vampirefrog]

Hello. I'd like to create a field that is simply the count of related entities in a related table. I have been able to do this by adding "select": "(SELECT COUNT(*) FROM related_entity WHERE related_entity.fk_id = this_entity.id)", but I cannot sort by this value. Is there a way to have a count field and also be able to sort by it? Thanks!

[tanya]

Hello
Try to set orderBy as well
an example in application/Espo/Modules/Crm/Resources/metadata/entityDefs/Opportunity.php amountWeightedConverted field amountWeightedConverted

[vampirefrog]

Thank you Tanya, I will have a look.