/** * @return the name that this SelectItem can be referenced with, if referenced from a super-query. This will usually * be the alias, but if there is no alias, then the column name will be used. */ public String getSuperQueryAlias() { return getSuperQueryAlias(true); }
/** * @return the name that this SelectItem can be referenced with, if referenced from a super-query. This will usually * be the alias, but if there is no alias, then the column name will be used. */ public String getSuperQueryAlias() { return getSuperQueryAlias(true); }
@Override public String getColumnName(int column) { return _selectItems.get(column).getSuperQueryAlias(false); }
@Override public String getColumnName(int column) { return _selectItems.get(column).getSuperQueryAlias(false); }
private List<String> createColumnHeaderList(SelectItem[] selectItems) { final List<String> columns = new ArrayList<>(); for (SelectItem selectItem : selectItems) { final String label = selectItem.getSuperQueryAlias(false); columns.add(label); } return columns; }
private void appendJoinOnItem(StringBuilder sb, String sideAlias, SelectItem onItem) { final FromItem fromItem = onItem.getFromItem(); if (fromItem != null && fromItem.getSubQuery() != null && fromItem.getAlias() != null) { // there's a corner case scenario where an ON item references a // subquery being joined. In that case the getSuperQueryAlias() // method will include the subquery alias. final String superQueryAlias = onItem.getSuperQueryAlias(); sb.append(superQueryAlias); return; } if(_join != null && _leftSide.getJoin() != null) { sb.append(onItem.toSql()); return; } if (sideAlias != null) { sb.append(sideAlias); sb.append('.'); } final String superQueryAlias = onItem.getSuperQueryAlias(); sb.append(superQueryAlias); }
private void appendJoinOnItem(StringBuilder sb, String sideAlias, SelectItem onItem) { final FromItem fromItem = onItem.getFromItem(); if (fromItem != null && fromItem.getSubQuery() != null && fromItem.getAlias() != null) { // there's a corner case scenario where an ON item references a // subquery being joined. In that case the getSuperQueryAlias() // method will include the subquery alias. final String superQueryAlias = onItem.getSuperQueryAlias(); sb.append(superQueryAlias); return; } if(_join != null && _leftSide.getJoin() != null) { sb.append(onItem.toSql()); return; } if (sideAlias != null) { sb.append(sideAlias); sb.append('.'); } final String superQueryAlias = onItem.getSuperQueryAlias(); sb.append(superQueryAlias); }
public StringBuilder toStringNoAlias(boolean includeSchemaInColumnPath) { final StringBuilder sb = new StringBuilder(); if (_column != null) { sb.append(getToStringColumnPrefix(includeSchemaInColumnPath)); sb.append(_column.getQuotedName()); } if (_expression != null) { sb.append(_expression); } if (_fromItem != null && _subQuerySelectItem != null) { if (_fromItem.getAlias() != null) { sb.append(_fromItem.getAlias() + '.'); } sb.append(_subQuerySelectItem.getSuperQueryAlias()); } appendFunctionSql(sb); return sb; }
public StringBuilder toStringNoAlias(boolean includeSchemaInColumnPath) { final StringBuilder sb = new StringBuilder(); if (_column != null) { sb.append(getToStringColumnPrefix(includeSchemaInColumnPath)); sb.append(_column.getQuotedName()); } if (_expression != null) { sb.append(_expression); } if (_fromItem != null && _subQuerySelectItem != null) { if (_fromItem.getAlias() != null) { sb.append(_fromItem.getAlias() + '.'); } sb.append(_subQuerySelectItem.getSuperQueryAlias()); } appendFunctionSql(sb); return sb; }
final SelectItem[] selectItems = dataSet.getSelectItems(); for (SelectItem selectItem : selectItems) { final String label = selectItem.getSuperQueryAlias(false); writer.write("<th>"); writer.write(StringEscapeUtils.escapeXml(label));