CiviCRM Community Forums (archive)

The sort name for organization records seems to be identical to the display name.  I think it would be helpful to strip any leading "the "s and also expose the sort name field.

I see that there was a fix for exposing this field, but that it was marked "not fixed". http://issues.civicrm.org/jira/browse/CRM-6333

Wondering why this wasn't adopted, and whether there would be any objection to having the sort name strip any leading "The "s.    I haven't looked yet, but I assume there is code that is run on insert/update of contacts that sets the sort name, and it should be a fairly easy thing to modify. 

If you are open to that, I'll try to do it.   It's certainly a more complete way of doing in than just stripping the "the"s.  But right now we're using view to pull up a list of members on our website, and if I sort the view on sortname the "the"s all sort in the 't's instead of in their appropriate spot, which is why this is on my radar. 

Must have hit save by accident somehow ...

The change above works well for my simple needs.  (Of course you need to do this: update civicrm_contact set sort_name = right(sort_name, length(sort_name) - 4) where sort_name like 'the %'; to correct existing organizations.)

Is this of interest as a patch?  I don't know when or if I'll ever get to tackling the larger question of exposing the sort name. Although that would clearly be a better solution.

we'll need to figure out how to address this for other languages and probably other patterns.

maybe introduce a hook there with the default implementation, checking the language and  if en_* stripping 'the' out

lobo

Hi,

en_GB might want to remove "the" too

I'd second lobo suggestion to have a new hook, and create your "remove the" as an extension that implements the hook. Gives a good example AND makes it more modular (eg. I have clients with a dutch interface but that deal with a lot of english org)

X+

Agreed - I would really like this functionality. I posted a comment in CRM-6333 linking to this issue and asking if it was appropriate to reopen (which I don't appear to have the permissions to do), but I know in the Drupal issue queue, the maintainers will rarely ever see a comment on a closed issue, so I thought I should pipe up here as well.

One use case: I've used Eileen's entity module to expose CiviCRM data to Views, and I've created a list of auction donors that contains both individuals and organizations. But not everything is in the right order so it would be great to be able to control it.

Thanks Dave!

I'm new enough to this that although I have some experience with Drupal hooks, I have no idea (yet) what an "existing post hook against the contact record" would be, but hopefully I will figure all this out soon.

I've been discussing this with Dave recently as a client has been willing to sponsor (part) of this effort.  The cost would be relatively low, but no insignificant. 

If would could find a way to make Sort Name available for editing on Households and Organizations ...as well as import and batch update, would any of you be interested in contributing $ € £ ?

See here for more information on the plan:
http://wiki.civicrm.org/confluence/display/CRM/Sort+Name+as+a+Customizable+Field