Hi,
I have a tag with a query of type String Array, this tag needs other tag to make a query like:
SELECT CAUSA
FROM [DBB].[dbo].[table1]
inner join [table2] on [table1].id=table2.id
where text in ({[.]tagId.value})
this query works fine.
The tagId (in the condition) is data type Integer Array, in this example the value is 101, 117.
But the first tag sends me the error "Error_ExpressionEval(“Invalid column name ‘101,117’.”).
If i change the type of date type to Integer, work fine but only takes the first vale that is 101.
can you help me to know why happens this.
thanks