Can you access a sql view in a SalesLogix datagrid??


I am working in SLX 7.5.1. I have created a SQL View using a linked server. I am trying to access the view in a datagrid but I am unable to see the table when I try to do a join to it with the Account table. Can anyone tell me what I am missing?


There is a thread on the SLX community where issues with 7.5.2 and SQL Views are discussed:

Here is a workaround.

Try This.

1. Create the SQL view on a SLX 7.5.1 DB, and the 7.5.2 DB.
2. Log into SLX Administrator on 7.5.1 and enable the view. You’ll get a warning that there’s no primary key so you can’t create a child table, but if for data grid displays that doesn’t matter.
3. In SQL Management Studio, select the resynctabledefs record for the View.
4. Write an insert statement to insert the values. Add your key field to the KEYFIELD field. Run it on the SLX 7.5.2 DB.

This will enable the view.

Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!