orm - 我如何在 schema.yml Doctrine symfony 1.4 中进行排序

Question

我使用 ProjectAsset 类作为这两者之间的中间类，从项目到 Assets 建立了多对多关系。当我在项目上使用 getProjectAsset() 方法时，它返回分配给该项目的所有 ProjectAssets。

如何更改 schema.yml 以默认对结果进行排序？

Project:
  relations:
    Assets:
      class: Asset
      refClass: ProjectAsset
      foreignAlias: Projects
      local: project_id
      foreign: asset_id           

ProjectAsset:
  tableName: projects_assets
  columns:
    title: { type: string, length: 255 }
    project_id:  { type: integer, primary: true }
    asset_id: { type: integer, primary: true }
  relations:
    Project:
      class: Project
      foreignAlias: ProjectAssetRelations
      local: project_id
      foreign: id
      onDelete: CASCADE
    Asset:
      class: Asset
      foreignAlias: ProjectAssetRelations
      local: asset_id
      foreign: id
      onDelete: CASCADE

Answer 1

这是我看完后的第一个想法http://www.dobervich.com/2011/03/05/symfony2-blog-application-tutorial-part-ii-the-data-model/不过还没有测试过。

oneToMany:
    posts:
        targetEntity: Post
        orderBy:
            createdAt: DESC