Using extra column with a SQL max function, works fine with group by and join

[srini46]

Hello I have a list view using eTemplate next match widget. I have an inner join and one extra column working very well. Now I have added another extra column, but that column would use a SQL MAX function. This column is going through from get_rows function to search function in so_sql and then to _get_columns function which would take $extra_cols.

But right at the top there is a regex loop which is removing my function and returning only the last part. I am not sure how to tackle this problem.

This is how I have listed my extra columns, join and order by.

$extra_cols[0] = “devicetype_type”;
$extra_cols[1] = “max(subtemplate_vno) as subtemplate_vno”; //Recently added extra column
$join = “INNER JOIN devicetype as d on egw_subtemplate2.devicetype_id = d.devicetype_id”;
$orderby = " group by egw_subtemplate2.subtemplate_name order by egw_subtemplate2.subtemplate_vno";

So I am using $extra_cols as an of strings. Is this the right way or am I missing thing???

[srini46]

I meant regex if condition where it would check for the position of “as”. And from there I only get the alias name and nothing else. And due to this reason I am not getting any data.

ex: $extra_col = “max(subtemplate_vno) as vno”

all I get after this is just “vno”; [(:]