Mohd faizal Adris Posted March 31, 2020 Share Posted March 31, 2020 Hi, I'm relatively new in the Spotfire and currently using Analyst version 10.3 for dashboard development. In my dashboard, I have a text area containing an HTML textbox that requires to display a piece of information in the text form to end-user. What I'm trying to achieve right now is to query the data from the SQL database and display it in the HTML textbox area. Could anyone advise how can I achieve it Thanks. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted March 31, 2020 Share Posted March 31, 2020 are you looking to add the information by retreiving it from an existing data table in the analysis or do you have to query to some other data base Link to comment Share on other sites More sharing options...
Mohd faizal Adris Posted March 31, 2020 Author Share Posted March 31, 2020 Hi Shandilya, Initially, I want to query the information from other database but I couldn't find any solution yet. What I'm trying to do now is to establish a connection to the database in my analysis file and get it to display in the HTML textbox. Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted March 31, 2020 Share Posted March 31, 2020 If you have want to retrieve the value from the data table in analysis then you can insert a Calculated Value in the text area and write an expression to get the value you need from the data table Link to comment Share on other sites More sharing options...
Mohd faizal Adris Posted April 1, 2020 Author Share Posted April 1, 2020 Thanks for your advice. I'll give a try based on your suggestion. Link to comment Share on other sites More sharing options...
Mohd faizal Adris Posted April 2, 2020 Author Share Posted April 2, 2020 @Shandilya. Is it possible to return the calculated value in string format Link to comment Share on other sites More sharing options...
Shandilya Peddi Posted April 2, 2020 Share Posted April 2, 2020 There is a String() method that can be used when createing the calculated value expression. Can you give that a try Link to comment Share on other sites More sharing options...
Mohd faizal Adris Posted April 3, 2020 Author Share Posted April 3, 2020 It prompts an error "Could not find function 'String' after editing the expression. Am I doing wrong Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now