MS SQL Schema doesn't detect in Named Query Builder

Ignition Early Access
1

Hello,
As shown in the following image we have some schema and in each schema, we have a table named “Main”. The problem with the named query builder menu is distinguishing between tables and repeating columns 2 or 3 times!!!

image
image1920×1080 293 KB

2

Have you selected this setting in the advanced settings area? You may need to restart your designer after modifying the setting.

image
image1187×77 3.43 KB

5 Likes
3

Thanks, it solve the problem

4

Huh, I never knew that setting existed. That’s so much easier than having separate connections for each schema.