Column aliases with Finder

  • Thread starter Thread starter Parsnip
  • Start date Start date

Parsnip

Guest
Member
Is there a way to assign an alias to a column when using Finder, similar to SELECT Thread.Forum.Node.title AS forum_title ... ?

When selecting from XF:post I'd like to get both the thread title and the node/forum title, but I only end up with the last column listed, which gets simply assigned to 'title'. If I swap the order around, I get the other column instead.

->fetchColumns(['Thread.Forum.Node.title', 'Thread.title']);

I am trying to avoid doing a second query to...

Read more

Continue reading...
 
Top