JDBC Driver for SugarCRM

Build 24.0.9062

IncludeRelationships

Set this to true if you want to expose relationship columns, which give you the ability to query objects in relation to other objects.

データ型

bool

デフォルト値

false

解説

Relationships are the basis for linking information within the SugarCRM system. The relationships are exposed by the 本製品 in the form of views. Set this to true if you want to expose relationship Views.

For example:

SELECT * FROM REL_account_tasks = '514b69aa-41e0-11ea-a5ef-02424563122e'
SELECT * FROM Accounts WHERE accounts_contacts = 'e9b69b60-41e0-11ea-82f2-02424563122e'
SELECT * FROM Notes WHERE accounts_notes_1 = '514b69aa-41e0-11ea-a5ef-02424563122e'
SELECT * FROM Accounts WHERE accounts_notes_1 IN ('4a6cd5de-f40e-11ea-99f0-02f85148f4a4', '456ffdc2-f40e-11ea-86ca-02f85148f4a4')

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062