slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Cannot See Table in Query Builder (6.2.6)

careed76
Posts: 16

Cannot See Table in Query Builder (6.2.6) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Apr 08 9:59 AM

I am using the Query Builder dialog in SalesLogix 6.2.6 to create a custom list view, but one of the tables I need to access is not visible in the tree. The table is a custom table that is related to another custom table that is related to the Opportunity table.

Opportunity
- Custom Table 1 (1:Many relationship to Opportunity table)
- Custom Table 2 (1:Many relationship to Custom Table 1)

The appropriate joins appear to be setup correctly when viewed from Database Manager and from the Joins dialog that is available from Query Builder. I tried defining the joins again, but it would not allow this because the same exact joins already exist. Any ideas? Thanks.

[Reply][Quote]

Matt Dockins
Posts: 159

Re: Cannot See Table in Query Builder (6.2.6) Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 30 Apr 08 10:05 AM

the query builder will not always display all joined tables because some of the joins are recursive and it would take an infinite amount of time to fill the left pane.

To get to the table you want, you need to right click on the join id of the table you CAN see, and select either 'Create Local Join' or, if its available 'Global Join to YOURTARGETTABLE'

you may have to make a few of these joins like this in the query builder.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 8/23/2025 2:19:45 PM