/// <summary>
/// Adds the checklist join.
/// </summary>
/// <param name="sql">The SQL.</param>
/// <param name="join">The join.</param>
/// <param name="aliasCollection">The alias collection.</param>
private void AddChecklistJoin(StringBuilder sql, ChecklistFieldDefinition join, TableAliasCollection aliasCollection)
{
sql.AppendLine()
.Append("\t")
.AppendFormat(
"INNER JOIN \"{0}\" {1} ON {1}.\"{2}\" = {3}.\"{4}\"",
OracleNamesTranslator.Translate(GetJoinTableName(join)),
aliasCollection.GetJoinTableAlias(join),
OracleNamesTranslator.Translate(GetJoinTableMasterKey(join)),
aliasCollection.GetTableAlias(join.DeclaringProcess),
OracleNamesTranslator.Translate(Constants.IdColumnName))
.AppendLine()
.Append("\t")
.AppendFormat(
"INNER JOIN \"{0}\" {1} ON {1}.\"{2}\" = {3}.\"{4}\" AND {1}.\"{5}\" = 0",
OracleNamesTranslator.Translate(join.ReferencedProcess.SystemName),
aliasCollection.GetTableAlias(join.ReferencedProcess),
OracleNamesTranslator.Translate(Constants.IdColumnName),
aliasCollection.GetJoinTableAlias(join),
OracleNamesTranslator.Translate(GetJoinTableChildKey(join)),
OracleNamesTranslator.Translate(Constants.IsRemovedColumnName));
}
private void AddChecklistJoin(StringBuilder sql, ChecklistFieldDefinition join, TableAliasCollection aliasCollection)
{
sql.AppendLine()
.Append("\t")
.AppendFormat(
"INNER JOIN [dbo].[{0}] {1} ON {1}.[{2}] = {3}.[{4}]",
GetJoinTableName(join),
aliasCollection.GetJoinTableAlias(join),
GetJoinTableMasterKey(join),
aliasCollection.GetTableAlias(join.DeclaringProcess),
Constants.IdColumnName)
.AppendLine()
.Append("\t")
.AppendFormat(
"INNER JOIN [dbo].[{0}] {1} ON {1}.[{2}] = {3}.[{4}] AND {1}.[{5}] = 0",
join.ReferencedProcess.SystemName,
aliasCollection.GetTableAlias(join.ReferencedProcess),
Constants.IdColumnName,
aliasCollection.GetJoinTableAlias(join),
GetJoinTableChildKey(join),
Constants.IsRemovedColumnName);
}
