Condition Relationships is an advanced feature of C1Query allowing you to specify a custom SQL condition instead or in addition to joins.

Condition relationships are not used to join tables when C1Query analyzes the set of tables used in a query and joins all these tables together. Only join relationships are used for that purpose. Condition relationships come into play later, when all tables are joined. They add their custom SQL conditions to the WHERE clause of the generated SQL statement.

Use the Add condition relationship menu item in the context menu or the Add relationship button to create a condition relationship.

In the Condition Relationship Designer window, specify the two (or more, in the case of a ternary or higher order relationship) views, and the text of the custom SQL condition.

In the SQL condition, use SQL syntax for functions and operators, and the following syntax for fields:

[view_name]![table_name].[field_name]

Copyright (c) GrapeCity, inc. All rights reserved.