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: http://community.sagesaleslogix.com/slsl/board/message?board.id=SLX_Discussion&thread.id=1465&view=by_date_ascending&page=1
Here is a workaround.
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.