Custom Column Names in Export

ImplexSQL · Post by **ImplexSQL** » Wed Dec 17, 2014 5:45 am

Hello.

I wish to customize some column names during export. Specifically, I'd like to query a table and retrieve some values based on the CurrentUserID(), then use the resulting values as the column names. So the values are not in the lang XML, rather from a data table based on the user.

It appears to me that this would be done in the applicable *info.php file in the $Doc->ExportTableHeader() section, but everything I try either has no affect or kills the columns I mess with.

So, I seek guidance.

Thank you in advance.

mobhar · Post by **mobhar** » Wed Dec 17, 2014 1:17 pm

Does it mean you do not do anything for that $Doc->ExportTableHeader() section?

mobhar · Post by **mobhar** » Wed Dec 17, 2014 2:24 pm

Well, all right then. Assume the table name is "orderdetails", the field name is "OrderID", and you want to change it become "My Order ID", then simply put the following code in "Page_Load" server event:

if ($this->Export <> "") {
Language()->setFieldPhrase("orderdetails", "OrderID", "fldcaption", "My Order ID");
}

ImplexSQL · Post by **ImplexSQL** » Wed Dec 17, 2014 10:02 pm

Brilliant! Thank you very much, mobhar! This indeed does exactly what I sought. I very much appreciate your assistance.