This article provides an overview of what configurable joins are, and how to utilize them to improve your querying scope.
The new Configurable Joins feature offers greatly extended capabilities for data extraction by providing access to more tables in the database, as well as a “smart” join menu that includes only query populations or tables that are related to the starting population, which then includes more possible related populations as more joins are added to the query.
A “join” combines data from multiple tables for querying, based on relationships between them. Configurable joins allows users to specify how a related table should be joined to a query base.
Configurable Joins significantly expands access to the database by exposing more of the underlying tables that were previously available only through custom SQL or direct SQL access. It also offers greater flexibility in query building. For example, a table that utilizes ranks could be joined multiple times to the same base, where each join pertains to a single record out of multiple possible records (for example, one join on Address Rank #1, and then an additional join for Address Rank #2).
Last Updated on