Thousand place as comma

Hi Kris,

There are two options to achieve the required result:
(1) Create a view which handles the formatting
(2) Define your formatting in the Data Publisher

(1) This option is the simplest but requires SQL knowledge. The disadvantage is that sorting no longer works.

(2) This option requires JSON and javascript knowledge. It is more complicated than the first option but preserves sorting. It is explained here:
https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/
Please search for: fnRowCallback
Tip: use the revised example from Charles Godwin

Does this help?
Peter

There is another approach you can take.

Use a generated column introduced in MySQL 5.7. These are columns know to the database and when defined as virtual, are only used for data retrieval and consume no space.

Here are some reference articles
https://dev.mysql.com/doc/refman/8.0/en/alter-table-generated-columns.html
https://www.mysqltutorial.org/mysql-generated-columns/

add something like this to your schema
column4_a varchar(20) GENERATED ALWAYS as format(column4, 2) VIRTUAL

For more on the format function
https://www.w3schools.com/sql/func_mysql_format.asp

But, as Peter mentioned this will not provide a numeric sort.