How to change aliases for query output columns programmatically?
Last modified:
The following example adds aliases for the fields of the main query in case an alternate name is defined for a field and its alias is empty.
UnionSubQuery unionSubQuery = queryBuilder1.SQLQuery.QueryRoot.FirstSelect();
unionSubQuery.BeginUpdate();
try
{
for (int i = 0; i < unionSubQuery.QueryColumnList.Count; i++)
{
QueryColumnListItem ci = unionSubQuery.QueryColumnList[i];
if (ci.ExpressionField != null) // the criteria item is bound to a metadata field
{
if (ci.AliasString.Length == 0 && ci.ExpressionField.AltName.Length > 0)
{
ci.AliasString = ci.ExpressionField.AltName;
}
}
}
}
finally
{
unionSubQuery.EndUpdate();
}