DropDown List Component SQL Query works in designer but not in Vision Client

Ignition
,
1

Using Ignition Version 8.1.48 and Vision Module Version 11.1.48

I created a Drop Down List and I am using it to sort data for a Vision Report.

The binding for this drop down list is a simple SQL query.

Dropdown Data Binding query
Dropdown Data Binding query817×686 94.3 KB

AS I said above, works as intended in the Designer. On the Vision Client this component is Red and has the Database issue icon.

Dropdown Vision Error
Dropdown Vision Error969×191 29.9 KB

Any and all help is appreciated. Thank you.

2

Use a named query for Vision, for security.

If you must, enable legacy database permissions in the project properties.

1 Like
3

Thank you pturmel. Using the Named Query allows this component to work as intended.

Out of curiosity, I just looked at the Gateway → Projects→ Selected this Project→ hit the Edit button

I don’t see any settings that is described as Legacy Database Permissions.

Am I looking in the wrong place to enable legacy database permissions?

4

These permissions are in the designer, not on the gateway.

1 Like
5

Thank you ryan.white

For the next person who gets lost →

Project Properties Location
Project Properties Location354×265 16.5 KB

Project Properties Permisions
Project Properties Permisions758×617 56.6 KB

All of these were disabled when I first opened this window. I looked back on an old project and they were all selected so I selected them all for this project.