Format Integers with commas

[mfouilleul]

Hello,

Our users complains about the integers are shown with comma.

Example

SELECT id FROM test;

Where id is INT(11) unsigned

Result is 21,668

Do you know if we can fix it quickly?

Thanks

Max.

[dersphere]

Maybe a little late but I ran into the same issue and solved it by casting the id-column to char.
In your case: SELECT CAST(id as CHAR(8)) as id FROM test;
Hacky "but it works" ;)

[arikfr]

V4 includes the ability to configure how each column is rendered, so you can control whether you want the commas in integers or not.

[chgxtony]

@arikfr how to configure how each column is rendered

[rohit-conn]

Currently we are using V5 but I cant seem to find the parameter to check rendering.
Could you please point me to the right direction.

[deed02392]

Bump. Where do we configure this?

[masterlittle]

Its actually in the organization table in the database. You will have to edit that table entry. Redash stores this setting on startup.

For fresh installs only -->
There are two env variables which can be set -

REDASH_INTEGER_FORMAT="00"
REDASH_FLOAT_FORMAT="00.00"

This will remove the commas in the formatter.

[faridskyman]

Maybe a little late but I ran into the same issue and solved it by casting the id-column to char.
In your case: SELECT CAST(id as CHAR(8)) as id FROM test;
Hacky "but it works" ;)

this solves my problem.. thx!

[eradman]

@faridskyman: as @masterlittle suggested you can update the organizations table to make change the number format

UPDATE organizations SET settings = jsonb_set(settings::jsonb, '{settings,float_format}', '"0.0"', true);
UPDATE organizations SET settings = jsonb_set(settings::jsonb, '{settings,integer_format}', '"0"', true);