How to join TRS views bq_contract_header and bq_contract_detail

Owned by Knowledge Assistant
Last updated: Jul 02, 2024 by Moriah Yorkey
1 min read
Description of Issue

Client is looking for the relationship between bq_contract_header and bq_contract_detail to join in SQL query for custom reporting

Context

  • SSRS reports

  • SaaS, Tyler-hosted clients

  • OnPrem, Self-hosted clients

  • Contracts

  • Enterprise ERP version 2019 and above

Cause

Due to Change orders, there are more relationships than normal header and detail views

Resolution

The following sample query shows how to link the views bq_contract_header and bq_contract_detail:

SELECT *

FROM bq_contract_header LEFT JOIN bq_contract_detail 

ON bq_contract_header.a_contract_no = bq_contract_detail.a_contract_no

bq_contract_header.a_fiscal_year = bq_contract_detail.a_fiscal_year

bq_contract_header.bh_chgord = bq_contract_detail.bd_chgord 

Additional Information

Â