How do i change column settings in a sql table like this:

order_item_ref order_price order_date

4657586 675.76000 2015-07-07 11:19:10

to:

Ref. Price. Date

4657586 675.76 $ 2015/07/07

Hello,

Open module settings page and set "Columns settings -> ID" parameter to order_item_ref value and "Columns settings -> Alias" parameter to Ref. value. Set "Columns settings -> ID" parameter to order_price value, "Columns settings -> Alias" parameter to Price. value and "Columns settings -> Format" parameter to the following value:



Set "Columns settings -> ID" parameter to order_date value, "Columns settings -> Alias" parameter to Date value and "Columns settings -> Format" parameter to the following value:



Regards,
ARI Soft

Thanks so much
Works great

Where can I find all valid values for the formats?

{$value|number_format:2}
--> What is 2? What else is possible?

{$value|date_format:Y/m/d}
...

I need the german number representation:
2.000,00 for the number two thousand.

Thanks!

Hello,

"number_format" formatter is a wrapper for number_format and it accepts the same parameters. In your case use the following code:

{$value|number_format:2:,:.}

Regards,
ARI Soft

thank you, it works!