Spaces in SQL query

    Spaces are getting added to the column names when trying to share the custom view query through teams channel 

    Below are the logs collected from affected machine where the SQL query to be used for capturing the boot time details was shared with the customer. 

    But as we can see the spaces were getting added as the query was copied from teams channel. 

    The reason why the view was not condensing as expected was due to the extra spaces getting added to the column names when trying to share the custom view query through teams channel. We identified this issue and recreated the customs views that are required to make the "Daily Boot time and Login details" dashboard functional. 

    Workaround Solution  

    The query should be either tested and should be selected or copied from the notepad and not from the teams channel. 

    Copying the query from notepad will not have the extra spaces added. 

    « Previous ArticleNext Article »


    0.0 (0)



    Looking for Something?
    Tags