Sql view in ignition

Ignition
1

Good morning,
Is it possible create sql View in the scripts or in the Named query???

Thank you

Bye

2

What do you mean by "sql View"?

3

In my Sql server, I need to create view with Ignition

4

I think you are asking, "Is it possible to display data from an SQL query in an Ignition window (Vision) or Ignition view (Perspective)?" Is that correct?

The answer is "yes" to both. Which are you working with - Vision or Perspective?

5

No, It isn't not correct.
In Sql Server management studio, I can create View in the Sql Server.
I ask if it's possible to create Sql Server View also with Ignition.

6

Yes can create view using Named Queries with Query Type as Update Query

1 Like
7

if You want SQL CREATE VIEW Statement, use this syntaxe:

CREATE VIEW identifiantTest
	SELECT id_center
	FROM turbine
	WHERE id_center >200

Query type ** Update Query**

I test it , it work.

2 Likes
8

There is no way that would work. Please take care in your writing.

9

image
image1107×739 32.8 KB

is not something like that he is waiting?

1 Like
10

He's talking about the spelling. :wink:

4 Likes