Invoice:
  columns:
  id: ...
relations:
  Items:
    refClass: invoice2item
    local: invoiceid
    foreign:itemid
    alise: itemlist

invoice2item:
  tablename...
  options:
    orderBy: name
  columns:
    invoiceid...
    itemid...
relations
  invoice:
    local: invoiceid
    foreign:id
   item:
    local: itemid
    forien: id

item:
  tablename:...
  colums:
    id...
    name: varchar(255)

problem:
I need to sort
$invoice->getItems()
by item.name

for some cases  (when symfony joins with items) this works by setting:
  options:
    orderBy: name

into invoice2item


but in some cases symfony doesnt't create full join sql statements and
throws errors like

unknown column name order by name
(select * from invoice2item where .... order by name)

is there an easier solution or do I have to overwrite the getItems()
function?

thx a lot



-- 
If you want to report a vulnerability issue on symfony, please send it to 
security at symfony-project.com

You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en

Reply via email to