Skip to main content
S
Sarma1-Visitor
1-Visitor
May 17, 2019
Question

Thingworx SQL Query output different.

  • May 17, 2019
  • 1 reply
  • 1575 views

Hi,
I am facing same problem.
Data from TWX SQL SERVICE & SQL retrieved values are not matching for one column data. Number of rows returned are same in both cases.
Please share if you have any resolution... This is very critical for me.
Thanks in advance
Sarma

1 reply

P
PaiChung22-Sapphire I
22-Sapphire I
May 17, 2019

Are your datashapes mismatched? even upper lower case can make a difference

S
Sarma1-VisitorAuthor
1-Visitor
May 21, 2019

Thanks for the reply.

I have ensured that the Datashape is correct along with letter case properly. Still I see the issue

P
PaiChung22-Sapphire I
22-Sapphire I
May 23, 2019

Are you missing a column? Is it at all a 'reserved' word perhaps?

Try aliasing the column to a different name?

Terms & ConditionsAccessibility statement