Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Elite Contributor
Posts: 72
Registered: ‎04-01-2009

Cannot view data in custom table in query builder - SLX LAN v7.2.1

Hi all.

 

I created a custom table that has a 1:1 relationship with the ACCOUNT table.

 

When signed in as an end user and I am in query builder and I select a field from this custom table and click the browse button to view the data in the particular field it comes out blank.

 

Yet, this does not happen when I am signed in as the ADMIN, I can see the data when I click on the browse button for a field in the custom table.

 

The custom table was created in the Architect through the Database Manager.

 

What could be happening?

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Cannot view data in custom table in query builder - SLX LAN v7.2.1

Which version of SalesLogix?

  I'll bet that the SECCODEID in the 1:1 table is null.. or not the same as the ACCOUNT.SECCODEID

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Copper Elite Contributor
Posts: 72
Registered: ‎04-01-2009

Re: Cannot view data in custom table in query builder - SLX LAN v7.2.1

LAN v7.2.1

 

How can I check the secodeid for the custom table and match that to the ACCOUNT table secodeid?

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Cannot view data in custom table in query builder - SLX LAN v7.2.1

[ Edited ]

A simple SQL update. If you use sync.. make sure you use ExecuteSQL in the admin...

 

Can also code it in VBScript. 

 

Looking back I would have added the fields to the main table and not do a1:1. In fact, the recomended best practice is to NOT create 1:1 tables. 

Message Edited by RJLedger on 08-26-2009 02:45 PM
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Copper Elite Contributor
Posts: 72
Registered: ‎04-01-2009

Re: Cannot view data in custom table in query builder - SLX LAN v7.2.1

I recreated the table and instead of making it 1:1 I made it 1 to many and it works fine now.
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Cannot view data in custom table in query builder - SLX LAN v7.2.1

1:m tables are not secured and do not have a SECCODEID field. So it works because there is no security.
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html