Problem with expression evaluation when setting Back Color property of dashboard Indicator
-
- Posts: 6
- Joined: Thu Jun 20, 2024 2:33 pm
Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hi.
This issue concerns Stimulsoft designer version 2024.2.6 (Mac and Windows) and Angular stimulsoft-dashboards-js versions 2024.3.1, 2023.3.4. On these it was tested however it may concern another versions as well.
I'd like to set Back Color of dashboard Indicator (using Back Color property of Indicator element) based on datasource column value. I'm comparing value and target, both of them coming from datasource.
Example of condition: {IIF(root.value1 > root.target, "Red", "Green")}
However root.value1 and root.target are evaluated as 0 in this condition despite having different values in datasource, resulting in "false" even if root.value1 is greater then root.target. This is resulting in improper background color of dashboard indicator.
I have attached simple demo.
Can you help me? Thanks.
This issue concerns Stimulsoft designer version 2024.2.6 (Mac and Windows) and Angular stimulsoft-dashboards-js versions 2024.3.1, 2023.3.4. On these it was tested however it may concern another versions as well.
I'd like to set Back Color of dashboard Indicator (using Back Color property of Indicator element) based on datasource column value. I'm comparing value and target, both of them coming from datasource.
Example of condition: {IIF(root.value1 > root.target, "Red", "Green")}
However root.value1 and root.target are evaluated as 0 in this condition despite having different values in datasource, resulting in "false" even if root.value1 is greater then root.target. This is resulting in improper background color of dashboard indicator.
I have attached simple demo.
Can you help me? Thanks.
- Attachments
-
- dashboard.mrt
- (7.6 KiB) Downloaded 351 times
-
- Posts: 6647
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
We require more time to investigate the issue thoroughly. Rest assured, we will keep you informed about the outcome as soon as possible.
Thank you.
#14730
We require more time to investigate the issue thoroughly. Rest assured, we will keep you informed about the outcome as soon as possible.
Thank you.
#14730
-
- Posts: 6
- Joined: Thu Jun 20, 2024 2:33 pm
-
- Posts: 6647
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
We will let you know about the result.
Thank you.
We will let you know about the result.
Thank you.
-
- Posts: 6647
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
The issue is fixed. The fix will be available in the next release build.
Thank you.
The issue is fixed. The fix will be available in the next release build.
Thank you.
-
- Posts: 6
- Joined: Thu Jun 20, 2024 2:33 pm
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
I have upgraded to version 2024.3.2, however problems still persist.
Stimulsoft Designer for Windows - fixed, it's OK.
Stimulsoft Designer for MAC - not fixed
Angular stimulsoft-dashboards-js (installed through npm) - not fixed.
Can you look at it, please?
Thank you.
I have upgraded to version 2024.3.2, however problems still persist.
Stimulsoft Designer for Windows - fixed, it's OK.
Stimulsoft Designer for MAC - not fixed
Angular stimulsoft-dashboards-js (installed through npm) - not fixed.
Can you look at it, please?
Thank you.
-
- Posts: 6
- Joined: Thu Jun 20, 2024 2:33 pm
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
I have found the same problem with Dashboard-JS for HTML 2024.3.2 as well.
https://github.com/stimulsoft/Samples-D ... in/scripts
Thank you.
I have found the same problem with Dashboard-JS for HTML 2024.3.2 as well.
https://github.com/stimulsoft/Samples-D ... in/scripts
Thank you.
-
- Posts: 6647
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
We are still working on the issue in the JS version.
Thank you.
We are still working on the issue in the JS version.
Thank you.
-
- Posts: 6647
- Joined: Tue Mar 20, 2018 5:34 am
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
The issue is fixed. Please check the next release build.
Thank you.
The issue is fixed. Please check the next release build.
Thank you.
-
- Posts: 6
- Joined: Thu Jun 20, 2024 2:33 pm
Re: Problem with expression evaluation when setting Back Color property of dashboard Indicator
Hello,
I have experienced another problem with the Back Color property in Indicator in the latest JS version 2024.3.3.
Steps to reproduce:
1. Change the datasource in the example in the first post from JSON to MSSQL database.
2. In Back Color property expression replace columns from JSON to SQL datasource columns (on both sides of the expression).
3. Web server url of JS data adapter should be called on dashboard opening, however it is not.
4. When you remove the expression from Back Color property and refresh dashboard, JS data adapter is called correctly.
I guess that conditional color of background should work regardless of the datasource type.
Can you look at it, please? Thanks.
I have experienced another problem with the Back Color property in Indicator in the latest JS version 2024.3.3.
Steps to reproduce:
1. Change the datasource in the example in the first post from JSON to MSSQL database.
2. In Back Color property expression replace columns from JSON to SQL datasource columns (on both sides of the expression).
3. Web server url of JS data adapter should be called on dashboard opening, however it is not.
4. When you remove the expression from Back Color property and refresh dashboard, JS data adapter is called correctly.
I guess that conditional color of background should work regardless of the datasource type.
Can you look at it, please? Thanks.