Custom SQL and formatColumns

Discuss about Group-Office development here

Moderator: Developers

jamesarthur
Posts: 55
Joined: Fri Nov 08, 2013 9:15 am

Custom SQL and formatColumns

Postby jamesarthur » Fri Feb 14, 2014 2:38 pm

If I was to add a custom join to a `FindParams`, how do I subclass the `AbstractModelController` to return those fields I've selected in a store?

I cannot use joinRelation because I use some unusual criteria, meaning I have a 1-to-1 relationship without keys in each table.

I think the problem comes from the fact that since those fields don't have columns, using PDO::FETCH_CLASS doesn't return the attributes (there is no class member field with the correct name).
jamesarthur
Posts: 55
Joined: Fri Nov 08, 2013 9:15 am

Re: Custom SQL and formatColumns

Postby jamesarthur » Fri Feb 14, 2014 3:28 pm

NOTE: I'm planning for now to use a view to get round the problem.

Who is online

Users browsing this forum: No registered users and 1 guest

cron