AnsweredAssumed Answered

Nintex and SQL Spatial query

Question asked by tagjava on May 21, 2018
Latest reply on May 21, 2018 by tagjava

Hi,

I have got my Nintex workflow which executes a spatial query in SQL Query action.

 

DECLARE @g geometry;
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('POLYGON ((234.314209 -88.999095469, 50.000031 -00.00000999095466))', 0);
SET @h = geometry::STGeomFromText('POLYGON ((234.314209 -88.999095469, 50.000031 -00.00000999095466))', 0);
SELECT @g.STUnion(@h).ToString();

 

this query is not run against any table.

 

 

the result i get is just variable name like following figure. it should be a polygon of coordinates. 

testError variable gives me following result.

 

the query is working fine on SQL Server Management studio instance.

 

can you please tell me whats going on?

Regards

java guru

Outcomes