SQL Table Widget Issue

David_Allen

When using the SQL Table Widget, if you use the AS statement to assign an alias, and the alias contains a space, the query fails and no data is returned at all. 


Is this by design, or maybe a bug?

Tony_Collett

Hi David, 
I just checked in my environment on version 6.0.2 and can confirm that there is definitely something strange going on when using a space within aliases:

select distinct workitem.workitemID as "IDs", WorkItem.title,  

This works, but

select distinct workitem.workitemID as "I Ds", WorkItem.title,  

this does not. 

I will log a ticket on your behalf and send it through our development team to investigate

Regards, Tony

Tony_Collett

Hello,

This fix is now ready with v7.1.2012.1 available. Please use your Click-Once installer to update to the latest version. For more information about your Click Once Installer please see this KB: https://support.cireson.com/KnowledgeBase/View/1345#/

For the Release Notes please see the bottom of this article: https://support.cireson.com/KnowledgeBase/View/1351/

Thank you, Tony

Brett_Moffett

What version of the portal are you running?

Brett_Moffett

Are you putting the Alias's in quotes?
If they have a space and they are not in quotes this would fail.

Tony_Collett

Hi David, 
I just checked in my environment on version 6.0.2 and can confirm that there is definitely something strange going on when using a space within aliases:

select distinct workitem.workitemID as "IDs", WorkItem.title,  

This works, but

select distinct workitem.workitemID as "I Ds", WorkItem.title,  

this does not. 

I will log a ticket on your behalf and send it through our development team to investigate

Regards, Tony

David_Allen

Thanks Tony.  Your test is exactly the issue. 

I am running v7 of the portal for your information.

Morten_Meisler

Yep this is an issue, I also tried with single-apostrophe and escaping it. Same issue happens if you make a comment in the widget with spaces.

A workaround is to make underscores instead of spaces since the column name is underlined anyway so it can't be seen. Example: as "Operating_System" (given you are making a sql table widget)

David_Allen

I have used underscores as a workaround already, but non-IT users feed back that it looks to "technical" with underscores and does not give the impression that the report is business focussed. 

I personally don't see an issue with underscores as long as the data is good, but then I am techie 

David_Allen

Just an FYI for everyone, this has now been filed as a bug with Cireson... As soon as I hear about a fix being available, I will post back!

Brett_Moffett

David_Allen said:

I have used underscores as a workaround already, but non-IT users feed back that it looks to "technical" with underscores and does not give the impression that the report is business focussed. 

I personally don't see an issue with underscores as long as the data is good, but then I am techie 

What are non technical people doing looking at SQL Code?
Or are you talking about the labels of the graphs?
Might be a good feature request to have text editable labels for dashboards.

Tony_Collett

Brett_Moffett said:

Might be a good feature request to have text editable labels for dashboards.

To be fair, that's what aliases are for Unless you mean customisable labels for other users

Tony_Collett

Hello,

This fix is now ready with v7.1.2012.1 available. Please use your Click-Once installer to update to the latest version. For more information about your Click Once Installer please see this KB: https://support.cireson.com/KnowledgeBase/View/1345#/

For the Release Notes please see the bottom of this article: https://support.cireson.com/KnowledgeBase/View/1351/

Thank you, Tony