AppGini Community Forums

Hello
I am looking for help to get number format like this " 5 000" instead of this "5000"

How to custom these code

Code 1
SELECT `caisse`.`recettes` - `caisse`.`depenses`
FROM `caisse`
WHERE `caisse`.`idcaisse`='%ID%'

Code 2
SELECT
SUM(montant) depenses
FROM
depenses;

Thank you

Hi,

you can use

replace(format( VALUE ,0),',',' ')

like

SELECT replace(format(`caisse`.`recettes` - `caisse`.`depenses`,0),',',' ') FROM `caisse`
WHERE `caisse`.`idcaisse`='%ID%'

You can try to use MySql number format function with your locale as 3rd parameter:

http://www.mysqltutorial.org/mysql-format-function/

Available locales:
https://dev.mysql.com/doc/refman/5.7/en ... pport.html

Hello

Thank you for your help

Regards

Hello
I have try many type but still not working for me

SELECT replace(format(`membres`.`montant` * `membres`.`duree`,0),',','')
FROM `membres`
WHERE `membres`.`idmembre`='%ID%'

"montante is set to decimal and "duree" is set to integer (for reference)

Thank you for any help.

Best regards

Hi,

can you post the result you get from the native sql statement.

SELECT `membres`.`montant` * `membres`.`duree`
FROM `membres`
WHERE `membres`.`idmembre`='%ID%'

Hi

Sorry, I am not sure to get your question, but this is what I get.

When I put 1000 I get 1000

I want to get this 1 000

Thank you

Hi,

if the montante is set to decimal, you should have a result with decimal precision. Can you check that.

ok, I set the field "montant" as this
Decimal with precision 0

Hi,

can you try

SELECT replace(format(`membres`.`montant` * `membres`.`duree`,0,'en_EN'),',',' ')
FROM `membres`
WHERE `membres`.`idmembre`='%ID%'

watch the space at the end ',','SPACE')

thank you, please give a moment to try and back to you

best regards,

not working, maybe I miss some point

Hi,

the statement itself is only

thank you Olaf, and sorry for my poor knowledge. back to you once fixed.

regards,

Even so I'm not Olaf, hope it works now.

my bad !
sorry

ok, I correct the code but still not working for me unfortunately !!!

Hi,

I think you need to change the type for the field Montant TOTAL to varchar (10) or what suits you best.

ok I will try all type until I find the correct.
Thank you

yes it is working. When I change to varchar (10) it is working.
but the problem is I cannot use the option "show column sum" with varchar

Hi,

ok, so there was a missunderstanding. If you want to see the result in the table view with your format, you should change back the type to decimal, or integer (if you do not use decimals).

montant total
you can create in the hooks folder a file called membres-tv.js. Add the following to the file.

Hello
thank sir for your help and support, I am going to check and let you know.

Best regards,