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   1691 Views

Avatar
dynamite

Community Member, 66 Posts

17 September 2009 at 5:18am

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

Forum Moderator, 801 Posts

27 September 2009 at 4:26pm

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.