Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions

many_many sort order per relationship


Reply

2 Posts   1634 Views

Avatar
dynamite

17 September 2009 at 5:18am Community Member, 66 Posts

Hello,

I have "ArticlePages" and "Authors" and have it working with many_many and belongs_many_many

I would like to customize the sort order on a per relationship basis. That way, on one ArticlePage the first author listed won't necessarily be the first author listed on a different ArticlePage.

In the CMS, I am using ManyManyDataObjectManager from the DataObjectManager module.

Any ideas, hints, etc would be awesome!

Thank you... Jeremy

Avatar
Ingo

27 September 2009 at 4:26pm Forum Moderator, 801 Posts

From a datamodel perspective, have a look at DataObject::$many_many_extraFields, which can be used to implement a sorting column. You can add this information through ComponentSet->add(), although there's no way in the ORM to read them out, apart from using raw SQL. Not sure about the interface, and wether DataObjectManager supports this extradata. Should be fairly easy to implement though.