asked on March 13, 2023
Hello team,
i've a question about runQuery method, i used it when i want programattically change formats and other stuffs ( see Run query 1 button in fiddle example), how can i remove formats using run query? i've try to use it like in example ( see Run query 2 button in fiddle example) but it doesn't works .
https://jsfiddle.net/sergin/kym2srxb/10/
thank you in advance.
Massimo
⋅ March 14, 2023
Hello, Massimo!
Thank you for contacting us.
Kindly note that it is possible to remove the measure using runQuery() API call, if the format name assigned to the measure is not present in the formats list, for example:
measures: [{
uniqueName: "Price",
aggregation: "sum",
format: "none"
},
//other measures
]
We have modified your example to illustrate the suggested approach: https://jsfiddle.net/flexmonster/ajh4sqfr/. The "Run Query 2" button now removes the formatting from the "Sum of Price" column.
Please note that it is also possible to change formats using our setFormat() API call: https://www.flexmonster.com/api/setformat/.
Hope you will find our answer helpful.
Regards,
Solomiia
⋅ March 22, 2023
Hello, Massimo!
Hope you are doing well.
Our team is wondering if you had some time to try the suggested approach of removing formatting via the runQuery() API call. Could you please let us know if it works well for you?
Looking forward to hearing your feedback.
Kind regards,
Solomiia
⋅ March 29, 2023
Hello, Massimo!
Hope you are having a great week.
Just checking in to ask if the suggested approach of removing formatting when using the runQuery() API call was helpful.
Looking forward to your response.
Regards,
Solomiia