Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Problem retrieving data from data sources in a script variable
Migrateduser
<p>So I've been working on a report and I have this very weird problem so I would be glad if you could help me .</p>
<p> </p>
<p>So I have a table which is constructed by a left join of two data sources. Everything seems fine however I'm having serious problems reading from the database to a script. My code looks like this:</p>
<p> </p>
<p> </p>
<p>test1 = <value-of>row</value-of>;</p>
<p> </p>
<p>test2 = <value-of>row</value-of>;</p>
<p> </p>
<p>test3 = <VALUE-OF>row["text"]</VALUE-OF><br>
</p>
<p>So, I can get the values of test1 and test2 and output them using console.log(), but no matter what I do I cannot get the output of test 3.</p>
<p> </p>
<p>I know it's hard to provide an answer on this but could you please guide me towards the solution by answering the following questions?</p>
<p> </p>
<p>1. Does the data type of the row (decimal,string etc) plays a role on how we should use <VALUE-OF>?</p>
<p> </p>
<p>2. Do we need to include the table name on <value-of>row</value-of>; ?</p>
<p> </p>
<p>3.Do we need to have any sort of calculation to have the data retrieved? (for example in test1 and test2 I am dividing by a number)</p>
<p> </p>
<p>Generally if you can think something that it could help me like what others have done in similar situations please let me know !</p>
<p> </p>
<p> </p>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet