/// <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); }